Skip to Content
avatar image
Former Member

BO4.1 CMS doesn't up due to corrupt object in CMS DB

Hello Everyone

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.

Regards,

Gansha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 30, 2015 at 10:42 AM

    Dear Gansha,

    Did you try to use the Repository Diagnostic Tool against repository database?

    Location


    <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\reposcan.exe


    Example Command

    reposcan -dbdriver oracledatabasesubsystem -connect "UID=BO_REPOSITORY_DB_USER;PWD=PASSWORD;DSN=TNS_ENTRY;PORT=NETWORK_PORT" -inputfrsdir %DefaultInputFRSDir% -outputfrsdir %DefaultOutputFRSDir% -dbkey "CLUSTER_KEY"

    Note: You need to modify the values in Italic. If you want to automatically repair any inconsistencies add -repair switch on the end of the aforementioned command. I suggest you to run the command without -repair the first time in order to have a look at the results.

    More Information

    Document: Business Intelligence Platform Administrator Guide

    Chapter 28 - Repository Diagnostic Tool

    Regards,

    ilias

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 12:31 PM

    Ganesha,

          Did you check the database size to see if you have enough free space and also check TEMP space.

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

    • Ganesha,

         If have allocated enough extra space for your CMS and FRS then your best option is to run the REPOSCAN.exe tool.  This tool will help recover any lost indexes and resolve corruption between CMS & FRS.

      • First run the tool in SCAN mode to see all issues
      • Then run in REPAIR mode to resolve issues.

      Ajay