CMJ Integrity Check reports "X" refers to the missing priority Y

Symptoms:

A reference to a missing priority is reported by Integrity Check.


Cause:

The priority is not present on the system anymore, but it is still referenced in configuration, e.g. in a Priority scheme, in Agile boards Card Colors, etc.

Resolution:

If referenced by a Card color:

  • Try to change the Card Color strategy and then change it back, so that Agile can wipe the suggested values for possibly deleted objects and allow you to select only from existing ones.
  • If the problem persists the stale data must be deleted from the database using a similar SQL script: Afterwards, refresh JIRA’s internal caches for this change to be picked up – you can do that by going to CMJ’s Advanced page and clicking the Clear caches button.

    DELETE FROM "AO_60DB71_CARDCOLOR" WHERE RAPID_VIEW_ID=<THE AGILE BOARD'S ID> AND VAL=<THE ERRONEOUS VALUE>


If referenced in a Priority scheme:

  • Delete the broken references in the database. Create a db backup first!
  • Find the Priority scheme in select * from FIELDCONFIGSCHEME;
  • Find the broken reference in select * from optionconfiguration;
  • Delete the record with the broken reference from optionconfiguration

Note that the Priority can also be used as Default in the GENERICCONFIGURATION table! Verify that using
SELECT * FROM GENERICCONFIGURATION 

and remove the broken record if necessary.