imsAuditEvent12 add(subject_user varchar2(100)), Error Msg = ORA-01430: column being added already exists in table causing iam_im.ear to not deploy preventing IM from starting

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

A customer changed the database connection to external Oracle DB in IM and facing issues with iam_im.ear not deploying and IM service is not starting.

 

Error from the server logs:

2023-07-18 10:07:02,392 ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 101) Error in creating Auditing database schema. java.sql.SQLException: ORA-01430: column being added already exists in table

 

Caused by: Error : 1430, Position : 32, Sql = alter table imsAuditEvent12 add(subject_user varchar2(100)), OriginalSql = alter table imsAuditEvent12 add(subject_user varchar2(100)), Error Msg = ORA-01430: column being added already exists in table

Environment

Release : 14.4

Product : CA IDENTITY SUITE (Virtual Appliance)

Cause

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

Resolution

Remove the existing "subject_user" column in imsAuditEvent12 table, restart IM, then iam_im.ear should be deployed and IM service starts without any issues.