Deleting and recreating the APS database

This procedure shows how to recreate (re-initialize) the current APS 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 Crystal Enterprise in a development environment for designing and testing your own, custom web applications. You can re-initialize the APS database in your development environment every time you need to clear the system of absolutely all its data.

Note:    

• Back up your current APS database before beginning this procedure. If necessary, contact your database administrator.
• After recreating the APS database, you will have to enter your 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.

To recreate the APS database on Windows

1. Use the CCM to stop the Crystal APS.
2. With the APS selected, click Specify APS Datasource on the toolbar.
3. In the APS 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 APS database setup is complete.

5. Click OK.

   You are returned to the CCM.

6. Start the Crystal APS.

   While it is starting, the APS 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 APS has successfully started.

To recreate the APS database on UNIX

Use the apsdbsetup.sh script. For reference, see apsdbsetup.sh.