1、问题描述

2、解决方案

该问题先修复数据

--查询是否有重复脏数据

SELECT FORGID,FUSERID,FTYPE FROM T_PM_ORGRANGE group by FORGID,FUSERID,FTYPE having count(1)>1

注意：如上述查询有结果则执行下面方案

--备份

SELECT * into T_PM_ORGRANGE_bak1110 FROM T_PM_ORGRANGE

--检查是否备份成功

select count(1) from T_PM_ORGRANGE_bak1110

--删除脏数据

DELETE FROM T_PM_ORGRANGE WHERE fid not in (SELECT max(Fid) FROM T_PM_ORGRANGE group by FORGID,FUSERID,FTYPE having count(1)>1) and fid in (SELECT t1.fid FROM T_PM_ORGRANGE t1 

inner join (SELECT FORGID,FUSERID,FTYPE FROM T_PM_ORGRANGE group by FORGID,FUSERID,FTYPE having count(1)>1) t2

on t1.FORGID=t2.FORGID

and t1.FUSERID = t2.FUSERID

and t1.FTYPE = t2.FTYPE)

以上方案是修复脏数据方案，造成该问题的解决方案：

EAS 8.8版本中可安装补丁PT174619来解决此问题，请更新至该补丁或最新补丁即可。

3、注意

 安装补丁方法请参考补丁说明，并严格按照补丁说明进行补丁安装。必要时可以在测试环境下先验证通过。