BusinessObjects Enterprise Administrator's Guide

Deleting and recreating the CMS database

This procedure shows how to recreate (re-initialize) the current CMS database. By performing this task, you destroy all data that is already present in the database. This procedure is useful, for instance, if you have installed BusinessObjects Enterprise in a development environment for designing and testing your own, custom web applications. You can re-initialize the CMS database in your development environment every time you need to clear the system of absolutely all its data.

When you recreate the CMS database with the CCM, your existing license keys should be retained in the database. However, if you need to enter license keys again, log on to the CMC with the default Administrator account (which will have been reset to have no password). Go to the Authorization management area and enter your information on the License Keys tab.

Note:    Remember that all data in your current CMS database will be destroyed if you follow this procedure. Consider backing up your current CMS database before beginning. If necessary, contact your database administrator.

To recreate the CMS database on Windows

1. Use the CCM to stop the Central Management Server.
2.  With the CMS selected, click Specify CMS Data Source on the toolbar.
3. In the CMS Database Setup dialog box, click Recreate the current Data Source.
4. Click OK and, when prompted to confirm, click Yes.

The SvcMgr dialog box notifies you when the CMS database setup is complete.

5. Click OK.

You are returned to the CCM.

6. Start the Central Management Server.

While it is starting, the CMS writes required system data to the newly emptied data source. You may need to click the Refresh button in the CCM to see that the CMS has successfully started.

To recreate the CMS database on UNIX

Use the cmsdbsetup.sh script. For reference, see the BusinessObjects Enterprise Administrator's Reference Guide.