Resolving ORA-01430 Error During Auditing Database Schema Creation - Identity Suite

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

The iam_im.ear file may fail to deploy after modifying the database connection to an external Oracle database. When this occurs, the Identity Manager (IM) service fails to start, and server logs report an ORA-01430 error related to the imsAuditEvent12 table.

Environment

Identity Manager 14.5

Cause

When IM is creating the Auditing database schema, a new column "subject_user" will be added in imsAuditEvent12 table.

Resolution

Warning: Before proceeding, ensure you have a full backup of the auditing database. Dropping schema columns can cause data loss if not managed correctly.

1. Stop the Identity Manager service.
2. Connect to the Oracle database using a database management tool.
3. Drop the existing subject_user column from the imsAuditEvent12 table using the following SQL command: ALTER TABLE imsAuditEvent12 DROP COLUMN subject_user;
4. Verify the column has been successfully removed.
5. Restart the Identity Manager service.
6. Observe the logs to confirm that iam_im.ear deploys successfully and the auditing schema is recreated correctly.

Additional Information

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.