We have Confluence connected to Crowd directory for authentication. Crowd in turn pulls users from Microsoft AD. Every time existing user name is changed in AD for some reason the user fails to login with the following error:
org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
And indeed Confluence has 2 user names for the same user although when I check on Crowd it has only 1 (new one). Even running full synchronization of Crowd directory on Confluence does not help. The only work around that helped is creating a new Crowd directory and replacing old one with the new one.
Is there an easier (better) way to work around this issue ? Looks like this issue persists for a while and I'm not sure if Atlassian is going to fix it. It becomes really annoying as it happens quite often when user was created in AD with one name but then had to be renamed.
This is a known bug that has been impacting Confluence and have already been reported to our development team. Please see https://jira.atlassian.com/browse/CONF-30050 and https://jira.atlassian.com/browse/CONF-36018.
While this is not fixed, the workaround of re-adding the user directory is the best approach, but you can also manually delete the duplicated users through the database following the instructions from this guide: https://confluence.atlassian.com/pages/viewpage.action?pageId=596181603
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG