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
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,578 views 4 13
Read article

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