Dell Identity Manager repairing duplicate alternate keys using “vi_RepairDuplicateAlternateKey” for Active Directory

If you are working with Dell Identity Manager 6.x (current version is Dell Identity Manager 6.1.2) and configure your Active Directory, you can enable a synchronization process between AD & Dell Identity Manager.

Sometimes when you run a Synchronization process, you might run with an error that generates the AD Synch to fail.

Error:

“The synchronization was cancelled because of data inconsistency in the target system ADS. Run the SQL procedure “vi_RepairDuplicateAlternateKey” for data revision.”

Error on the Job Queue Web Brower.

Error in the JobQueueInfo tool

Dell Identity Manager provides the stored procedure “vi_RepairDuplicateAlternateKey” to find and delete duplicate entries. You can use the tool in the following way:

1. Open the Dell Identity Manager Object Browser ( ObjectBrowser )

2. Execute the following command:

Exec vi_RepairDuplicateAlternateKey ‘ADS’, ‘Log’

3. Analyze the data and review the duplicates

4. Run the following command to repair the data

Exec vi_RepairDuplicateAlternateKey ‘ADS’, ‘Repair’

This stored procedure can be used with other target system.The function Signature is :

vi_RepairDuplicateAlternateKey (@namespace NVARCHAR(64)=N’ALL’,@Mode NVARCHAR(16)=N’LOG’)

Where the allowed values for the parameters are:

@Namespace expects one of the following values:

– ADS
– Ex2010
– Ex2k
– LDAP
– Notes
– SharePoint

@Mode can be set to:

– LOG
– REPAIR