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.
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
Release : 21.2
Component : Spectrum Alarm
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.