Still getting accountIDs in place of usernames after import from cloud jira to server

Question

Hi Team,

Here are the steps that i followed for migration from cloud JIRA to Server:

1. Generated the backup from cloud JIRA

2. Installed a jira server on local system (with MYSQL as database)

3. imported the backup data into this new server created in step 2

4. Tried to run the dbms query on the database to resolve the accountid issue

5. Tried to install the Cloud Compatibility for jira add-on

Even after steps 4 & 5, I am still getting accountIDs in place of usernames in comments

(Note: I followed this article for migration: https://confluence.atlassian.com/adminjiraserver/migrating-from-jira-cloud-to-server-applications-938846963.html )

Pls guide me how to tackle this issue.

Thanks in advance!

Vishwas · Answer

Hi

@Shreesh Narayan Singh  looks like it has updated few of the usernames I guess and some of the usernames are not updated.

Can you just check that by taking one AccountId and see does that account name is part of user in the directory ? Like correlation type. After try running SQL query once again.

If it doesn't work,

I would recommend to check with Atlassian support on this here https://support.atlassian.com/contact/#/

Regards,

Vishwas

Shreesh Narayan Singh_rlpz0z · Answer

Hi @Vishwas ,

After running the query in the DB, it has changed some of the accountIDs to the username in comments but not all of them (Attaching the screenshots , so you can see it).

Not sure, why it didn't work for all of the accountIDs.

Pls let me know what i am missing here.

Thanks for all your help!

Vishwas · Answer

Hey @Shreesh Narayan Singh

Can you check in issue table in case the comments have updated usernames ?

You can use this query:

SELECT P.pkey||'-'||JI.issuenum as issuekey, JA.actionbody
FROM jiraaction JA
JOIN jiraissue JI ON JA.issueid = JI.id
JOIN project P ON JI.project = P.id
JOIN app_user U ON U.user_key = JA.author
WHERE JA.actiontype = 'comment'
AND U.lower_user_name = 'xxx';

Please remember to change the value of the U.lower_user_name variable from 'xxx' to the actual 'username' from the user all in lower case.

This is to make sure to check if the values are updated in DB.

After this can you try restarting & re-indexing the application ? . This was not required but to make sure that if this works ...

Regards,

Vishwas