Spectrum Report Manager (SRM) does not start after upgrade

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Spectrum Report Manager (SRM) does not start after upgrade

The following error was found in the $SPECROOT/tomcat/logs/stdout.log (Windows) or catalina.out (Liux):

Jul 13, 2018 03:12:57 PM (SRM/Startup/Container) (com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater) - (ERROR) - Error occurred while applying schema change 
Name: 1020 (Product version: 9.2.0) - Update and maintain all views in the reporting_api schema. 
com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: Error occurred while running schema change script. 
Script: D:\CA\Spectrum\Install-Tools\rpmgr\sql\srmdbapi\ddl\create_v_dim_device_module.sql 
Caused by: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: Error occurred while running schema change script. 
Script: D:\CA\Spectrum\Install-Tools\rpmgr\sql\srmdbapi\ddl\create_v_dim_device_module.sql 
Caused by: com.aprisma.util.mysql.ScriptRunnerException: Error occurred while running SQL script. 
Script: D:/CA/Spectrum/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_v_dim_device_module.sql 
Caused by: com.aprisma.util.mysql.ScriptRunnerException: Error occurred with SQL Script 
Script: D:/CA/Spectrum/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_v_dim_device_module.sql 
Stdout: 

Stderr: 
ERROR 1054 (42S22) at line 21 in file: 'D:\CA\Spectrum\Install-Tools\rpmgr\sql\srmdbapi\ddl\create_v_dim_device_module.sql': Unknown column 'dmo.physical_index' in 'field list' 

at com.aprisma.util.mysql.SQLScriptRunner.doRunSQLScript(SQLScriptRunner.java:251) 
at com.aprisma.util.mysql.SQLScriptRunner.runScript(SQLScriptRunner.java:158) 
... 74 more

Jul 13, 2018 03:12:57 PM (SRM/Startup/Container) (org.springframework.web.context.support.XmlWebApplicationContext) - (WARN) - Exception encountered during context initialization - cancelling refresh attempt 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'crystalReportingInitializer' defined in ServletContext resource [/WEB-INF/repmgr/config/container/reporting-beans.xml]: Cannot resolve reference to bean 'crystalUserManager' while setting bean property 'userManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'crystalUserManager' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'userSyncList' while setting bean property 'userSyncList'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userSyncList' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'boxiUserSyncDAO' while setting bean property 'boxiUserSyncDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'boxiUserSyncDAO' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'jdbcTemplate' while setting bean property 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportManagerFoundation': Invocation of init method failed; nested exception is com.aprisma.spectrum.app.repmgr.exceptions.SRMException: Error occurred while applying schema changes to reporting database

Environment

Versions: Any

Component: Spectrum Report Manager

Cause

Failure in the schema change.

Resolution

Follow the steps to fix the issue:

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

2. Shutdown the OneClick tomcat

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 -p<PASSWD> reporting

5. Enter the following command at the mysql prompt:

ALTER TABLE `devicemodule` CHANGE `module_index` `physical_index` int(10) DEFAULT NULL,CHANGE `module_name` `physical_modelname` varchar(255) DEFAULT NULL,ADD `physical_name` varchar(255) DEFAULT NULL AFTER `physical_modelname`,ADD `physical_class` int(10) DEFAULT NULL AFTER `physical_name`,ADD `physical_contained_in` int(10) DEFAULT NULL AFTER `physical_class`,DROP INDEX `key_idx`,ADD INDEX `key_idx`(`model_key`, `physical_index`);

6. If successful, start OneClick tomcat