解决方案：

问题：请假单状态为审批通过，但是还是显示当前审批人，查看流程图的审批节点的状态为处理中

【适用版本】

通用

【分析处理】

待办转已办数据异常，可参考以下语句修复：

1、查询出需要待办转已办的处理中的数据做转储 

INSERT INTO T_WFR_AssignDetail  (FASSIGNID, FBODY_L1, FBODY_L2,  FBODY_L3,  FSTATE,  FPERSONUSERID,  FPERSONUSERNAME_L1, FPERSONUSERNAME_L2, FPERSONUSERNAME_L3,  FPERSONEMPID, FPERSONEMPNAME_L1, FPERSONEMPNAME_L2, FPERSONEMPNAME_L3,  FPERFORMERUID, FPERFORMERUNAME_L1, FPERFORMERUNAME_L2, FPERFORMERUNAME_L3,  FPERFORMEREID, FPERFORMERENAME_L1, FPERFORMERENAME_L2 ,FPERFORMERENAME_L3,  FACTINSTID, FACTDEFID, FACTDEFNAME_L1, FACTDEFNAME_L2, FACTDEFNAME_L3,  FPROCDEFHASH, FPROCDEFID, FPROCDEFNAME_L1, FPROCDEFNAME_L2, FPROCDEFNAME_L3,  FPROCINSTID, FENDTIME, FLASTSTATETIME, FCREATEDTIME, FFORWARDPATH, FEXTATTR,  FACCEPTTIME, FBIZPACKAGE, FBIZFUNCTION,  FBIZOPERATION,FBIZOBJID, FAPPDEFID, FPRIORITY,  FDURATION, FWORKINGTIME, FWAITINGTIME, FISSENDMSG,  FORGID, FORGTYPE,  FINITIATORNAME_L1, FINITIATORNAME_L2, FINITIATORNAME_L3,  FSUBJECT_L1, FSUBJECT_L2, FSUBJECT_L3,FPRIORPERFORMER, FPRIORPERFORMERNAME_l1, FPRIORPERFORMERNAME_l2, FPRIORPERFORMERNAME_l3, FBILLENTITY ,FResponsibleEmpId, FSourceAssignId )  SELECT Assign.FASSIGNID , Assign.FBODY_L1, Assign.FBODY_L2, Assign.FBODY_L3, Assign.FSTATE,

Assign.FPERSONUSERID,  Assign.FPERSONUSERNAME_L1, Assign.FPERSONUSERNAME_L2, Assign.FPERSONUSERNAME_L3,  Assign.FPERSONEMPID, Assign.FPERSONEMPNAME_L1, Assign.FPERSONEMPNAME_L2, Assign.FPERSONEMPNAME_L3,  Assign.FPERFORMERUID, Assign.FPERFORMERUNAME_L1, Assign.FPERFORMERUNAME_L2, Assign.FPERFORMERUNAME_L3,  Assign.FPERFORMEREID, Assign.FPERFORMERENAME_L1, Assign.FPERFORMERENAME_L2, Assign.FPERFORMERENAME_L3,  Assign.FACTINSTID, Assign.FACTDEFID,Assign.FACTDEFNAME_L1, Assign.FACTDEFNAME_L2, Assign.FACTDEFNAME_L3,  Assign.FPROCDEFHASH, Assign.FPROCDEFID, Assign.FPROCDEFNAME_L1, Assign.FPROCDEFNAME_L2, Assign.FPROCDEFNAME_L3,  Assign.FPROCINSTID, Assign.FENDTIME, Assign.FLASTSTATETIME, Assign.FCREATEDTIME, Assign.FFORWARDPATH, Assign.FEXTATTR,  Assign.FACCEPTTIME, Assign.FBIZPACKAGE, Assign.FBIZFUNCTION, Assign.FBIZOPERATION, Assign.FBIZOBJID, Assign.FAPPDEFID, Assign.FPRIORITY,  Assign.FDURATION, Assign.FWORKINGTIME, Assign.FWAITINGTIME, Assign.FISSENDMSG, AssignRead.FOrgID, AssignRead.FOrgType ,  ProcInst.finitiatorname_l1, ProcInst.finitiatorname_l2 , ProcInst.finitiatorname_l3,  Assign.FSUBJECT_L1, Assign.FSUBJECT_L2, Assign.FSUBJECT_L3, Assign.FPRIORPERFORMER, Assign.FPRIORPERFORMERNAME_l1, Assign.FPRIORPERFORMERNAME_l2, Assign.FPRIORPERFORMERNAME_l3, Assign.FBILLENTITY  ,Assign.FResponsibleEmpId, Assign.FSourceAssignId FROM T_WFR_Assign Assign  LEFT OUTER JOIN T_BAS_AssignRead AssignRead ON  AssignRead.FAssignID = Assign.FAssignID  JOIN T_WFR_ProcInst ProcInst ON  ProcInst.FPROCINSTID = Assign.FPROCINSTID

where Assign.fstate = 32 

2、将已办数据中的处理中状态改为已完成

UPDATE t_wfr_assigndetail  SET  fstate = 16 WHERE   fstate = 32

 【说明】

如果是某一条待办任务数据异常，可以在where条件中写上对应的待办任务id[FASSIGNID字段]