Active Directory Error - Duplicate Key Violates Unique Constraint
I am attempting to connect Qlik Sense server to an Active Directory to load the users. I am getting an error in the logs referencing "synchronizing all users for 8106ccf0-9bbc-440a-bdc8-a0164f6b07c4 was not successful duplicate key value violates unique constraint "ix_usersuserid_userdirectory""
At first I thought it might be because I was getting warnings about AD Groups that generating WARNS of Recursive group hierarchy discovered, but I added an LDAP filter to get rid of those groups from the load and am still getting this message with zero users getting loaded.
Does anybody have an idea as to why this is happening and how to resolve?
I haven't seen things described exactly like this, but are there duplicate users in the QMC > Users section (aka users with the exact same User Directory and User ID values)? Filtering by the problematic ID (8106ccf0-9bbc-440a-bdc8-a0164f6b07c4) may lead you in the right direction.