Troubleshooting

This section contains the following topics:

CIC Connection Release Error

The CA Content Import Client (CIC) can sometimes fail to release its connection to the Oracle MDB resulting in the following error in the CIC log:

[CCMain] WARN  [com.ca.sccc.dbm.CCDBManager] - Failed to uninitialize MDB connection pool for domain 'xxx'

Content Download Fails on Oracle MDB

Symptom:

The Content Download Job on Oracle MDB fails after a fresh installation on the Domain Manager/Enterprise Manager, with the following errors in the CIC logs.

ORA-00604: error occurred at recursive SQL level

ORA-01000: maximum open cursors exceeded

Solution:

This occurs during the execution of the Content Import Client, if the number of open cursors is exceeding the maximum limit as defined on the Oracle database.

You can modify the upper limit for open cursors from default 50 to a higher value.

Execute the following on the oracle MDB:

ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;

This sets the upper limit of open cursors to 1000.

Note: Upper limit allows to open the cursors as CIC requires and closes after it terminates.

DSM Engine Crashes When the Database is Stopped

Symptom:

When I stop the database for maintenance, for example, to take a backup, the engine processes sometimes crash.

Solution:

Verify that you have stopped all the engine processes before you stop the database for maintenance.

Note: If an engine process crashes during the database maintenance, restart the engine process after you restart the database.