Couldn't Capture Snapshot Data after PIM 12.6 upgrade to 12.8

Document ID : KB000004623
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After upgrading from 12.6 to 12.8, when executing "Capture Snapshot Data" (under Reports -> Tasks) it fails with:

Fatal: Failed to execute captureSnapshotEvent. ERROR MESSAGE: Exception: CaptureSnapshot event has failed:

 

The following messages are evident in server.log:

2016-11-16 11:37:25,097 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 207, SQLState: S0001

 

Immediately followed by one of the following:

2016-11-16 11:37:25,097 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'PPM_CHECKOUTONLYAUTOLOGIN'.

2016-11-16 11:37:25,097 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'ppm_gracedays'.

2016-11-16 11:37:25,097 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'CREATION_TIME'.

2016-11-16 11:37:25,097 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'role_id'.

2016-11-16 11:37:25,097 ERROR [org.hibernate.util.JDBCExceptionReporter] Invalid column name 'ADMIN_TASK'.

 

And the following where <column_name> is one of PPM_CHECKOUTONLYAUTOLOGIN, ppm_gracedays, CREATION_TIME, role_id, ADMIN_TASK.

2016-11-16 11:37:25,097 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.SQLGrammarException: could not insert: [com.ca.ppm.export.objects.PPMAccountUserAccessVO]

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

...

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name '<column_name>'.

Resolution:

This is fixed by applying RO70419 which can be downloaded from: 

https://support.ca.com/irj/portal/anonymous/SolutionCDNResults?aparNo=RO70419&actionID=4