Spec KB: SRM has not finished starting after upgrade
Document ID: TEC1225336
ShowHide Technical Document Details
- Products
- Releases
- CA Spectrum:Release:9.4
- CA Spectrum:Release:9.3
- CA Spectrum:Release:9.4.1
- CA Spectrum:Release:9.4.2
- CA Spectrum:Release:9.4.2.1
- CA Spectrum:Release:9.4.3
- Components
Symptom:
After upgrading to CA Spectrum 9.4.x, fails to launch the InfoView, the following message error is displayed:
SRM has not finished starting
Environment:
CA Spectrum 9.3.x/9.4.x
CABI 3.3 SP1
Cause:
The SRM is failing to apply schema change to add the isClusterEntity column to the model table for cluster information.
The following error is found in the $SPECROOT/tomcat/logs/stdout.log (or catalina.out) file:
jan 26, 2016 08:21:05 AM (SRM/Startup/Container) (com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater) - (ERROR) - Error occurred while applying schema change
Name: 1068 (Product version: 9.3.2) - Adding isClusterEntity column to model table for cluster information
- com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: SQLException while running RuntimeSchemaChange1068 Schema Change Errorcode: 1060
Caused by: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: SQLException while running RuntimeSchemaChange1068 Schema Change Errorcode: 1060
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'isClusterEntity'
Please select the following link for more information on this subject:
Knowledge Document Link:
http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1225336.aspx