常见问题-报错“该记录已不存在，MissingRecord:Positionid”

一、报错日志

错误详细堆栈信息：com.kingdee.bos.eventbus.exception.EventHandlerExecuteException: com.kingdee.bos.dao.ObjectNotFoundException: MissingRecord:Position id = 'hMG2sklYRHWUqxT0keRLBXSuYS4='  AIS:A01 username:张三       

at: com.kingdee.bos.eventbus.support.SimpleEventBus.fireAEvent（SimpleEventBus.java:340）        

at: com.kingdee.bos.eventbus.support.SimpleEventBus.fireEvent（SimpleEventBus.java:304） 

二、问题分析

-- 1、先确定该职位是否已被删除了

select * from T_ORG_Position where fid ='hMG2sklYRHWUqxT0keRLBXSuYS4=';

-- 2、查询是否有职员绑定了该职位

select *  from T_ORG_PositionMember where FPOSITIONID = 'hMG2sklYRHWUqxT0keRLBXSuYS4=';

-- 如果有为脏数据，需要删除该记录

-- 3、备份

select * into T_ORG_PositionMemberbak from T_ORG_PositionMember;

-- 4、删除数据

delete from T_ORG_PositionMember where FPOSITIONID = 'hMG2sklYRHWUqxT0keRLBXSuYS4=';