John Ezell (Gabuc000)
Development Manager
Gabuc000 Member since 2012 5 posts
Posted: April 24, 2018
Last activity: April 25, 2018
Posted: 24 Apr 2018 9:20 EDT
Last activity: 25 Apr 2018 1:41 EDT

Oracle SQL query runs fast directly but dies executed through Pega

We have ran oracle sql queries in oracle directly, once as a SQL statement and then as a stored procedure. Both SQL processes run in about 120 seconds on 1 million records.

But when we execute the SQL statement or stored procedure in Pega, the DBA connector times out and locks up the database. We see Oracle-01013 alert which is oracle stopped due to user request. The SQL never finishes before having stuck threads, connection timeout, and a locked database table.

There is no output from the stored procedure or the SQL statement. We have enough connections, 10 minutes on time out of DBA connections in WebLogic.

I am at a lose at what to try next.

Low-Code App Development
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.