Spectrum Archive manager fails to start due to a database corruption detected

Products

• CA Spectrum

Issue/Introduction

Spectrum Archive Manager fails to start due to a database corruption detected

Environment

Release: Any
Component:

Resolution

Execute the following recovery options in the order specified.

Repair the DDM database

This should be tried first as it will attempt to repair the existing database and if successful, there will be no data lost.

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/SS/DDM directory and enter the following command:

./ArchMgr -repair

4. If successful, cd to the $SPECROOT/bin directory and enter the following command to start the Archive Manger:

./startSS.pl

NOTE: The startSS.pl script starts both the SpectroSERVER and Archive Manager. If checks to see if they are already running and if they are, will not try starting a new one.

Load a recent DDM database save

If the repair is not successful and you are running regular backups of the DDM database, reload a recent database save. There will be some data loss from when the database save was run to when the reload of the database save was run.

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/SS/DDM directory and enter the following command where <DDM> is the name of the database save file to load:

./ddm_load <DDM>

4. If successful, cd to the $SPECROOT/bin directory and enter the following command to start the Archive Manger:

./startSS.pl

Initialize the DDM database

If the repair fails and you are not running regular DDM database backups, then you may have to initialize the DDM database.

1. Log into the SpectroSERVER system as the user that owns the Spectrum installation

2. If on Windows, start a bash shell by running "bash -login"

3. cd to the $SPECROOT/SS/DDM directory and enter the following command where <LH> is the landscape handle of the Spectrum installation on this system

./ddm_load - <LH>

4. If successful, cd to the $SPECROOT/bin directory and enter the following command to start the Archive Manger:

./startSS.pl

NOTE: To find the landscape handle of the Spectrum installation on this system, view the SSHANDLE parameter in the $SPECROOT/.installrc file