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

[适用版本]

通用

[解决方案]

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

处理方案:

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

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.FPROCDEF