JCMA migration error: "CROSS-PROJECT-DATA project-import We couldn't import Issue Source <issue-source-id>. Reason: Issue source of type Board, with value [<board-id>] could not be found."

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。

要約

As of version 1.6.6, the Jira Cloud Migration Assistant app supports the migration of Advanced Roadmaps (AR) Plans. AR Plans related errors might surface during a JCMA plan execution.

This error is one of the potential ones an admin may face while migrating data from a Jira Server/DC instance along with AR Plans over to an Atlassian Jira Cloud site.

環境

  • JCMA 1.6.6 and higher
  • Jira Server/Data Center 7.6.0 and higher
  • Advanced Roadmaps

エラー

This error message below will surface when the user running the migration doesn't have access to the mentioned board (by its id) on the cloud. The <board-id> refers to the one present on the cloud.

2022-08-01 18:55:59.737998 ERROR CROSS-PROJECT-DATA project-import We couldn't import Issue Source <issue-source-id>. Reason: Issue source of type Board, with value [<board-id>] could not be found.

検証

First, validate if the user running the migration has access to the cloud board. One can use the URL below to validate that. Note: replace the <board-id> placeholder with the one from the log message, and the <instance> with the cloud site name.

https://<instance>.atlassian.net/secure/RapidBoard.jspa?rapidView=<board-id>

Error log:

2022-08-01 18:55:59.737998 ERROR CROSS-PROJECT-DATA project-import We couldn't import Issue Source 1. Reason: Issue source of type Board, with value [123] could not be found.

URL:

  • https://mysitename.atlassian.net/secure/RapidBoard.jspa?rapidView=123

If the user doesn't have access, it will get the pop-up below:

ソリューション

To get access to the board, the user running the migration should have the following permissions:

  1. Permission to see the filter associated with the board
  2. Permission to browse the project where the board is located

To identify which groups or project roles the user needs to have to see the filter, the user can verify this on the on-prem instance.

Filter View Permission

Via the database

Identify what are the permissions associated with the filter that has a relationship with the board within the plan. Please, replace the <issue-source-id> with the one present on the error logs.

PostgresSQL
SELECT r."NAME"      AS board_name 
	 , sr.filtername AS filter_name
	 , sr.reqcontent AS JQL
     , sp.sharetype  AS share_type
	 , CASE WHEN sp.sharetype = 'project' THEN p.pkey ELSE sp.param1 END AS param
  FROM "AO_D9132D_ISSUE_SOURCE" s
  JOIN "AO_60DB71_RAPIDVIEW" r ON (r."ID" = s."SOURCE_VALUE"::int)
  JOIN searchrequest sr        ON (sr.id = r."SAVED_FILTER_ID")
  JOIN sharepermissions sp     ON (sp.entityid = r."SAVED_FILTER_ID")
  LEFT JOIN project p          ON (p.id::text = sp.param1 AND sp.sharetype = 'project')
  WHERE s."SOURCE_TYPE" = 'Board'
    AND s."ID" = <issue-source-id>
    AND sp.entitytype = 'SearchRequest';
Oracle
SELECT r.NAME        AS board_name 
	 , sr.filtername AS filter_name
	 , sr.reqcontent AS JQL
     , sp.sharetype  AS share_type
	 , CASE WHEN sp.sharetype = 'project' THEN p.pkey ELSE sp.param1 END AS param
  FROM AO_D9132D_ISSUE_SOURCE s
  JOIN AO_60DB71_RAPIDVIEW r ON (dbms_lob.compare(s.SOURCE_VALUE, TO_CLOB(r.ID)) = 0)
  JOIN searchrequest sr      ON (sr.id = r.SAVED_FILTER_ID)
  JOIN sharepermissions sp   ON (sp.entityid = r.SAVED_FILTER_ID)
  LEFT JOIN project p        ON (sp.param1 = TO_CHAR(p.id) AND sp.sharetype = 'project')
 WHERE s.SOURCE_TYPE = 'Board'
   AND s.ID = <issue-source-id>
   AND sp.entitytype = 'SearchRequest';
MySQL
SELECT r.NAME        AS board_name 
	 , sr.filtername AS filter_name
	 , sr.reqcontent AS JQL
     , sp.sharetype  AS share_type
	 , CASE WHEN sp.sharetype = 'project' THEN p.pkey ELSE sp.param1 END AS param
  FROM AO_D9132D_ISSUE_SOURCE s
  JOIN AO_60DB71_RAPIDVIEW r ON (CAST(s.SOURCE_VALUE AS UNSIGNED) = r.ID)
  JOIN searchrequest sr      ON (sr.id = r.SAVED_FILTER_ID)
  JOIN sharepermissions sp   ON (sp.entityid = r.SAVED_FILTER_ID)
  LEFT JOIN project p        ON (sp.param1 = CAST(p.id AS CHAR) AND sp.sharetype = 'project')
 WHERE s.SOURCE_TYPE = 'Board'
   AND s.ID = <issue-source-id>
   AND sp.entitytype = 'SearchRequest';
MSSQL Server
SELECT r.NAME        AS board_name 
	 , sr.filtername AS filter_name
	 , sr.reqcontent AS JQL
     , sp.sharetype  AS share_type
	 , CASE WHEN sp.sharetype = 'project' THEN p.pkey ELSE sp.param1 END AS param
  FROM AO_D9132D_ISSUE_SOURCE s
  JOIN AO_60DB71_RAPIDVIEW r ON (CAST(s.SOURCE_VALUE AS NUMERIC) = r.ID)
  JOIN searchrequest sr      ON (sr.id = r.SAVED_FILTER_ID)
  JOIN sharepermissions sp   ON (sp.entityid = r.SAVED_FILTER_ID)
  LEFT JOIN project p        ON (sp.param1 = CAST(p.id AS VARCHAR(MAX)) AND sp.sharetype = 'project')
 WHERE s.SOURCE_TYPE = 'Board'
   AND s.ID = <issue-source-id>
   AND sp.entitytype = 'SearchRequest'


Based on the results of the query, make sure to mirror the same permissions on the cloud side.

board_namefilter_nameJQLshare_typeparam
CLAUD boardFilter for CLAUD boardproject = CLAUD ORDER BY Rank ASCgroupjira-administrators
CLAUD boardFilter for CLAUD boardproject = CLAUD ORDER BY Rank ASCプロジェクトCLAUD

For this case, one needs to add themselves to the group jira-administrators and have "Browse Projects" for the project CLAUD.

Via the UI

  • Access the board
  • Click on the Configure option on the board dropdown
  • Go to the General option
  • Look for the Shares configuration
  • Adjust the cloud permissions to reflect the same ones it listed on the on-prem site

プロジェクトの参照


One may need to use the database query above to find out to which project the board may be related on the cloud.

  • Access the settings of the project that will host the board on the cloud
  • Go to the permission scheme
  • Look for the groups/users/projects roles associated with the "Browse Projects" permission
  • Adjust the cloud permissions to reflect the same ones it listed on the on-prem site



最終更新日 2022 年 8 月 12 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.