Symantec IGA

Hi,

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?

IDM 12.6.2 has been EOS since Dec 2017.

CA Identity Suite 12.6.x End Of Service Announcement 

A few things I might try in this situation:

- Remove the reporting snapshot DB tables completely

- Edit the log4j* properties file to DEBUG for all categories

- And then restart

Of course the common suggestions of backing up existing data/db are not to be forgotten before you attempt these.

It looks like it is trying to update database schema which is already updated. Identity Manager startup sequence is designed such a way that it checks if all the database schemas are up to date as per the version installed and create/update schema if it is not fully upto date. You should let IM try to recreate the report snapshot database schema.

Follow these steps:

1. Take backup of existing report snapshot database

2. Drop report snapshot database (data and schema)

3. Restart Identity Manager

Thanks,

Praveen