Engine failed to start and you get error in log"Error: Unable to Find Manager in Database"

Document ID : KB000027228
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptom:

An attempt to start the engine fails immediately and the following message is found in the TRC_CMENGINE.log:

"Unable to Find Manager in Database

ReadEngineInfo Failed

Engine Stopped"

 

Environment: 

All Supported Windows platforms

CA Client Automation 12.8 , 12.9 

All Supported versions of MSSQL

 

Cause: 

The cause of the problem noted in this document can be related to the existence of duplicate rows in the ca_manager table.

A duplicate may be in the form of either rows pointing to the same host or rows with the same domain_uuid.

 

 

Resolution:

To check for the above, run the following command via SQL Management Studio and go into SQL Query Analyzer, against the MDB:

select * from ca_manager

Where a duplicate exists, then it will need to be removed by following the steps detailed below:

  1. Stop caf

  2. Remove the incorrect entry by using SQL Query Analyzer, using the ca_itrm user account by running one of the following commands:

    1. Where a duplicate host exists:

      DELETE FROM ca_manager WHERE host_name = '<HOST_NAME>'

    2. Where a duplicate domain_uuid exists:

      DELETE FROM ca_manager WHERE domain_uuid = '<DOMAIN_UUID>'

  3. Restart caf

 

Additional Information:

For more information on supported versions of MSSQL and CA Client Automation please consult our CA Client Automation Compatibility Matrix at this link:

https://support.ca.com/irj/portal/anonymous/phpsupcontent?contentID={5388D4CA-E235-4113-9EE5-CC5C038AB99E}