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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Users reported with duplicate email but only one exists

Tom Lister Community Leader Oct 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?


2 answers

1 vote

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.

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!  

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

Tom Lister Community Leader Oct 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.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events