Symptoms:
Missing object error for Agile board's Card Color A reference to a missing priority is reported by Integrity Check, but such object .
Cause:
The priority is not present on the system anymore
...
Cause:
, but it is still referenced in configuration, e.g. in a Priority scheme, in Agile boards Card Colors can contain stale references to other configuration objects that are deleted from the system, 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.
Code Block language sql 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.