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.
Duplicate key in dbo.Request table
book
Article ID: 186366
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity PortalCA 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.3
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.