DX NetOps

Spec KB: CA Spectrum Report Manager tomcat log file shows an error in regards to a Duplicate Column Name for AddArchivalEnabled

  • 1.  Spec KB: CA Spectrum Report Manager tomcat log file shows an error in regards to a Duplicate Column Name for AddArchivalEnabled

    Broadcom Employee
    Posted Oct 19, 2015 09:32 AM

    Spec KB: CA Spectrum Report Manager tomcat log file shows an error in regards to a Duplicate Column Name for AddArchivalEnabled

    Document ID:  TEC1576794

    ShowHide Technical Document Details

    • Products
      • CA Spectrum
    • Releases
      • CA Spectrum:Release:10.0
    • Components
      • APPLICATIONS
      • REPORTING


    Issue:  After installing CA Spectrum 10.0 with OneClick and Spectrum Report Manager (SRM), the tomcat log shows a Report Manager exception:

     

    Mar 10, 2015 08:16:09 AM (SRM/Startup/Container)

    (com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater) -

    (ERROR) - Error occurred while applying schema change

      Name: AddArchivalEnabled (Product version: 8.1.0) - Adds archival on and

    off toggle (from SC823 - v.8.1.0)

    1. com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException:
    2. com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: Error

    occurred while running schema change script.

     

    Stdout:

     

      Stderr:

    ERROR 1060 (42S21) at line 27 in file:

    'C:\win32app\Spectrum\Install-Tools\rpmgr\sql\add_archival_on_off_field_823.

    sql':

    Duplicate column name 'ArchivalEnabled'

    at

    1. com.aprisma.util.mysql.SQLScriptRunner.doRunSQLScript(SQLScriptRunner.java:2

    51)

    at

    1. com.aprisma.util.mysql.SQLScriptRunner.runScript(SQLScriptRunner.java:158)

    ... 51 more

     

    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/tec1576794.aspx