IM Unable to start after recent patching with Audit DB errors

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Recent patches downloaded from the portal and applied on the server cause the startup to fail.

We are seeing errors related to IM_Audit_Start_Date and IM_Audit_End_Date objects

ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 121) Error in creating Auditing database schema. com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'IM_Audit_Start_Date' in the database.

ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 121) Error in creating Auditing database schema. com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'IM_Audit_End_Date' in the database.

Environment

Identity Manager 14.3

Identity Manager 14.4

Cause

Regression being investigated by Engineering.

Resolution

The following is a workaround to stop the (redundant) DB update attempt

1. Stop Identity Manager

2. Using DB tools, connect to the Audit DB.

3. Run the following query
SELECT * from imsAudit_version

If it shows version as 13.0.0.0.0 update it to 14.2.0.0.0

3. Start Identity Manager