Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

    Code Block
    languagesql
    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);