Support Article
Unable to log in to the application
SA-98652
Summary
Multiple users cannot log in to the system.
Error Messages
THE USER DOESN'T EXIST IN PEGA APPLICATION. PLEASE CONTACT THE SYSTEM ADMINISTRATOR FOR ACCESS
com.pega.pegarules.pub.database.DatabaseException: ORA-01000: maximum open cursors exceeded
Steps to Reproduce
Not Applicable
Root Cause
A defect or configuration issue in the operating environment.
The database cursors leaked on one node. As a result, the node is unusable. However, the traffic still navigates to that node from the Load Balancer. It is determined that the sppr_reserve_queueitem_b stored procedure is up to date.
Resolution
Perform the following local-change:
- Restart the web tier nodes individually starting with the node with the most errors.
- Enable the Statspack to gather the required details should the situation recur.
- Install the current PegaAESRemote Predictive Diagnostic Cloud (PDC) code to enhance diagnostics of the database.
Published February 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.