問題

Epics are not showing up under their Initiatives on Advanced Roadmaps Plan, even if they appearing in the Board filter and don't have the Fix Version field empty.

診断

環境

• All Jira and Advanced Roadmap versions

Diagnostic Steps

• Check if the Epics are with the correct hierarchy configuration referring to the Configuring hierarchy levels and have the Parent link set with the correct Initiative

• Check if the affected Epic has the Fix Version field Empty. If yes, you can check the database with the following queries (using the Epic AAA-1234 as an example):

SELECT id 
FROM jiraissue 
WHERE issuenum = 1234 
AND project in (select id from project where pkey = 'AAA');

SELECT * 
FROM nodeassociation 
WHERE source_node_id in (select id from jiraissue where issuenum = 1234 and project in (select id from project where pkey = 'AAA')) 
AND sink_node_entity like 'Version' 
AND source_node_entity like 'Issue';

SELECT * 
FROM projectversion 
WHERE id = SINK_NODE_ID_HERE;

原因

If a Fix Version was removed from Jira, directly from the database projectversion table or by using some add-on, it could remain linked to its issues (in this case, linked to the Epics), and if those Fix Versions were not set to the Plan, the Epics will not appear on Advanced Roadmaps, even if they are appearing on their respective Board filter.

ソリューション

To solve this, we will need to check all the Fix Versions that are on the database nodeassociation table and don't exist on projectversion table. We will remove them and try to re-apply the Parent Link in the affected Epics. Please, follow the below steps to perform this action:

SELECT sink_node_id 
FROM nodeassociation 
WHERE sink_node_id not in (select id from projectversion) 
AND sink_node_entity = 'Version' 
ORDER BY source_node_id;

DELETE FROM nodeassociation 
WHERE sink_node_id in (select sink_node_id from nodeassociation where sink_node_id not in (select id from projectversion) and sink_node_entity = 'Version') 
AND sink_node_entity like 'Version' 
AND source_node_entity like 'Issue';

3. Jira の起動

4. Re-apply the Epic's Parent Link, by updating the field with the correct Initiative

5. Check if the Epics are appearing under the initiatives as expected