Spectrum Archive Manager will not stay running

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

We noticed the Spectrum Archive Manager on one of the SpectroSERVER systems was not running.

When we try to start it, it will not stay running.

We see the following error in the $SPECROOT/SS/DDM/ARCHMGR.OUT file:

ERROR Trace at ModelArchDBImp.cc(5026): doSqlQuery/mysql_query: Failure executing query. - Lost Connection to mySQL server during query.

We verified the following:

• MySql is running
• We can log into MySql from the command line using both the root and SPEC_admin user
• We can run queries as either user when logged into MySql
• No error seen in the MYSQL.OUT file

We ran "./ArchMgr -repair" from the $SPECROOT/SS/DDM directory and it did find corruption, however, it was not able to repair the database successfully.

Environment

Version: Any
Component: Archive Manager

Cause

ArchMgr database corruption

Resolution

We were able to resolve the issue by doing the following:

• Log into the system as the user that owns the Spectrum installation
• If running on Windows, run "bash -login"
• cd to the $SPECROOT/SS/DDM directory and run the following command to backup the database:

./ddm_save.pl -f ArchMgrBU

• Run the following command to re-initialize the database where <LH> is the landscape handle for this Spectrum installation:

./ddm_load.pl -il <LH>

• Reply "y" to the next two queries
• Run the following command to load the previously saved database:

./ddm_load.pl -f ArchMgrBU.mbi

• cd to the $SPECROOT/SS/bin directory and run the following command to start the ArchMgr:

./startSS.pl

Additional Information

If the Archive Manager still fails to start, please open a case with Spectrum Support for further assistance.