Oracle: Maximum number of cursors exceeded
[COMPVERS] [Could] [cursors] [cursors xp] [custom cursors] [entries] [Error] [into] [new] [not] [open cursors] [update] [writing]
Symptom
The system component version store is not updated.
SQLException: ORA-01000: maximum open cursors exceeded
Other terms
Could not update: Error writing new entries into COMPVERS
Reason and Prerequisites
The system performs an action during which it uses the SLUtil (CVERS) library to write to the database. This generally occurs indirectly when you use the Software Delivery Manager (SDM) to use new versions. The error occurs only if the system has written a large volume of data to the database. This occurs in particular during the comparison of the SDM repository with the CVERS. In this case, the system generates an SQLException, the details of which refer to the Oracle error.
The problem occurs because when the system tries to write the DC data, it has to read the corresponding SC version data. As a result, an SQL statement is not (always) closed correctly. If the system writes or updates a large volume of data at the same time, the cursors can be used up for Oracle.
Solution
To solve the problem quickly, increase the number of cursors.
You can solve the problem by using the attached JAR file.
Before you do so, save the current version of SLUtil.jar under …/