Alarm Titles are showing up correctly in Spectrum OneClick but are showing unknown in Report Manager.

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.

When generating a Report in Spectrum Report Manager (SRM) all Alarm Titles are showing up as unknown.

Can be further verified from mysql by doing the following:

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

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

3. cd to the $SPECROOT/mysql/bin directory and enter the following command to log into mysql:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting

4. At the mysql prompt, enter the following command:

mysql> select title from alarmtitle;

4. Check for the alarmtitles to return 'unknown'.

Environment

Release: Any
Component: Spectrum Report Manager (SRM)

Resolution

To resolve this issue:

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

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

3. cd to the $SPECROOT/tomcat/bin directory and enter "./stopTomcat.sh" to shutdown tomcat

4. cd to the $SPECROOT/bin directory and reinitialize the the SRM landscape by entering the following command:

./RpmgrInitializeLandscape.sh root <PASSWD> -initHist 90 -all

5. cd to the $SPECROOT/mysql/bin directory and log into mysql by entering the following command:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> reporting

6. Enter the following command to flush the alarmtitle table:

truncate alarmtitle;

7. cd to the $SPECROOT/tomcat/bin directory and enter "./startTomcat.sh" to start tomcat

8. After tomcat has completed startup, log into mysql and enter "select title from alarmtitle;" at the mysql prompt to verify the issue has been resolved.