subject_user column already exists in the table imaudit.imsAuditEvent12

Products

• CA Identity Suite

Issue/Introduction

Error after during upgrade from 14.2 CP2 to 14.4.1.

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

Also see https://knowledge.broadcom.com/external/article/131017/error-message-when-start-identity-manage.html 

Due to audit requirements, unable to export and drop audit tables or manually delete subject_user column.

 

Environment

Release : 14.4

Resolution

Database edit:

imsaudit_version table to 14.2.0.0.0 from 12.6.2 and restarted application server.