Universe connector import failing for duplicate users
Article ID: 131961
Updated On:
Products
CA Identity Manager
CA Identity Governance
CA Identity Portal
Issue/Introduction
When importing Active Directory Endpoints into CA Identiy Goernance via the CA Identity Manager Connector, the import fails with the error below:
Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (610, auser).; nested exception is java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'IX_Users'. Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (610, auser).
16:23:28,528 ERROR [stderr] (import-connector thread-9) at com.eurekify.command.AbstractCommand.execute(AbstractCommand.java:54)
Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (610, auser).; nested exception is java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'IX_Users'. Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (610, auser).
16:23:28,528 ERROR [stderr] (import-connector thread-9) at com.eurekify.command.AbstractCommand.execute(AbstractCommand.java:54)
Environment
CA Product = IDENTITY MGMT AND GOVRNCE
Product Release =14.4
Cause
This issue is caused by duplicate database entries.
Resolution
To address this issue, purge the Identity Governance Universe. Good management practice requires you to purge old, unneeded data files from the CA Identity Governance database server periodically, so this is not detrimental to the overall functionality.
Additional Information
Feedback
Yes
No
Powered by
