DX NetOps

Spec KB: SRM has not finished starting after upgrade

  • 1.  Spec KB: SRM has not finished starting after upgrade

    Broadcom Employee
    Posted Mar 29, 2016 09:04 AM

    Spec KB: SRM has not finished starting after upgrade

    Document ID:  TEC1225336
    ShowHide Technical Document Details

    • Products
      • CA Spectrum
    • 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
      • REPORTING

    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

    1. 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