Duplicate key in dbo.Request table

Products

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

Issue/Introduction

While upgrading CA Identity Manager (IM) and Identity Portal (IM) the portal stops submitting new requests and returns an error message

duplicate key in dbo.Request table.

 

Environment

Release : 14.x

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Resolution

The upgrade resets the id field in Request table to 1. 

Update in database value in dbo.SIGMA_REQUEST_MAIN_SEQ sequence and new requests will be accepted.