CMJ Integrity Check reports Duplicate object error for Agile board Card Colors

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);