Skip to end of metadata
Go to start of metadata

Symptoms:

Duplicate object error for Agile board's Card Color is reported by Integrity Check.

Cause:

Integrity Check identifies Card Colors by their referenced object or by their query. The UI can also show misleading information as Agile boards can keep stale data in Card Colors' references.


Resolution:

  • Navigate to the problematic board in the UI, go over all card colors and make sure they don't use the same issue type/priority/user/query. There’s an edge case that if there are multiple Card Colors that reference an empty query, it will report duplicates. To fix this, just make sure there’s only one of this kind (if indeed it’s needed).
  • If the problem can't be resolved through the UI a SQL script similar to this can be used. 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 ID IN (SELECT ID FROM (
    	SELECT ID, RAPID_VIEW_ID, STRATEGY, VAL, ROW_NUMBER() OVER(PARTITION BY RAPID_VIEW_ID, STRATEGY, VAL) RN 
    	FROM AO_60DB71_CARDCOLOR
    ) WHERE RN > 1);


  • No labels