JCMA fails to export project if ARJ contains permissions with missing group

Issue Summary

JCMA will fail to export a project if Advanced Roadmaps for Jira (ARJ) contains a permission with a missing group. The customer did not select to migrate ARJ plan. They selected none for this option.

JCMA failed with the error:

ERROR <ProjectKey> project-export Group reference could not be found. Details: Plugin permission with id - [8] has missing reference to group - [<groupname>]

Steps to Reproduce

• Create an Advanced Roadmaps permission that contains a group reference
• Delete the group
• Confirm there are no project-specific references to this group (project permission scheme, etc)
• Use JCMA to migrate a project. Select skip plans for Advanced Roadmaps for Jira option

Expected Results

JCMA should not be relying on Advanced for Roadmaps for Jira permissions to validate project export if ARJ is not selected as part of the migration.

The migration should have been completed since the project did not contain any other reference to this group.

Actual Results

JCMA failed to migrate the project. There is a record in the table "AO_A415DF_AOPERMISSION" that contains the missing group. This is a table specific to Advanced Roadmaps for Jira.

Workaround

Running the following SQL query helped identify the invalid permission in ARJ where there was a missing group:

SELECT * FROM "AO_A415DF_AOPERMISSION"
WHERE "HOLDER_TYPE" IS NULL
   OR "HOLDER_TYPE" <> 'group'
   OR ("HOLDER_TYPE" = 'group' AND "HOLDER_ID" NOT IN (SELECT group_name FROM cwd_group));

• Option 1 - The group can be manually created
• Option 2 - The permission that contains the missing group for ARJ should be deleted/updated to remove the reference