Question

1
Replies
74
Views
PranithaRaoS Member since 2016 1 post
General Motors
Posted: May 7, 2018
Last activity: May 9, 2018
Closed

System Crashes on using Stored Proc or Connect SQL List

We are using Pega V7.2.1. We are trying to run a stored procedure as a RDB List: CALL data.UPDATE_batch_ID({.JobID}).

When running a large data set example: over a half million records, pega connector times out and leaves a global lock in the affected Oracle database table. The same query when called in SQL developer works fine and takes 90-110 seconds but does not work/ times out after approx 10 mins when running through pega.

***Edited by Moderator Marissa to update SR Details***

Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn