ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to start the Archive Manager after upgrading to Spectrum 21.2.8

book

Article ID: 239694

calendar_today

Updated On:

Products

CA Spectrum DX NetOps

Issue/Introduction

The following error is seen in the ARCHMGR.OUT file:

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.

Apr 18 11:21:03 : ArchMgr error opening database.

Cause

The $SPECROOT/SS/DDM/.configrc file had the wrong password in the DDM_DATABASE_PASSWORD parameter.

In 21.2.8, we removed the "DDM_DATABASE_PASSWORD=specadmin" parameter from the $SPECROOT/SS/DDM/.configrc file.

If you were to install 21.2.8 from scratch, you would not see this parameter in the .configrc file.

What looks like happened was the upgrade did not remove this entry from the file so the ArchMgr is trying to use the "specadmin"  password for the SPEC_admin user. The default password for the SPEC-admin user is "0n3cl1Ck"

Environment

Release : 21.2.8

Component : Spectrum Applications

Resolution

Remove the "DDM_DATABASE_PASSWORD=specadmin" parameter from the $SPECROOT/SS/DDM/.configrc file and start the ArchMgr .