Universe connector import failing for duplicate users
book
Article ID: 131961
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA 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)
Environment
CA Product = IDENTITY MGMT AND GOVRNCE Product Release =14.1 CP3
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
Please refer to the CA Identity Management product documentation for further information on purging data.