Resolve missing email addresses when migrating to the Cloud

[Francesco Coppola]

Hi,

we need to migrate to Jira Server Environment to Jira cloud. We cannot edit user in Jira because the source is the Active Directory. Besides we cannot  fix the data in active directory.

So Following what is suggested here "Resolve missing email addresses when migrating to the Cloud " we tried to fix the data  with a Database update executing the following SQL query 

UPDATE cwd_user
SET email_address = CONCAT('user-',id,'@domain.com'),
    lower_email_address = CONCAT('user-',id,'@domain.com')
WHERE (email_address is NULL or email_address = '') or (lower_email_address is NULL or lower_email_address = '');

Now the new email has been in the database but the change is not visible/present in Jira and we can't proceed with migration

Anyone has the same issue? or can advice how to solve?

Thanks 

[Chris Schneider]

Hi, I just did the same thing last week. In the manual, there is somewhere a note that you need to reboot your server, so that cache is cleared and the newly added emailadresses will be visible in your GUI.

I just cannot find that comment anymore.

Chris

[Chris Schneider]

Here you go: Resolve invalid email addresses when migrating to the Cloud | Atlassian Cloud | Atlassian Documentation