Resolve missing email addresses when migrating to the Cloud

[Francesco Coppola]

hi,

we need to migrate from Jira Server Environment to Jira cloud and some users without email are blocking us.  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 

[Brant Schroeder · Accepted solution]

@Francesco Coppola Have you restarted your instance and ran a reindex?  I would suggest doing this to see if it fixes the issue.

[Francesco Coppola]

 thanks @Brant Schroeder  fixed the issue