Question

9
Replies
1320
Views
Close popover
promil pandey (promilp8)
wellcare
promil pandey
wellcare
US
promilp8 Member since 2015 12 posts
wellcare
Posted: April 20, 2017
Last activity: May 29, 2017
Closed
Solved

Maximum open cursors exceeded: PEGA_DATA_SPPC_DATA_UNIQUEID

Hello,

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