Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Users reported with duplicate email but only one exists

Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 26, 2021

We are getting a list of duplicate email users reported when migrating our user population to Cloud using ACMA.

Some are correct but there are examples where we can only find one user with the email address.
We have checked the cwd_user table and only one exists. In some cases the user does have a second entry but the email I different.
we can't find references in comments or associations.

Does anyone know the logic ACMA is using? And is there a way to fix the data?

Tom

2 answers

Suggest an answer

Log in or Sign up to answer
1 vote
Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 29, 2021

We found a number of causes for this.

The most common was that the users did exist were duplicates but the character case was different e.g. uppercase first letter. To locate users we had to search the CWD_USER table for matches. It was only when we started using partial matches on names e.g. like '%smit%' that we began to see the other variations on the names.

One case was the same user and email occurred into separate LDAP setups. Fix was to remove one we knew to be unused.

Several internal utility users had been given the same default email address. We amend the email entries.

reuben.hollifield June 14, 2022

We are running into this issue as well with one user that appears on the JCMA to have duplicates, but in our User Administration section there is only one user with the referenced email address. 

We have attempted to run several queries against our database to find duplicate emails but with not luck....hoping to find where this duplicate is in the database and delete it so we can successfully migrate our data to Cloud!  

0 votes
Sean October 26, 2021

Describe your setup please, how does Jira get users currently? ( Crowd, AD)

Tom Lister
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 26, 2021

We currently use Crowd for user maintenance. This is a recent change (this year). Previously we had LDAP configurations in Jira and Confluence. They have been removed after the move to Crowd.

I do suspect this has messed with our user database. Although looking through the tables I can't find the duplicates.

TAGS
AUG Leaders

Atlassian Community Events