Spectrum Report Manager (SRM) does not start after upgrade
book
Article ID: 107542
calendar_today
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
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: