Issue with some custodian entries in Discovery Accelerator
Everytime the Custodian Manager synchronizes the AD account and group information it generates some Errors (Event ID's 26 & 35).
Event Type: Error
Event Source: Accelerator AD Synchronizer
Event Category: None
Event ID: 26
Date: 7/20/2012
Time: 6:19:31 AM
User: N/A
Computer: SRP01884WN
Description:
APP AT - Customer ID: 4 - an error occured when updating the Profiles. System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.tblAddressUser' with unique index 'IX_tblAddressUser_EmployeeID'. The duplicate key value is (<account>).
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at KVS.Accelerator.ActiveDirectory.Profile.UpdateDS(SyncProfileDS ds)
Event Type: Error
Event Source: Accelerator AD Synchronizer
Event Category: None
Event ID: 35
Date: 7/20/2012
Time: 6:19:31 AM
User: N/A
Computer: SRP01884WN
Description:
APP AT - Customer ID: 4 - An error occured while synchronising employee details for '<account>'. System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.tblAddressUser' with unique index 'IX_tblAddressUser_EmployeeID'. The duplicate key value is (<account>).
at KVS.Accelerator.ActiveDirectory.Profile.UpdateDS(SyncProfileDS ds)
at KVS.Accelerator.Server.CentralProfileSynchroniser.SynchroniseEmployeeProfile(SyncProfileDS profileDS)
These accounts have been disabled once and were moved into a different OU as a disabled account. In the meantime the same user is back and got the same account. I don't know yet if the account got recreated or not.
In the Custodian Manager website the old account is still visible but has no check marks under the columns Synchronize and Active anymore. Usually if this happens in the organization I get an exclamation mark in the column Synchronize and the new account is visible as well.
If I open the old custodian entry all information is grey and cannot be changed. But I see a button at the bottom of the page called Reactivate. So I'm interested if this button will help me. But I couldn't find any information in all kind of manuals as well as in the knowledgebase. Any diea if this will help to solve the issue? What will happen if I press the "Reactivate" button? Or does somebody know how I can import the information from the new AD account that didn't get imported?
This issue is only in the PROD environment. We also have a test environment where we do not have such issues.
Hey Dani,
What version of DA? There was an issue in an older version where if the EmployeeID was blank it would cause the issue you are seeing. I wander if the EmployeeID of the old account and new account are the same, therefore you get the error??