Archive Manager does not start after upgraded to 21.2.8 - SPC-OCP-10067

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Spectrum was upgraded to 21.2.8 on 03/08/2022.

The following error is displayed in the SCP (Spectrum Control Panel):

SPC-OCP-10067: The Archive Manager has been shutdown because there was an error opening its database. The most likely causes: 
 1. The SQL database server is not running. 
 2. The username, password, hostname, or database name are not correct. 
 3. The database is invalid or corrupt.

In the $SPECROOT/SS/DDM/ARCHMGR.OUT file:

Mar 16 21:45:45 : ArchMgr started as user 'svc_xxx_yyyyy'
Mar 16 21:45:45 : ArchMgr validating database.
Error opening the DDM database. The most likely causes: 
 1. The SQL database server is not running. 
 2. The username, password, hostname, or database name are not correct. 
 3. localhost is not configured properly.
Mar 16 21:45:48 : ArchMgr error opening database.

Cause

There were two problems:

a) The process was not set to the Spectrum Install Owner account

In the $SPECROOT/.installrc file:
OWNER=spectrum

b) Password mismatch in the $SPECROOT/SS/DDM/.configrc file

In the $SPECROOT/SS/DDM/.configrc file and removed the following line:

DDM_DATABASE_USERNAME=SPEC_admin
DDM_DATABASE_HOSTNAME=localhost
DDM_DATABASE_PASSWORD=spectrum

Environment

Release : 21.2

Component : Spectrum Alarm

Resolution

a) Followed the steps in this KB article to change the processd account:

https://knowledge.broadcom.com/external/article/38207/what-are-the-commands-for-reinstalling-t.html

Customer had to supply the password enclosed in double-quotes instead of single-quotes.

The ArchMgr is now started by the spectrum account, but the same errors are displayed in the ARCHMGR.OUT file:

Mar 16 hh:mm:ss : ArchMgr started as user 'spectrum'
Mar 16 hh:mm:ss : ArchMgr validating database.
Error opening the DDM database. The most likely causes: 
 1. The SQL database server is not running. 
 2. The username, password, hostname, or database name are not correct. 
 3. localhost is not configured properly.
Mar 16 hh:mm:ss : ArchMgr error opening database.

b) Edit the $SPECROOT/SS/DDM/.configrc file and removed the following line:

DDM_DATABASE_PASSWORD=spectrum

Successfully started the Archive Manager.