User failed to login after changing username in AD

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
    at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException( 

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.

1 answer

Hello there,

This is a known bug that has been impacting Confluence and have already been reported to our development team. Please see and

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:

Thank you.


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,565 views 26 14
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you