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(SessionFactoryUtils.java:590) 

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 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

Thank you.

Regards,
LM 

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

380 views 21 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