1. Home
  2. Support
Article - CS91296

ERROR: ORA-01000: maximum open cursors exceeded in PTC RV&S/Integrity Lifecycle Manager

Modified: 19-Aug-2024   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 10.1 to 13.2.0.1

Description

  • ERROR: ORA-01000: maximum open cursors exceeded on installing ALM solution
  • Error installing ALM Solution in Integrity Administrator Client: ORA-01000: maximum open cursors exceeded
  • Error: Solution installation failed: A migration error occurred while processing Assign UUSID to Field Pending Change Order Count with Oracle 11g Database
  • Installing ALM solution failes with error:
    • Solution installation failed: A migration error occurred while processing the "Assign UUSID 90dae637-e0d4-4a61-a58f-703196449fca to Field Closed Chang Order Count for Project" : MKS131372: An unhandled database exception has occurred. Please contact your administrator. 
      The error supplied by the database is:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01000: maximum open cursors exceeded
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01000: maximum open cursors exceeded
      ORA-01000: maximum open cursors exceeded
  • In DEBUG and SQL logging enabled server log, below error is observed :
    • 2022-12-23 10:48:09,110 INFO  [mksis.IntegrityServer] SQL(5): <username>[RMI Executor-thread-29]: SID375: SQLException: ORA-01000: maximum open cursors exceeded
      : error code=1000, state=72000
    • ....
    • 2022-12-23 10:48:09,114 DEBUG [mksis.IntegrityServer] DEBUG(5): <username>[RMI Executor-thread-29]: mks.ci.exception.CIException: MKS131372: An unhandled database exception has occurred.  Please contact your administrator.  (<username>[RMI Executor-thread-29]) -- java.sql.SQLException: MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
This is a printer-friendly version of Article 91296 and may be out of date. For the latest version click CS91296