Support Article

ORA-01000: Maximum number of open cursors exceeded

SA-30012

Summary



After the upgrade to Pega 7.2, user gets many errors on DB level, related to the open cursors.
The SQL showing the highest number of open cursors (500-up) is:


select pzInsKey as "pzInsKey" , pxLockhandle as "pxLockHandle" from RULES.pr_sys_locks where pxOwnerID = ?


Error Messages




ORA-01000: maximum open cursors exceeded


Steps to Reproduce



Not applicable


Root Cause



Below two defects in PRPC caused cursor leaks: 
  • Cursor leaks are observed in LockManagerImpl code where prepared statement in not being closed and cursors are being held. 
  • Stored procedure SPPR_SYS_RESERVEQUEUEITEM_B does not close the cursors.


Resolution



Apply HFix-29955to avoid the error message.

 

Published November 4, 2016 - Updated November 14, 2016


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.