Reset BO4.0 - CMC Administrator Password

[Former Member]

Hi Experts,

I got this situation. I forgot CMC Administrator account password and I tried to reset using the resolution steps provided SAP.

Symptom:

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:

The steps required to perform are detailed in the Installation guide attached in the references section. However, there is one mistake in the order of the steps.

Page 71: Chapter 5.9.1 To reset the SAP BusinessObjects Business Intelligence platform administrator account password

1. Locate the CMS process: launch the Process Explorer utility, and locate CMS.exe.

2. Copy the CMS command to the clipboard. In Process Explorer, copy the "Command line" field.

3. Use the Central Configuration Manager (CCM) to stop the SIA. To launch the CCM, go to Programs > SAP BusinessObjects Enterprise

XI 4.0 > SAP BusinessObjects Enterprise > Central Configuration Manager. Once you have confirmed that the SIA has stopped,

proceed to the next step.

4. Paste the CMS command to a command-line. Do not press Enter. Open a "Command Prompt" window and paste in the contents from step3.

5. Append the -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" -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

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

6. 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_.

7. 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

8. Enter the following query: select si_id from ci_systemobjects where si_name='Administrator' Four objects are returned. Record the

SI_ID for each object.

Tip: 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. Verify that the objects have been deleted by re-entering the command from step 8: select si_id from ci_systemobjects where

si_name='Administrator'

No objects should be returned.

11. 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.

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

13. Type quit to exit.

14. Use the CCM to start the SIA.

15. Launch the CCM, go to Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects Enterprise > Central Configuration Manager.

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

I started performing the steps in the server console. But I got confused from step 8. On performing step 8, it returned the objects as in below image.

As i'm a novice user of BODS, I didn't understand step9 and started deleting the objects using delete command(delete 19, delete 12) and i verified that no objects are returned in step10, I proceeded further performing step 11 which gave me the objects as in below image.

This time I gave only delete 364 command, exited console and restarted CMC. But the problem persists. Where did I go wrong? In step 8 it showed in resolution that 4 objects will be returned. But for me, it returned 12 objects. I think I have screwed up something. I repeated the steps with no resolution. Could anyone explain what's going on.Please do the needful. Any help is much appreciated.

[former_member926196]

Hi Shalem,

When you perform the steps, initially you need to stop the SIA so that the CMS is completely stopped.

Once it's stopped, you need to start the CMS in server console mode and run the select queries to retrieve the SI_ID of the administrator and then delete only the SI_ID which is 12. Run the select query to retrieve the SI_ID for the adminstrator_dfo xml file and delete only the SI_ID

You can then exit the server console mode and start the SIA in order to start the CMS.

Once the CMS is started, go to CCM >> Manage Server and enter username as administrator. Do Not Enter any password as the password is blank. All you need is to only press Enter or click on login button.

It should be able to log you in with blank password.

In case if you have any id which is a part of administrator group, you can login to CMC >> User and Groups and change administrator password.

-Ambarish-

[Former Member]

Hi Ambarish,

Thanks for your reply. I've got a new problem here. When I tried to reperform the steps(from begining) and ran this query "select si_id from ci_systemobjects where si_name='Administrator' ", it didn't returned any objects this time. Thinking that deleting the object previously and haven't set any admin password yet might have caused this, I proceeded further and had run the below query in order to retrieve si_id to delete it:

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

it returned an object with si_id=1338. I deleted only the si_id, exited the console, restarted CMS through CCM. But when I try to logon to administrator through CCM>>Manager Server. It showing an error stating "connection cannot be established".

I think I have made a mistake in my first attempt. when the objects showed for the first time(image below shows the objects retrieved on my first attempt), instead of deleting the si_id(delete 12), i deleted si_parentid(delete 19) first and later deleted si_id(delete12). Could this be a problem?

Please do reply.

Thanks

Shalem

[former_member207052]

Sounds like your CMS is not up yet. Open command and try starting SIA manually to see any meaningful error/success message (you can see system events too). Make sure your CMS db is still accessible and not offline (you can simply test this by opening ODBC connection and then test the CMS DSN)

Restarting the entire box is also not a bad option in my opinion.

If it is up, try loggin on to CMC http://localhost:8080/BOE/CMC with Administrator and Blank password, and make sure you change the password that you can remember.

Regards,

Naras

[amitrathi239]

If your administrator kept the same password for LCM repository at the time of installation and administrator password haven’t changed after installation  then you can get the password from conf folder.

location in “installation location/enterprise_xi40/LCM_repository /conf and open the file “passwd”.See the value of LCM=

[Former Member]

Hi Amit,

Thanks for your reply. I have tried the resolution you have provided. Unfortunately, it didn't work out. seems like the administrator password and LCM repository password are not the same, but helpful though. worth giving a try.