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

[Shreesh Narayan Singh]

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]

Hey @Shreesh Narayan Singh 

Welcome to Atlassian Community !!

From your description I hope you are referring to the workaround that is mentioned here in this bug https://jira.atlassian.com/browse/JRASERVER-70190 ? Did you run those sql queries in DB ? Which DB is being used ?

After installing the app what steps did you perform to fix the issue ?

Regards,

Vishwas 

[Shreesh Narayan Singh]

Hi @Vishwas ,

Thanks for the quick response!

Yes, you are correct! I am referring the workaround mentioned in the 70190 ticket.

I did run that sql query in MYSQL database(see attachment).

Also, after installing the app, there is no need to perform any step to fix the issue as mentioned in the description of the app (Check this link: https://marketplace.atlassian.com/apps/1221117/cloud-compatibility-for-jira?hosting=server&tab=overview )

Pls let me know if I am missing anything.

Thanks again!!

[Vishwas]

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

[Shreesh Narayan Singh]

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]

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