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
- Releases
- Components
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)
- com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException:
- 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
- com.aprisma.util.mysql.SQLScriptRunner.doRunSQLScript(SQLScriptRunner.java:2
51)
at
- 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