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

Document ID : KB000018459
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When generating a Report in Spectrum Report Manager (SRM) all Alarm Titles are showing up as unknown.
Error message seen in the catalina.out "Can't find bundle for base namecom.aprisma.spectrum.app.web.servlet.ApplicationInfo, locale en_GB"
Can be further verified from mysql by logging into the reporting database and issue the following command:
mysql> select title from alarmtitle;
The alarmtitles will return 'unknown'.

Solution:

  1. Stop tomcat: /apps/spectrum/tomcat/bin/stopTomcat.sh

  2. Reinitialize the SRM landscape:

    /apps/spectrum/bin/RpmgrInitializeLandscape.sh root root -initHist 90 -all

  3. Connect to MySQL to flush the alarmtitle table:

    1. /apps/spectrum/mysql/bin/mysql --default-file=../my-spectrum.cnf -uroot

      -proot reporting

    2. truncate alarmtitle;

  4. Create a file setenv.sh in the /apps/spectrum/tomcat/bin directory: vi

    /apps/spectrum/tomcat/bin/setenv.sh

  5. Fill the created file with those 2 lines:

    1. LANG=en_US.UTF-8

    2. export LANG

  6. Set the correct permissions on the file: chmod 750

    /apps/spectrum/tomcat/bin/setenv.sh

  7. Start tomcat: /apps/spectrum/tomcat/bin/startTomcat.sh

After Tomcat has completed startup you should start seeing AlarmTitles being populated in the mysql database with the following mysql command:

mysql> select title from alarmtitle;