AnsweredAssumed Answered

CA IDM 12.6.2 restart fails

Question asked by RajeshMadalakrishnamoorthy1256 on Mar 16, 2018
Latest reply on Mar 22, 2018 by jaipr03



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 (
imr_usertype varchar2(255)
[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?