Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
8.20.17, 9.9.0
-
None
-
8.2
-
1
-
Severity 3 - Minor
-
Description
Issue Summary
When you delete an issue type from Jira and that issue type is referenced in Advanced Roadmaps Exclusion configuration, the reference is not deleted ("AO_D9132D_EXCLUDED_ISSUE_TYPES" table) and becomes stale. This leads to errors in Server to Cloud migrations.
This is reproducible on Data Center: yes
Steps to Reproduce
- Create a custom issue type
- Create an Advanced Roadmaps plan
- Configure an exclusion rule for above created issue type
- Delete the issue type from Jira
Expected Results
The reference in the UI and the "AO_D9132D_EXCLUDED_ISSUE_TYPES" table is removed.
Actual Results
The issue type is removed from the UI however the entry remains in the "AO_D9132D_EXCLUDED_ISSUE_TYPES" table.
Can be found using the following query:
SELECT * FROM "AO_D9132D_EXCLUDED_ISSUE_TYPES" WHERE "ISSUE_TYPE" NOT IN (SELECT id::int FROM issuetype);
Workaround
Remove all exclusion rules from the plan via the UI and re-add to force a save of the configuration in the UI.
OR
DELETE FROM "AO_D9132D_EXCLUDED_ISSUE_TYPES" WHERE "ISSUE_TYPE" NOT IN (SELECT id::int FROM issuetype);
Attachments
Issue Links
- relates to
-
RAID-3538 Loading...