Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-479

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

XMLWordPrintable

    • 59
    • Severity 2 - Major

      Issue Summary

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

      Steps to Reproduce

      1. 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
      2. Create a new sample project
        • Projects > Create project > Create Sample Data > Scrum software development
      3. Create Epic
        • Epic Name: Sample Epic 1
        • Summary: Sample Epic 1 Summary
      4. Link some issues to the Epic
      5. 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

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

      Update Epic custom fields

      1. Unlock a locked Jira Software custom field
      2. Move to Jira admin > Issues > Custom fields
      3. 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;

        1. Screen Shot 2021-01-26 at 16.05.14.png
          Screen Shot 2021-01-26 at 16.05.14.png
          308 kB
        2. Screen Shot 2021-01-27 at 10.59.52.png
          Screen Shot 2021-01-27 at 10.59.52.png
          686 kB
        3. Screen Shot 2021-01-27 at 11.00.03.png
          Screen Shot 2021-01-27 at 11.00.03.png
          697 kB
        4. Screenshot 2022-05-17 at 11.42.33 AM.png
          Screenshot 2022-05-17 at 11.42.33 AM.png
          62 kB

            103579c89d5e Shraddha Garg
            tsuzuki@atlassian.com Tomoko Suzuki
            Votes:
            11 Vote for this issue
            Watchers:
            24 Start watching this issue

              Created:
              Updated:
              Resolved: