Identity Manager Startup Failure due to ORA-01430 Snapshot Database Error

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

During startup, the Identity Manager application may fail to initialize, preventing the service from booting. This startup failure is identified by a java.sql.SQLException: ORA-01430 error in the logs, which occurs when the application attempts to upgrade the Report Snapshot database schema.

Environment

Identity Manager 14.x

Cause

The ORA-01430: column being added already exists in table error indicates that the database upgrade script is attempting to add a column (imr_usertype) to the imruser6 table that is already present in the schema. This issue generally results from a partially completed or interrupted schema upgrade process.

Resolution

1. Navigate to the following directory on the server: /opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/imrexport/db/Oracle/
2. Execute the deletion script to clear the existing report schema: ims_oracle_report_delete.sql
3. Execute the report schema creation script to re-initialize the schema correctly: ims_oracle_report.sql
4. Restart the Identity Manager application server.

Additional Information

Warning: Before proceeding, ensure you have a complete, verified backup of your Identity Manager databases. Running the deletion script below will remove existing report schema data.

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.