Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AniketVasadkar
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
AniketVasadkar
Contributor III
Contributor III
Author

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.

View solution in original post

2 Replies
AniketVasadkar
Contributor III
Contributor III
Author

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.

Maria_Halley
Support
Support

@AniketVasadkar

 

Thank you for updating the post with the answer.