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

 Markonda Pradeep (Pmarkonda)
WorldbankGroup

WorldbankGroup
IN
Pmarkonda Member since 2016 1 post
WorldbankGroup
Posted: Jan 3, 2017
Last activity: Jan 3, 2017
Posted: 3 Jan 2017 4:14 EST
Last activity: 3 Jan 2017 4:21 EST
Closed

How to Resolve "ORA-01000: maximum open cursors exceeded" exception

Hi,

When i try to login in Dev and higher envirounments, i am getting the exception like  "There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded : code". Please help us to resolve this exception.

Thanks in Advance

To see attachments, please log in.
System Administration

Posted: 8 years ago
Posted: 3 Jan 2017 4:21 EST
Nishan Kaluthekkal (NishanK8)
AGCS
Pega Certified Lead System Architect - System Architect (SAFe)
AGCS
DE

Hi Pmarkonda,

Couple of approaches you need to try to resolve this:

1. Can you try upgrading the driver version to OJDBC6 or later.

2. Pega bug https://community.pega.com/support/support-articles/ora-01000-maximum-number-open-cursors-exceeded

 

regards,

Nishan

 

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