search cancel

Spectrum Report Manager (SRM) not finished starting

book

Article ID: 133257

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Spectrum Report Manager (SRM) not finished starting. The following error is seen in the $SPECROOT/tomcat/logs/stdout.log (Windows) or catalna.out (Linux):

ERROR 1146 (42S02) at line 21 in file: '/opt/spectrum/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_v_dim_device_module.sql': Table 'reporting.devicemodule' doesn't exist

Cause

The devicemodule table in the reporting database is missing or corrupt.

Environment

Release: 10.2.0 and above


Component: Spectrum Report Manager (SRM)

Resolution

Rebuild the devicemodule table in the reporting database on the SRM system.

The first step is to find out how the devicemodule table is built. Do the following on an SRM system that has the same Spectrum version and patch level installed:

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

2. Stop the Spectrum Tomcat service

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

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

5. Enter the following command at the mysql prompt to find out how the devicemodule table in the reporting database is built:

./show create table devicemodule;

6. The following is an example of the output from the above command:

| devicemodule | CREATE TABLE `devicemodule` (

  `module_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `model_key` int(10) unsigned DEFAULT NULL,

  `module_index` int(10) DEFAULT NULL,

  `module_name` varchar(255) DEFAULT NULL,

  `serial_nbr` varchar(255) DEFAULT NULL,

  `software_rev` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`module_id`),

  KEY `key_idx` (`model_key`,`module_index`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |


The next step is to recreate the table on the SRM system where the issue is seen:

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

2. Stop the Spectrum Tomcat service

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

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

5. Enter the following command at the mysql prompt to drop the current devicemodule table in the reporting database:

drop table devicemodule;

6. Enter the following command at the mysql prompt to rebuild the table based on the information from the other system. The following is an example:

CREATE TABLE `devicemodule` (`module_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `model_key` int(10) unsigned DEFAULT NULL, `module_index` int(10) DEFAULT NULL, `module_name` varchar(255) DEFAULT NULL, `serial_nbr` varchar(255) DEFAULT NULL, `software_rev` varchar(255) DEFAULT NULL, PRIMARY KEY (`module_id`), KEY `key_idx` (`model_key`,`module_index`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

7. Enter the following command at the mysql prompt to ensure the table has been created:

show create table devicemodule;

8. If there are no errors in the creation of the devicemodule table, exist mysql by entering "quit" at the mysql prompt

9. Start Spectrum Tomcat and review the stdout.log (Windows) or catalina.out (Linux) file for the error.