ODB services in OMi is failing to start by logging "[mercury][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (APMCMDB.PK_CDM_ADAPTER_CONFIG_1) violated

  • KM02946619
  • 12-Sep-2017
  • 04-Oct-2017

Summary

ODB service in OMi fails with unique constraint violated error in the startup.log . The DB view related to CDM_ROOT table was not accessible from the UD application because of this odb service was failing to start.

Question

ODB service in OMi fails with table not found error in the startup.log . The DB view related to CDM_ROOT table was missing from the DB schema.

We can see that " Root view does not exist. Link view does not exists. Creating empty model graph. " message being logged in cmdb.dal.log file.

Answer

In the UD database view exists but it was not accessbile to the DB user which is configured in the UD. 

We can see that  "Root view does not exist. Link view does not exists. Creating empty model graph. " message being logged in cmdb.dal.log file.

DB administratior couldn't list the views using the below sql query.

select view_name from user_views

Once customer proivded the complete permission for the DB user to access the DB views, odb service was able to start.