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.