执行了工作年限后台事务失败

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：1

执行了工作年限后台事务失败

日志报错:Sql1 execute exception : update T_HR_EmpLaborRelation labor set fenteryears = (select fenteryears from T_HR_EmpLaborRelationHis where labor.Fpersonid = Fpersonid and FisInner=1 and fendDateTime >= {ts '2199-12-31 23:59:59'})where exists(select fenteryears from T_HR_EmpLaborRelationHis where labor.Fpersonid = Fpersonid and FisInner=1 and fendDateTime >= {ts '2199-12-31 23:59:59'})
Caused exception message is: ORA-01427: 单行子查询返回多个行

分析:T_HR_EmpLaborRelationHis表数据错误,存在多笔2199的数据
排查是哪个职员数据错误:
select FPersonID from T_HR_EmpLaborRelationHis where FLeffdt={ts '2199-12-31 00:00:00'} group by FPersonID having count(1)>=2