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


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


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

  2. Reinitialize the SRM landscape:

    /apps/spectrum/bin/ 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 in the /apps/spectrum/tomcat/bin directory: vi


  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


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

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;