Spectrum Report Manager (SRM) does not start after upgrade
Article ID: 107542
Updated On:
Products
CA Spectrum
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
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
Cause
Failure in the schema change.
Environment
Any
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 -proot 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
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 -proot 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
Feedback
Yes
No
Powered by
