[适用版本]

通用

[解决方案]

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

处理方案:

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

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字段]