Confluence syncing ldap directory

Our ldap server is unable to sync successfully until recently.

We get the following error:


2017-04-04 09:47:01,376 ERROR [Caesium-1-3] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 10944516 ].
org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2

 

How do we determine which is the duplicate ? Most of the dianostic queries we run returns no results :

https://confluence.atlassian.com/confkb/synchronization-with-external-directory-fails-with-error-query-did-not-return-unique-result-757727378.html

 

SELECT lower_username FROM user_mapping GROUP BY lower_username HAVING (COUNT(lower_username) > 1)

 

https://confluence.atlassian.com/confkb/user-login-renders-query-did-not-return-a-unique-result-error-596181603.html

 

SELECT external_id, lower_user_name
FROM cwd_user
GROUP BY external_id, lower_user_name
HAVING ( COUNT(external_id) > 1)

 

 

 

1 answer

I have resolved this. There was a duplicate user in the cwd_user table, which needed to be deleted. We also had to removed user from the cwd_mapping table.

You mean that there is a internal user in jira, and duplicated with the ldap sync, so you delete the internal user in jira, and everything become ok ?

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
Published Thursday in Confluence

Color tables for a shiny Confluence page

...; ## Developed by: Alana Fernando ## Shared with love ## @param style:title=style type|type=enum|required=true|desc=Choose a style.|enumValues=Style1,Style2,Style3,Style4,Style5 ## @param alignment:title...

143 views 8 11
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