Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

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

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.

To see attachments, please log in.
Low-Code App Development

  • Abhishek Anand
Posted: 6 years ago
Posted: 25 Apr 2018 1:41 EDT
Krishnamurthy Rajendra (rajek)
PEGA
Lead Service Assurance Advisor
Pegasystems Inc.
AU

Can you please let us know the exact SQLs statement being run? I understand that you may be running the queries using the connect-SQL rule. Please provide the screenshot of the same and log file snippet.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice