【8.0.102】服务端命令发起流程执行发生错误，State code 为[500]，请求体为[Timeo...

异常日志： forguncyBpmServer-37146.log

1. 2023-03-19 16:45:55,342 135387978[:1-37146-exec-3] ERROR ception.GlobalExceptionHandler  - [GlobalExceptionHandler] - [ActivitiException.cause], {detailInfo}
   
2. javax.el.ELException: com.grapecity.forguncy.common.exception.ForguncyRuntimeException: State code 为[500]，请求体为[Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]。
   
3.         at javax.el.BeanELResolver.invoke(BeanELResolver.java:164)
   
4.         at org.activiti.core.el.ELResolverDecorator.invoke(ELResolverDecorator.java:52)
   
5.         at org.activiti.core.el.ELResolverReflectionBlockerDecorator.invoke(ELResolverReflectionBlockerDecorator.java:54)
   
6.         at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:79)
   
7.         at de.odysseus.el.tree.impl.ast.AstMethod.eval(AstMethod.java:91)
   
8.         at de.odysseus.el.tree.impl.ast.AstMethod.eval(AstMethod.java:100)
   
9.         at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51)
   
10.         at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:31)
    
11.         at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122)
    
12.         at org.activiti.engine.impl.delegate.invocation.ExpressionGetInvocation.invoke(ExpressionGetInvocation.java:37)
    
13.         at org.activiti.engine.impl.delegate.invocation.DelegateInvocation.proceed(DelegateInvocation.java:39)
    
14.         at org.activiti.engine.impl.delegate.invocation.DefaultDelegateInterceptor.handleInvocation(DefaultDelegateInterceptor.java:29)
    
15.         at org.activiti.engine.impl.el.JuelExpression.getValueFromContext(JuelExpression.java:94)
    
16.         at org.activiti.engine.impl.el.JuelExpression.getValue(JuelExpression.java:54)
    
17.         at org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior.handleAssignments(UserTaskActivityBehavior.java:305)
    
18.         at org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior.execute(UserTaskActivityBehavior.java:222)
    
19.         at org.activiti.engine.impl.agenda.ContinueProcessOperation.executeActivityBehavior(ContinueProcessOperation.java:235)
    
20.         at org.activiti.engine.impl.agenda.ContinueProcessOperation.executeSynchronous(ContinueProcessOperation.java:155)
    
21.         at org.activiti.engine.impl.agenda.ContinueProcessOperation.continueThroughFlowNode(ContinueProcessOperation.java:112)
    
22.         at org.activiti.engine.impl.agenda.ContinueProcessOperation.run(ContinueProcessOperation.java:77)
    
23.         at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:77)
    
24.         at org.activiti.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:61)
    
25.         at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:46)
    
26.         at org.activiti.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:52)
    
27.         at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:63)
    
28.         at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:51)
    
29.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
    
30.         at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49)
    
31.         at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
    
32.         at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:59)
    
33.         at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:54)
    
34.         at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceById(RuntimeServiceImpl.java:127)
    
35.         at com.grapecity.forguncy.service.process.instance.StartInstanceService.startProcess(StartInstanceService.java:106)
    
36.         at com.grapecity.forguncy.service.process.instance.StartInstanceService.executeInstanceAction(StartInstanceService.java:53)
    
37.         at com.grapecity.forguncy.service.process.instance.StartInstanceService.executeInstanceAction(StartInstanceService.java:39)
    
38.         at com.grapecity.forguncy.service.process.instance.InstanceAction.doExecute(InstanceAction.java:27)
    
39.         at com.grapecity.forguncy.service.process.instance.InstanceAction.doExecute(InstanceAction.java:17)
    
40.         at com.grapecity.forguncy.common.component.TransactionManager.lambda$executeWithTransaction$0(TransactionManager.java:38)
    
41.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
    
42.         at com.grapecity.forguncy.common.component.TransactionManager.executeWithTransaction(TransactionManager.java:38)
    
43.         at com.grapecity.forguncy.service.TransactionAction.execute(TransactionAction.java:28)
    
44.         at com.grapecity.forguncy.service.ActionFactory.createAndExecute(ActionFactory.java:26)
    
45.         at com.grapecity.forguncy.controller.process.ProcessInstanceController.start(ProcessInstanceController.java:42)
    
46.         at com.grapecity.forguncy.controller.process.ProcessInstanceController$FastClassBySpringCGLIB$dfec48cb.invoke(<generated>)
    
47.         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    
48.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    
49.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    
50.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
    
51.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    
52.         at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
    
53.         at com.grapecity.forguncy.aspect.GlobalControllerAspect.processWithLog(GlobalControllerAspect.java:119)
    
54.         at com.grapecity.forguncy.aspect.GlobalControllerAspect.around(GlobalControllerAspect.java:66)
    
55.         at jdk.internal.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)
    
56.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    
57.         at java.base/java.lang.reflect.Method.invoke(Unknown Source)
    
58.         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
    
59.         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
    
60.         at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
    
61.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    
62.         at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:55)
    
63.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    
64.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
    
65.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    
66.         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
    
67.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    
68.         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    
69.         at com.grapecity.forguncy.controller.process.ProcessInstanceController$EnhancerBySpringCGLIB$746aac58.start(<generated>)
    
70.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
71.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    
72.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    
73.         at java.base/java.lang.reflect.Method.invoke(Unknown Source)
    
74.         at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
    
75.         at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
    
76.         at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
    
77.         at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
    
78.         at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
    
79.         at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    
80.         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
    
81.         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
    
82.         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
    
83.         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
    
84.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
    
85.         at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
    
86.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    
87.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    
88.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    
89.         at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    
90.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    
91.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    
92.         at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
    
93.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    
94.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    
95.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    
96.         at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
    
97.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    
98.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    
99.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    
100.         at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
     
101.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
     
102.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
     
103.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
     
104.         at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
     
105.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
     
106.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
     
107.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
     
108.         at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117)
     
109.         at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106)
     
110.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
     
111.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
     
112.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
     
113.         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
     
114.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
     
115.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
     
116.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
     
117.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
     
118.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
     
119.         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
     
120.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
     
121.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
     
122.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
     
123.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
     
124.         at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
     
125.         at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
     
126.         at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
     
127.         at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
     
128.         at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
     
129.         at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
     
130.         at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
     
131.         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
     
132.         at java.base/java.lang.Thread.run(Unknown Source)
     
133. Caused by: com.grapecity.forguncy.common.exception.ForguncyRuntimeException: State code 为[500]，请求体为[Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]。
     
134.         at com.grapecity.forguncy.infrastructure.invoke.InvokeServiceImpl.handleResponse(InvokeServiceImpl.java:322)
     
135.         at com.grapecity.forguncy.infrastructure.invoke.InvokeServiceImpl.invoke(InvokeServiceImpl.java:254)
     
136.         at com.grapecity.forguncy.model.api.Invokable.invoke(Invokable.java:66)
     
137.         at com.grapecity.forguncy.listener.assignee.assigneeinfo.AllAssigneeDigger.digSingleAssignee(AllAssigneeDigger.java:28)
     
138.         at com.grapecity.forguncy.listener.assignee.AssigneeHelperImpl.getSingleAssignee(AssigneeHelperImpl.java:87)
     
139.         at com.grapecity.forguncy.listener.assignee.AssigneeHelperImpl.soluteAssignee(AssigneeHelperImpl.java:51)
     
140.         at com.grapecity.forguncy.common.expression.UserTaskExpressionResolver.getAssignee(UserTaskExpressionResolver.java:16)
     
141.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     
142.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     
143.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     
144.         at java.base/java.lang.reflect.Method.invoke(Unknown Source)
     
145.         at javax.el.BeanELResolver.invoke(BeanELResolver.java:158)
     
146.         ... 129 more

复制代码

大佬，这个问题是怎么发生的呢，流程使用的是外连数据库嘛，流程事件中是不是调用了含有执行sql命令的服务端命令呢。可以将链接字符串的高级设定中的链接超时时长调大一些

或者将执行sql命令的执行超时时间调大一些哈试试哈

Lay.Li 发表于 2023-3-20 10:24
大佬，这个问题是怎么发生的呢，流程使用的是外连数据库嘛，流程事件中是不是调用了含有执行sql命令的服务 ...

目前测试出现的原因是：
1.在流程建模设计界面，流程属性设置关联数据表，并人工节点的负责人指定关联表的字段
2.在服务端命令发起流程，关联数据表和数据条件（关联表与流程设计界面关联的表是同一个表）
3.执行服务端命令，发起流程出现如上异常

大佬，我这边按您的描述，在服务端命令中发起流程，并没有复现这个问题哈，有没有可以复现问题的工程文件呢，建议您可以发一个demo上来，这样我们也可以更好的帮助到您