Duplicate key in dbo.Request table
search cancel

Duplicate key in dbo.Request table

book

Article ID: 186366

calendar_today

Updated On:

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.