背景
JIRA Software 8.8.0
BigPicture 7.11.6
Mysql5.7
现象
使用BigPicture新创建和的旧创建的，在设置完成BigPicture一个Program如果，打开Gannt图，界面 会出现错误提示，不能显示Gannt图
后台再现以下错误
解决方案
在数据库中执行以下脚本
DROP PROCEDURE IF EXISTS AO_0456E7_removeDuplicates;
DELIMITER $$
CREATE PROCEDURE AO_0456E7_removeDuplicates()
BEGIN
DECLARE counter INT DEFAULT 0;
DECLARE result VARCHAR(100) DEFAULT '';
REPEAT
SET result = CONCAT(result,counter,',');
SET counter = (SELECT COUNT(id) FROM (SELECT MAX(ID) as id FROM AO_0456E7_GLOBAL_TASK e2 GROUP BY TASK_ID HAVING COUNT(*) > 1) x);
DELETE FROM AO_0456E7_GLOBAL_TASK WHERE ID IN (SELECT id FROM (SELECT MAX(ID) AS id FROM AO_0456E7_GLOBAL_TASK e2 GROUP BY TASK_ID HAVING COUNT(*) > 1) x);
UNTIL counter = 0
END REPEAT;
ALTER TABLE AO_0456E7_GLOBAL_TASK ADD CONSTRAINT AO_0456E7_GLOBAL_TASK_TASK_ID_KEY UNIQUE (TASK_ID);
SET @v1 = (SELECT COUNT(id) FROM (SELECT MAX(ID) as id FROM AO_0456E7_GLOBAL_TASK e2 GROUP BY TASK_ID HAVING COUNT(*) > 1) x);
SELECT result, @v1;
END$$
DELIMITER ;