Question

Directory server synchronization is failing -Violation of UNIQUE KEY constraint

Directory Server Version 10

Updated March 16, 2020

asked on March 13, 2020

Hello,

Customer of ours sent us an email stating:

Directory server synchronization is failing repeatedly with this error in the event log:

Violation of UNIQUE KEY constraint 'directory_objects_name_container_(customer name)'. Cannot insert duplicate key in object 'dbo.directory_objects'. The duplicate key value is (AD\The Unique User Identity)

They removed the user from the AD Group and re-synced and it went through.

They have about 50 other members in this AD Group that sync to LF without issue.

Any Ideas?

Appreciate the feedback,

Jeff Curtis

3 0

Answer

SELECTED ANSWER

replied on March 16, 2020

Hi Jeff,

The first thing that comes to mind is that maybe these users were deleted/re-created in AD but were left untouched in LFDS. This will cause a SID mismatch between the users in LFDS and the users in AD. I recommend deleting all the problematic users from LFDS and allowing AD group sync to sync them back in.

6 0

Replies

replied on March 16, 2020

Chase and Jeff,

Deleting the broken user and allowing a re-synchronization worked. The user is now properly licensed and there were no errors in the log. Thank you.

2 0

replied on March 16, 2020

Thanks for the Post Chase and thanks Erik for your updated post.

Jeff Curtis

1 0

You are not allowed to follow up in this post.

Question

Question

Directory server synchronization is failing -Violation of UNIQUE KEY constraint

Answer

Replies

Sign in to reply to this post.