Unable to log in to the application
Multiple users cannot log in to the system.
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
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.
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.
0% found this useful