- 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.
Code Block language sql
DELETE FROM AO_60DB71_CARDCOLOR WHERE ID inIN (SELECT ID FROM ( SELECT t.*, count(val) as c FROM AO_60DB71_CARDCOLOR t GROUP SELECT ID, RAPID_VIEW_ID, STRATEGY, VAL, ROW_NUMBER() OVER(PARTITION BY RAPID_VIEW_ID, valSTRATEGY, HAVINGVAL) c>1 ) dupRN FROM AO_60DB71_CARDCOLOR ) WHERE RN > 1);