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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

495 views 19 10
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