流程实例 中找不到环节实例 "null"

佚名

build version : 5.3.7.6161   bex5
如题, 系统中的流程任务经常在点击流转的时候 报错, 提示   
流程实例"B33C01DD09E94B168CD0BB837AEE9988"中找不到环节实例"null"


有些时候 能通过特送解决报错, 但是有些时候特送也是报一样的错误 请协助解决

后台报错

java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:885)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1693)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.ProcessUtils.specialProcess(Unknown Source)
        at ExternalProcessProcedure.specialProcess(ExternalProcessProcedure.java:73)
        ... 37 more
Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180223; 提示: 流程实例"B33C01DD09E94B168CD0BB837AEE9988"中找不到环节实例"null"
        at com.justep.system.util.BizSystemException.create(Unknown Source)
        at com.justep.system.process.ProcessInstance.getAI(Unknown Source)
        at com.justep.system.process.PNEngineUtils.getFrontAIs(Unknown Source)
        at com.justep.system.process.PNEngineUtils.getFrontAIs(Unknown Source)
        at com.justep.system.process.PNEngineUtils.getJoinAIs(Unknown Source)
        at com.justep.system.process.PNEngineUtils.getJoinAIs(Unknown Source)
        at com.justep.system.process.PNEngineUtils.getWaitAIs(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.flowOutByAction(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.special(Unknown Source)
        at ProcessProcedure.specialProcess(ProcessProcedure.java:297)
        ... 48 more

jishuang

1.看运行时的波特图和轨迹图是不是有断开的
2.根据报错的流程实例id到sa_task表中能找到对应的任务id，然后查找sa_taskRelation表中staskID1的值in这些的看staskID2的值是不是在任务表中不存在

佚名

jishuang 发表于 2024-5-8 16:36
1.看运行时的波特图和轨迹图是不是有断开的
2.根据报错的流程实例id到sa_task表中能找到对应的任务id，然后 ...

1. 波特图和轨迹图没有断开
2. 经查,在 sa_taskRelation 根据 STASKID2 = 任务id 查询到一个 id , 根据查询到这个id 在task表中可以查到一条记录  

jishuang

sa_taskRelation中staskID1的值in在sa_task表中查流程实例id的任务id
看staskID2的值，不是直接STASKID2 = 任务id

佚名

jishuang 发表于 2024-5-8 19:21
sa_taskRelation中staskID1的值in在sa_task表中查流程实例id的任务id
看staskID2的值，不是直接STASKID2 = ...

select STASKID2
from CSCEC_SYS.sa_taskRelation where  STASKID1 in (select sid
from CSCEC_SYS.SA_TASK t
where SFLOWID  = 'B33C01DD09E94B168CD0BB837AEE9988')
有42条数据

select *
from CSCEC_SYS.SA_TASK where sid in (

select STASKID2
from CSCEC_SYS.sa_taskRelation where  STASKID1 in (select sid
from CSCEC_SYS.SA_TASK t
where SFLOWID  = 'B33C01DD09E94B168CD0BB837AEE9988')

                               ) ;

就只有37调数据了,  看起来好像是缺了一些,  这个问题是什么导致的呢  这个流程数据还能不能修复

jishuang

那就看具体确的是什么数据，不行把缺少的数据该了
是sa_taskRelation中能连起来，如有4个taskid值A、B、C、D
那么sa_taskRelation中的值应该是
sTaskID1    sTaskID2
A                B
B                C
C                D

佚名

jishuang 发表于 2024-5-9 11:49
那就看具体确的是什么数据，不行把缺少的数据该了
是sa_taskRelation中能连起来，如有4个taskid值A、B、C、 ...

对比了一下看后面的几条待办任务的 sa_taskRelation 数据都是没问题的
找了两条别的数据看也没看出来差异, 最后终止掉重新发起了. 放弃维护数据了

请问这种情况是如何发生的, 怎么避免再出现这种报错呢

jishuang

要看具体什么地方任务关系表数据不对了，不对的任务具体做了什么操作