SRM has not finished starting after upgrading to version 10.3.2

book

Article ID: 131805

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

I have upgraded to version 10.3.2 and report manager is not working. When I try the message of SRM has not finished starting appears.

Catalina.out shows the following errors:

2019-04-30 14:25:22,587 ERROR com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeUpdater - Error occurred while applying schema change
  Name: 2017 (Product version: 10.3.2) - SRM Schema changes for pumping data to DOI
com.aprisma.spectrum.app.web.db.schemachange.FatalSchemaChangeException: com.aprisma.spectrum.app.web.db.schemachange.SchemaChangeException: SPC-OCA-10067: Error occurred while running schema change script.Script: /spectrum/Install-Tools/rpmgr/sql/srm_schema_changes_for_doi.sql
 

Environment

CA Spectrum 10.3.2 with Spectrum Report Manager (SRM)

Resolution

10.03.02.PTF_10.3.204 resolves this problem.

REQUIREMENTS
SPECTRUM 10.03.00 and 10.03.02 are the prerequisites for installation of this patch.
This patch needs to be installed on just the OneClick SRM Server.

OVERVIEW 
This is a PTF patch for the following issue:

DE412925 Details:
Symptom : Getting error  Duplicate column name 'last_updated_time' in schema update after 10.3.2 upgrade and SRM not started. 
Resolution: Added checks at the time of last_update_time column creation in srm_schema_changes_for_doi.sql. 
(DE412925, 01339082)

BILL OF MATERIALS

ReleaseNote.PTF_10.3.204.txt 
runme (Linux/Solaris)
uninstall_PTF_10.3.204.pl (Linux/Solaris)
srm_schema_changes_for_doi.sql


runme.exe (Windows)
uninstall_PTF_10.3.204.exe (Windows)
srm_schema_changes_for_doi.sql (Windows)

Additional Information

Please contact support for a copy of this patch.

 

This 10.03.02.PTF_10.3.204 patch is NOT included in eutger the BMP (Bi-Monthly Patch) so if you install either of the bi monthly patches you will still need to install 10.03.02.PTF_10.3.204.

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3-2/release-information/bi-monthly-patches-bmps-on-10-3-2.html

ftp://ftp.ca.com/CAproducts/CA-SPECTRUM/Updates/GA/Spectrum_10.03.02.BMP_10.3.202/

ftp://ftp.ca.com/CAproducts/CA-SPECTRUM/Updates/GA/Spectrum_10.03.02.BMP_10.3.201/