Oracle: Maximum number of cursors exceeded

[] [] [] [] [] [] [] [] [] [] [] [] []

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 …//JC/SDM/program/lib/util/slutil als File SLUtil.org. Then, copy the attached files to there.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment