Details
-
Bug
-
Resolution: Cannot Reproduce
-
High
-
None
-
1
-
Severity 3 - Minor
-
0
-
Description
Issue Summary
In some cases, when migrating projects from Jira Server to Jira Cloud, you may notice a few issues missing comments, the project migration won't fail, however, you will be able to find an error in the cloud migration logs.
Steps to Reproduce
- Create an issue on the Jira server with few comments ending with blank spaces/lines
- Migrate projects from Jira Server to Cloud
- Validate the comments on the issues.
Expected Results
All the comments get migrated.
Actual Results
In some cases, we haven't been able to pinpoint exactly why this happens, you may notice a few missing comments on the issues.
The below exception is thrown in the cloud migration logs file:
2023-01-28 08:28:33.392894 ERROR ACM project-import We couldn't import Comment 346262 (on Issue aaa-1 by 'aaaa [X]' on 2020-07-07T23:44:59Z). Reason: QueryException: Caught BatchUpdateException for insert into "public"."jiraaction" ("issueid", "author", "actiontype", "actionlevel", "rolelevel", "actionbody", "created", "updateauthor", "updated", "event_time", "actionnum", "tokens", "actionbody_adf", "actionbody_adf_id", "actionbody_adf_version", "hidden", "tokens_with_positions")
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?).
2023-01-28 08:28:33.392933 ERROR ACM project-import We couldn't import Comment 346263 (on Issue aaa-2 by 'aaaaa [X]' on 2020-07-08T01:09:56Z). Reason: QueryException: Caught BatchUpdateException for insert into "public"."jiraaction" ("issueid", "author", "actiontype", "actionlevel", "rolelevel", "actionbody", "created", "updateauthor", "updated", "event_time", "actionnum", "tokens", "actionbody_adf", "actionbody_adf_id", "actionbody_adf_version", "hidden", "tokens_with_positions")
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?).
Workaround
Export the issues with the missing comments from your Jira Server, in the CSV format import back in the Cloud, you should only need the issue key, summary and the comments to update the missing comments on the Cloud.
Or
Update the comment in jiraaction table in the Jira server DB