Skip to Content

Change Audit and CMS Database on 2 cluster servers


Please I have 2 clustered bobj 3.1 sp 6 servers on windows I need to change the audit and cms database.

can anyone guide me ??

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 10, 2016 at 11:19 AM


    To change source for you CMS the option is provided within SIA, see below:

    • Create NEW ODBC to CMS of ALL BOBJ Server
    • STOP SIA on 2nd BOBJ Server
    • STOP SIA on 1st BOBJ Server and follow steps below
      • Go to Config TAB
      • Select COPY
      • Select ODBC for ORIGINAL CMS
      • Select ODBC for NEW CMS
      • Click OK
    • Confirm CMS working from 1st Server only

    Change Audit DB, as follows:

    • Create NEW ODBC Source for Audit on ALL BOBJ Servers
    • STOP SIA on 1st, change datasource for Audit to NEW ODBC
    • START SIA. 2nd Server SIA Still STOPPED
    • Confirm BLANK Audit Tables have been created
    • STOP the SIA, 2nd Server SIA still STOPPED
    • Use standard Database copy tool to copy content from original Audit to NEW Audit tables
    • Once all copied, you are ready to now start using the NEW CMS & NEW Audit DB

    Confirm all works from 1st server by starting the SIA.

    Now on 2nd BOBJ Server, you are going change CMS datasource

    For Audit you also update to NEW Audit db.

    All done



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.