SRM schema exceptions after upgrading to 10.3.2

book

Article ID: 131026

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After upgrading to 10.3.2 , ERROR 1060 (42S21) at line 29 in file: 'C:\win32app\Spectrum\Install-Tools\rpmgr\sql\srm_schema_changes_for_doi.sql': Duplicate column name 'last_updated_time' error is seen in

tomcat logs : Exception : Apr 04, 2019 04:30:38 PM (SRM/Startup/Container)
(org.springframework.web.context.support.XmlWebApplicationContext) - (WARN) - Exception encountered during context initialization - cancelling refresh attempt org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'SRM/Quartz-TimerFactory' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'scheduledCrystalOnlyUserManager' while setting bean property 'triggers' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduledCrystalOnlyUserManager' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'crystalOnlyUserManagerJob' while setting bean property 'jobDetail'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'crystalOnlyUserManagerJob' defined in ServletContext resource [/WEB-INF/repmgr/config/container/scheduling.xml]: Cannot resolve reference to bean 'crystalOnlyUserManager' while setting bean property 'targetObject'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'crystalOnlyUserManager' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'crystalUserManager' while setting bean property 'crystalUserMgr'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'crystalUserManager' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'userSyncList' while setting bean property 'userSyncList'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userSyncList' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'boxiUserSyncDAO' while setting bean property 'boxiUserSyncDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'boxiUserSyncDAO' defined in ServletContext resource [/WEB-INF/repmgr/config/container/data-access-beans.xml]: Cannot resolve reference to bean 'jdbcTemplate' while setting bean property 'jdbcTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportManagerFoundation': Invocation of init method failed; nested exception is com.aprisma.spectrum.app.repmgr.exceptions.SRMException: Error occurred while applying schema changes to reporting database

Cause

There is no validation to check the column

Environment

Spectrum 10.3.2

Resolution

Spectrum_10.03.02.PTF_10.3.204 adds the validation which fix the issue.

Please reach out to support to get this patch.