promilp8 Member since 2015 11 posts
Posted: 3 years ago
Last activity: 3 years 3 months ago

Maximum open cursors exceeded: PEGA_DATA_SPPC_DATA_UNIQUEID


We are getting the below issue in our UAT environment. Its intermittent, and only happening in UAT environment. Please check the attached screenshot as well.

Unable to Obtain Unique ID: Problem encountered executing a stored procedure: code:1000 SQLState: 72000 Message: ORA- 01000: maximum open cursor exceeded

I have already checked the cursor configuration and its exactly same in all other environment. But the problem is happening in one environment only.

There is no mismatch in JDBC driver and DB version as well. Restarting the server solves the problem for some time and it comes again.

I have also followed up on other posts as well but most of them saying same thing to check the driver. Dont know what is causing the issue.

***Moderator Edit: Vidyaranjan | Updated Categories***

***Updated by Moderator: Marissa to add SR Details***

Low-Code App Development System Administration SR Created
Moderation Team has archived post
Share this page LinkedIn