topic Re: User directory connectors throwing Unique Constraint violation exception while adding users to database in Management & Governance

User directory connectors throwing Unique Constraint violation exception while adding users to database

AniketVasadkar — Tue, 30 Nov 2021 14:38:59 GMT

Hi All,

We are connecting to more than one AD servers to get user and their group details.

For first 3 it worked well like EMEA, AMERICAS etc. but when we added 4th one it is complaining and giving database add operation failed with unique constraint violation.

Even debug logs doesn't show what is the duplicate entry so that we can apply filter while fetching data from AD.

Thanks

Aniket

Re: User directory connectors throwing Unique Constraint violation exception while adding users to database

AniketVasadkar — Mon, 06 Dec 2021 09:01:33 GMT

Hi All,

This issue is resolved & one has to use filter while fetching data. We started with applying filter on individual users based on sAmAccountName & then increased scope step by step and resolved the issue.

Re: User directory connectors throwing Unique Constraint violation exception while adding users t...

Maria_Halley — Mon, 06 Dec 2021 11:02:47 GMT

@AniketVasadkar

Thank you for updating the post with the answer.