Sunday, November 3, 2013

BusinessObjects-Reset Administrator Password

First download http://download.sysinternals.com/files/ProcessExplorer.zip

1. Go to the following directory: <INSTALLDIR>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dfo\

2. Copy the "BusinessObjects_Administrator_dfo.xml" to the following directory: <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\packages

3. Launch the Process Explorer utility, and locate the "CMS.exe" process. The SAP BusinessObjects Enterprise should be running.

4. Copy the contents of the "Command line" field.

5. Use the Central Configuration Manager (CCM) to stop the SIA. Once you have confirmed that the SIA has stopped, proceed to the next step.

6. Launch a command-line console and paste the contents from step 4. Do not press Enter !!!

7. Add "-serverconsole" to the end and press Enter. For Example

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" -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -port 6400 -restart -dbinfo "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_ACME.dbinfo" -noauditor -autoboot -fg -name ACME.cms -pidfile "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/ACME_ACME.CentralManagementServer.pid" -serverconsole

8. Type the following query and press Enter:

select si_id from ci_systemobjects where si_name='Administrator'

Four objects are returned. Record the SI_ID for each object. One of the entries should have the SI_ID set to 12.

9. Delete the objects by typing the following command for each object:

delete <id number>

10. Type again the following query to verify that the objects have been deleted:

select si_id from ci_systemobjects where si_name='Administrator'

No objects should be returned.

11. Type the following query:

select si_id from ci_systemobjects where si_name='BusinessObjects_Administrator_dfo.xml'

One objects is returned, record the object's SI_ID.

12. Delete the object by typing the following command:

delete <id number>

13. Type "quit" to exit the command-line console.

14. Use the CCM to start the SIA. You can now log on to the administrator account without having to provide password (leave the password field blank).

Saturday, November 2, 2013

BusinessObjects-Information Design Tool Backup Project Workspace

Here is the official SAP workaround for backup IDT project workspaces. Copied from "SAP BusinessObjects BI Suite 4.0 Support Pack 8 Release Notes, note 1922675"

Information design tool: Missing documentation on backing up and restoring project workspaces.

ADAPT01530987

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.