BO4.1 CMS doesn't up due to corrupt object in CMS DB
we are using BO4.1 SP5 Patch 3 platform in windows, we have faced CMS DB issue two times within one month.
The problem is CMS doesn't up and it shows error message in Event Logs that due to corrupted object exist in CMS DB won't possible to up CMS server.
We don't know which object exactly corrupted and why it is corrupted. Until we manually delete the corrupted object from CMS DB we will not be possible restart CMS server
we will take the backup of corrupted object and deleted from CMS DB and then it restarted.
Now we want to find which object and its type, unfortunately I dont know the exact query to retrieve these information from CMS DB, anybody faced this problem before.
we are using oracle 11 CMS database.