Identity manager startup issues due to Snapshot database upgrade error
book
Article ID: 74793
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA 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.