000034161 - Unable to run reports,view reports or modify existing reports filter criteria due to error ORA-01000: maximum open cursors exceeded in RSA Via Lifecycle and Governance

Document created by RSA Customer Support Employee on Oct 11, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034161
Applies ToRSA Product Set: RSA Identity Management and Governance
RSA Version/Condition: 6.9.1 P09, P10, P11
 
IssueThis issue has been identified  with RSA IMG 6.9.1 P09, P10 and P11  where users were unable to run reports,view reports or modify existing reports filter criteria due to the following error:

ORA-01000: maximum open cursors exceeded
 

User-added image

User-added image
CauseThis is a bug where where statements are left open.  The Java code is not closing the cursor and session.  
 
ResolutionDeploy patch 6.9.1 P12 to resolve this issue.

Attachments

    Outcomes