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)
This issue is caused by duplicate database entries.
CA Product = IDENTITY MGMT AND GOVRNCE
Product Release =14.1 CP3
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.
Please refer to the CA Identity Management product documentation for further information on purging data.
Also see the related Knowledge Base articles.
How to identify duplicates encountered during an Identity Governance import?
How to allow IG Imports to continue with duplicates.