5.2.0a Ent - Oracle 10g - Repair tasks causing 'maximum open cursors' error

[RichW]

SunOS 10
Sugar ENT 5.2.0a
Apache 2.0.53
PHP 5.2
Oracle 10g

When running repair tasks such as "Repair Workflow" or "Repair Database" (db-heavy repair tasks), I get the following error continuously:

[exec] Warning: oci_execute(): ORA-00604: error occurred at recursive SQL level 1
[exec] ORA-01000: maximum open cursors exceeded
[exec] ORA-00604: error occurred at recursive SQL level 1
[exec] ORA-01000: maximum open cursors exceeded
[exec] ORA-00604: error occurred at recursive SQL level 1
[exec] ORA-01000: maximum open cursors exceeded in /apps/sugarcrm/include/database/OracleManager.php on line 216

Now, we have about 100 workflows defined and plenty of customizations in our vardefs that need to sync with the database, but by looking at this code I don't see anywhere where the "oci_free_statement()" is called to release some resources except for when the entire connection is closed.

For reference our Oracle max open cursors setting is set around 3000, above the default of 1000.

As well, this task tends to take a long time (over 15 minutes) to repair the database and workflows.

Any help would be appreciated.

[jimmyrayjit]

For Oracle 10G repair, today's latest and advanced Oracle Repair tools are available. You can choose any one and fix your issue.

Note: for more detail info you must visit at Oracle Forum