ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

IM Unable to start after recent patching with Audit DB errors

book

Article ID: 240248

calendar_today

Updated On:

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.

Cause

Regression being investigated by Engineering.

Environment

Identity Manager 14.3

Identity Manager 14.4

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

Attachments