u

[Francois BIGOT]

Hi,
I got an error when I try to synchronize external LDAP using Atlassian Crowd (cf. stack trace at the end of my message) from confluence administration webpage.
To diagnose the problem I check logs and also Jira and Confluence databases.

Jira database
The record lower_user@mail.com in cwd_user and app_user table in lower_user_name column so it seems to be ok.
In the user_key column of app_user table I got user@mail.com

Confluence database
I search in cwd_user table and user_mapping if lower_user_name for the first and  lower_username for the second, if it got a user with lower_user@mail.com, got no results.
So I try using the value in user_key column from app_user table from jira that is user@mail.com and I got the following result 

cwd_user table:

username                  |   lower_username
user@mail.com         | user@mail.com
user@mail.com #2    | user@mail.com #2

user_mapping table:
| username                     | lower_username |
| User@mail.com           |  user@mail.com#1
| user@mail.com #2       | user@mail.com#2
 
Would you mind told me what happened ?
Above all how can I fix the problem ?

What I consider to do to resolve the issue:
I consider to remove the two records user@mail.com #2 from cwd_user and user_mapping from confluence database and just rename the record  from user@mail.com to lower_user@mail.com to correspond with the record in jira database.

Thank you for your help.

Stack trace:

****-**-** **:**:**,*** ERROR [Caesium-1-3] [atlassian.confluence.event.ConfluenceEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.crowd.event.user.UserEditedEvent@19c431a0] from the invoker [com.atlassian.event.internal.ComparableListenerInvoker@45fcafec] java.lang.RuntimeException: Unable to find user mapping for user@mail.com. Listener: com.atlassian.confluence.user.crowd.UserIndexingListener event: com.atlassian.crowd.event.user.UserEditedEvent at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:53) .....