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

Article Id: 18459

Status: Published

Updated On: 05-12-2019 08:42

Products:

CA Spectrum - OneClick , CA Spectrum - Reporting , CA Spectrum - Integrations , CA Spectrum - Alarms & Event Management

Issue/Introduction:

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 -proot 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:
Component:

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 root -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 -proot 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.