Identity manager startup issues due to Snapshot database upgrade error

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Identity manager Application is not starting up and showing Snapshot database upgrade error

[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

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

Environment

Release:
Component: IDMGR

Resolution

Run manually the /opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/imrexport/db/Oracle/ims_oracle_report_delete.sql followed by the ims_oracle_report.sql script.