SRM does not start after upgraded to 10.2.3

Document ID : KB000107542
Last Modified Date : 21/07/2018
Show Technical Document Details
Issue:
The SRM (Spectrum Report Manager) does not start after upgraded to 10.2.3.
The following error was found in the Tomcat log file:

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:
CA Spectrum 10.2.3
Cause:
Failure in the schema change.
Resolution:
Follow the steps to fix the issue:

1. Login to oneClick machine and redirect to $SPECROOT/mysql/bin in a bash shell
2. Then connect to mysql by ./mysql.exe -uroot -proot
3. execute the command "use reporting;"
4. Then again the execute the command "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`);"
5. Once it is done please restart the tomcat