ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Report Manager fails on schema 2017

book

Article ID: 132857

calendar_today

Updated On:

Products

CA eHealth CA Spectrum

Issue/Introduction

Report Manager is not available with message "SRM has not finished starting" message.

Reviewing further in the tomcat log is revealed an error regarding "duplicate column" for "last_updated_time" for schema change 2017.


Caused by: com.aprisma.util.mysql.ScriptRunnerException: Error occurred with SQL Script

  Script: D:/Spectrum/Install-Tools/rpmgr/sql/srm_schema_changes_for_doi.sql

  Stdout:

  Stderr:

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1060 (42S21) at line 29 in file: 'D:\Spectrum\Install-Tools\rpmgr\sql\srm_schema_changes_for_doi.sql': Duplicate column name 'last_updated_time'


Environment

Release :

Component : Spectrum Core / SpectroSERVER

Resolution

Engineering has released a patch for this issue.  PTF_10.3.204 for 10.3.2.

The patches are attached to this KB.


Attachments

1559844694246__Spectrum_10.03.02.PTF_10.3.204.Linux.txe get_app
1559844666653__ReleaseNote.PTF_10.3.204.txt get_app
1559844650027__Spectrum_10.03.02.PTF_10.3.204.Windows.exe get_app