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'.
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.