Universe connector import failing for duplicate users
Article ID: 131961
CA Identity ManagerCA Identity GovernanceCA Identity Portal
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.