Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: Highest
Fix Version/s: None
Affects Version/s: None
Component/s: Jira - Migration Assistant - JMT Core
Labels:
- i18n

Support reference count:
59
Symptom Severity:
Severity 2 - Major

Description

Issue Summary

Jira Cloud Migration Assistant failed to map Issue types when installing Jira Server with non-English language

Steps to Reproduce

Install Jira with the Japanese language
- Make sure default issue types are generated in Japanese
  - バグ: Bug
  - エピック: Epic
  - ストーリー: Story
  - タスク: Task
  - サブタスク: Sub-task
- Make sure the default language is Japanese: ~~JRASERVER-43539~~
- User profile language is not related
Create a new sample project
- Projects > Create project > Create Sample Data > Scrum software development
Create Epic
- Epic Name: Sample Epic 1
- Summary: Sample Epic 1 Summary
Link some issues to the Epic
Execute Migration using Jira Cloud Migration Assistant

Expected Results

Epic is migrated properly
Default issue types are mapped with cloud default issue types

Actual Results

Epic is empty
"Sample Epic 1" is migrated as a new custom issue type "エピック"
Sub-task is migrated as a new custom issue type "サブタスク"

All other default issue types are migrated as a new custom issue type in cloud.

Jira Server

Jira Cloud

Workaround

Before executing the migration, change Issue types and fields name on the server.

Update Issue Types

Move to Jira admin > Issues > Issue types
Click Edit and update Issue type Name to English
- バグ -> Bug
- エピック -> Epic
- ストーリー -> Story
- タスク -> Task
- サブタスク -> Sub-task

Update Epic custom fields

Unlock a locked Jira Software custom field
Move to Jira admin > Issues > Custom fields
Click Edit and update Epic related field name to English
- エピックカラー -> Epic Colour
- エピックステータス -> Epic Status
- エピックリンク -> Epic Link
- エピック名 -> Epic Name
- ランク -> Rank

Update filters

You need to update filters when renaming custom fields or issue types:

JRASERVER-61048: As a Jira admin asked to rename a custom field, I want to know which filters contain the custom field, so I know which ones to update
JRASERVER-30467: Renaming a project or issue type breaks filters saved with the old project or issue type name

Find filter using non-English custom fields/issue types and update JQL.

Jira Core

Saved Filters

select * from searchrequest where reqcontent like '%エピック カラー%';
select * from searchrequest where reqcontent like '%エピックス テータス%';
select * from searchrequest where reqcontent like '%エピック名%';
select * from searchrequest where reqcontent like '%エピック リンク%';
select * from searchrequest where reqcontent like '%ランク%';

select * from searchrequest where reqcontent ~* 'issuetype.+バグ';
select * from searchrequest where reqcontent ~* 'issuetype.+エピック';
select * from searchrequest where reqcontent ~* 'issuetype.+ストーリー';
select * from searchrequest where reqcontent ~* 'issuetype.+タスク';
select * from searchrequest where reqcontent ~* 'issuetype.+サブタスク';

Jira Service Desk

Service Desk Queues

select * from "AO_54307E_QUEUE" where 'JQL' ~* 'issuetype.+バグ';
select * from "AO_54307E_QUEUE" where 'JQL' ~* 'issuetype.+ストーリー';
select * from "AO_54307E_QUEUE" where 'JQL' ~* 'issuetype.+タスク';
select * from "AO_54307E_QUEUE" where 'JQL' ~* 'issuetype.+サブタスク';

Jira Software

Agile Board Swimlanes

select * from "AO_60DB71_SWIMLANE" where 'QUERY' like '%エピック カラー%' or 'LONG_QUERY' like '%エピック カラー%';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' like '%エピックス テータス%' or 'LONG_QUERY' like '%エピックス テータス%';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' like '%エピック名%' or 'LONG_QUERY' like '%エピック名%';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' like '%エピック リンク%' or 'LONG_QUERY' like '%エピック リンク%';

select * from "AO_60DB71_SWIMLANE" where 'QUERY' ~* 'issuetype.+バグ' or 'LONG_QUERY' ~* 'issuetype.+バグ';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' ~* 'issuetype.+エピック' or 'LONG_QUERY' ~* 'issuetype.+エピック';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' ~* 'issuetype.+ストーリー' or 'LONG_QUERY'  ~* 'issuetype.+ストーリー';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' ~* 'issuetype.+タスク' or 'LONG_QUERY' ~* 'issuetype.+タスク';
select * from "AO_60DB71_SWIMLANE" where 'QUERY' ~* 'issuetype.+サブタスク' or 'LONG_QUERY' ~* 'issuetype.+サブタスク';

Agile Board Quick Filters

select * from "AO_60DB71_QUICKFILTER" where 'QUERY' like '%エピック カラー%' or 'LONG_QUERY' like '%エピック カラー%';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' like '%エピックス テータス%' or 'LONG_QUERY' like '%エピックス テータス%';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' like '%エピック名%' or 'LONG_QUERY' like '%エピック名%';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' like '%エピック リンク%' or 'LONG_QUERY' like '%エピック リンク%';

select * from "AO_60DB71_QUICKFILTER" where 'QUERY' ~* 'issuetype.+バグ' or 'LONG_QUERY' ~* 'issuetype.+バグ';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' ~* 'issuetype.+エピック' or 'LONG_QUERY' ~* 'issuetype.+エピック';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' ~* 'issuetype.+ストーリー' or 'LONG_QUERY'  ~* 'issuetype.+ストーリー';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' ~* 'issuetype.+タスク' or 'LONG_QUERY' ~* 'issuetype.+タスク';
select * from "AO_60DB71_QUICKFILTER" where 'QUERY' ~* 'issuetype.+サブタスク' or 'LONG_QUERY' ~* 'issuetype.+サブタスク';

Agile Board Card Colors

select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' like '%エピック カラー%';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' like '%エピックス テータス%';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' like '%エピック名%';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' like '%エピック リンク%';

select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' ~* 'issuetype.+バグ';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' ~* 'issuetype.+エピック';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' ~* 'issuetype.+ストーリー';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' ~* 'issuetype.+タスク';
select * from "AO_60DB71_CARDCOLOR" where 'STRATEGY' = 'custom' and 'VAL' ~* 'issuetype.+サブタスク';

After updating all JQLs, please check with the below SQL:

select * from ISSUETYPE;
select * from CUSTOMFIELDOPTION;
select * from "AO_60DB71_SWIMLANE";
select * from "AO_60DB71_QUICKFILTER";
select * from SEARCHREQUEST;

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List

Screen Shot 2021-01-26 at 16.05.14.png
308 kB
27/Jan/2021 1:53 AM
Screen Shot 2021-01-27 at 10.59.52.png
686 kB
27/Jan/2021 2:01 AM
Screen Shot 2021-01-27 at 11.00.03.png
697 kB
27/Jan/2021 2:01 AM
Screenshot 2022-05-17 at 11.42.33 AM.png
62 kB
17/May/2022 6:12 AM

Issue Links

is mentioned by: JPNS-51228 Loading...; MOVE-40478 Loading...; MOVE-49748 Loading...; MOVE-64706 Loading...; MOVE-70332 Loading...; MOVE-71863 Loading...; MOVE-72919 Loading...

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(2 is mentioned by, 20 mentioned in)

Activity

People

Assignee:: Shraddha Garg

Reporter:: Tomoko Suzuki

Votes:: 11 Vote for this issue

Watchers:: 24 Start watching this issue

Dates

Created:: 27/Jan/2021 1:52 AM

Updated:: 13/Jul/2023 6:34 PM

Resolved:: 29/Sep/2022 9:33 AM