CA IDM 12.6.2 restart fails with the following error
07:17:23,767 WARN [ims.tmt.CreateDatabaseSchema] ****** Upgrading Schema for: Report Snapshot to r12.6SP2
[3/16/18 7:17:23:771 EDT] 00000045 SystemOut O 07:17:23,771 INFO [ims.tmt.DBImportSchema] alter table imruser6 add (
[3/16/18 7:17:23:856 EDT] 00000045 SystemOut O 07:17:23,852 ERROR [ims.tmt.CreateDatabaseSchema] Error in creating Report Snapshot database schema.
java.sql.SQLException: ORA-01430: column being added already exists in table
We have not seen this error earlier and it is trying to upgrade Auditing database by creating/replacing FUNCTION IM_Audit_Start_Date and FUNCTION IM_Audit_End_Date. We have not upgraded to other version.
Any idea how can we identify which is triggering the upgrade fo database?