Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-75925

Deleting an issue type does not remove references from Advanced Roadmaps Plan Exclusions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Low
    • None
    • 8.20.17, 9.9.0
    • None

    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

      1. Create a custom issue type
      2. Create an Advanced Roadmaps plan
      3. Configure an exclusion rule for above created issue type
      4. 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

          Activity

            People

              Unassigned Unassigned
              6c05774b4db4 Carl Adolfson
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: