Users reported with duplicate email but only one exists

[Tom Lister]

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

[Tom Lister]

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]

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!  

[Sean]

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

[Tom Lister]

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.