BO Launchpad Issue-Database unexpected error

Reset the BO Administration Password

Issue: 

The password for the administrator password is lost and there is no other account with administrator rights to log in the CMC and reset the password for this user

Resolution:

warning: The following resolution involves modifying your installation and Central Management Server (CMS) database. Please take a full backup of your installation and CMS database before proceeding.

1.      Use the Central Configuration Manager (CCM) to stop the Server Intelligence Agent (SIA).

>> To launch the CCM, go to Programs > SAP Business Intelligence > SAP BusinessObjects BI Platform 4 > Central Configuration Manager. Once you have confirmed that the SIA has stopped, proceed to the next step.

2.      Open Properties of the SIA. Copy the entire command line.

ex: 

      -boot "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.bootstrap" -port "6410" -dbinfo "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.dbinfo" -noauditor -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -traceinipath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/conf/BO_trace.ini" -name "WINC93I1FL0ODI" -piddir "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/"

3.      Open a "Command Prompt" window, enter the full path to the CMS.exe, and paste in the contents from step 2.

ex: 

          "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\cms.exe" 

4.      Append -serverconsole switch to the command and press Enter. For example, note that the following command has -serverconsole appended:

"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\cms.exe" -boot "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.bootstrap" -port "6410" -dbinfo "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.dbinfo" -noauditor -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -traceinipath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/conf/BO_trace.ini" -name "WINC93I1FL0ODI" -piddir "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/" -serverconsole

         The CMS is launched in serverconsole mode. You will be prompted when the CMS is ready to accept commands.

5.      Go to the following folder: <BOE_INSTALL_DIR>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dfo 

        The dfo folder contains a subfolder with a randomly generated name starting with dfo_.


      

6.      Copy the file named BusinessObjects_Administrator_dfo.xml from inside the dfo_ folder to the following folder: <BOE_INSTALL_DIR>\SAP BusinessObjects Enterprise XI 4.0\packages

7.      Enter the following query: 

        select si_id from ci_systemobjects where si_name='Administrator' Record the SI_ID for the object.
Tip: SI_ID should be 12.

8.      Delete the object by typing the following command: delete <ID_NUMBER>

ex: delete 12

9.      Verify that the objects have been deleted by re-entering the command from step 7: 

       select si_id from ci_systemobjects where si_name='Administrator'
No objects should be returned.

10.    Enter the following query: 

        select si_id from ci_systemobjects where si_name='BusinessObjects_Administrator_dfo.xml' One object should be returned. 


        Record the object's SI_ID number.

11.    Delete the object by entering the following command: delete <SI_ID>

12.    Type quit to exit.

13.    Use the CCM to start the SIA.

14.    Launch the CCM, go to Programs > SAP Business Intelligence > SAP BusinessObjects BI Platform 4 > Central Configuration Manager.


You can now log on to the administrator account without having to provide password (leave the "Password" field blank).

Fix the issue This copy of Windows is not genuine

Problem: This copy of windows is not genuine Sol: 1. Open Cmd prompt as "Run as Administrator" 2. Then type slmgr -rearm 3. Restart the machine

Project backup in IDT

To back up the project resources created in the information design tool:

1. Exit the information design tool.
2. On the local file system, navigate to the folder “%USERPROFILE%\.businessobjects\bimodeler_14\”. For
example:
C:\Documents and Settings\Administrator\.businessobjects\bimodeleter_14\
3. Rename the “workspace” folder to “workspace.bak”.

To restore the project resources from the backup in the information design tool:

1. Start the information design tool. A new workspace folder is created automatically.
2. Select “File/Open Project” from the main menu.
3. In the Import Existing Projects dialog box, Select the root directory and browse to the path of the
“workspace.bak” folder created in the backup procedure.
4. Select the projects you want to restore. 
5. Check the “Copy projects into workspace” check box and click Finish.