Error in generating DBDefinition

Products

• CA Process Automation Base
• Process Automation Manager

Issue/Introduction

When trying to start the secondary orchestrator we are seeing this error in the c2o.log file

<date> <time> ERROR [com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [main] Error in generating DBDefinition The database of type:<db name>belongs to another orchestrator with uuid:#######.Please reinstall/reconfigure the orchestrator to point to a different database
<date> <time> ERROR [com.optinuity.c2o.ddlgenerator.C2ODDLGenerator] [main] Error occurred while adjusting DB definitionjava.lang.Exception: Error occurred while adjusting DB
<date> <time> ERROR [com.optinuity.c2o.server.ServerController] [main] Failed to initialize DDL
java.lang.Exception: Error occurred while adjusting DB
<date> <time> ERROR [com.optinuity.c2o.server.ServerController] [main] Server Manager Failed to boot - timeout waiting for database structure adjustment

Environment

ITPAM 4.x

Cause

This can happen after the ITPAM database has been moved.

Resolution

For all orchestrators in the cluster, re-run the installation, selecting to update the configuration.  Confirm that the correct hostname, port number and credentials for the ITPAM database have been provided for all 3 of the databases.