[适用版本]

通用

[解决方案]

问题:打卡记录同步失败,提示:EAS多个职员手机号相同,不能同步。

处理方案:

t_pm_easxtusermap表存在脏数据导致,相关修复语句参考如下:

--查询异常数据

select * from t_pm_easxtusermap where fpersonid not in(select fid from t_bd_person) and fcell in(select fcell from t_pm_easxtusermap group by fcell having count(1)>1)

--备份数据

select * into easxtusermap0604 from t_pm_easxtusermap

--删除异常数据

delete from t_pm_easxtusermap where fpersonid not in(select fid from t_bd_person) and fcell in(select fcell from t_pm_easxtusermap group by fcell having count(1)>1)