Error in creating Auditing database schema: ORA-01430: column being added already exists

Products

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

Issue/Introduction

 

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

Resolution

Manually delete the subject_user column or drop the table and allow IDM to create a fresh one during restart.