ExecuteAsyncRunnable run Job failed

[javacorner]

Hello,
Kindly assist me.
I created very simple aciviti application.
i deployed process definition then created new instance .
i faced exception as below.

-the  process definition  is very simple :
it contains from 2 ".bpmn" files
first file start the process then call Asynchronous "call activity"
second file  is the   call activity definition which  is just start event then service task then end.
Actually No real logic included in the process . I want to run it successful first then implement Java delegates .

1-my web application starts and destroys the ProcessEngines at ServletContextListener.
2-I deploy the process definition
Deployment deployment = repositoryService.createDeployment().addClasspathResource("me/ffusion/bpm/diagrams/offlinestatement.bpmn").addClasspathResource("me/ffusion/bpm/diagrams/exportRecord.bpmn")
               .name("offlinestatement.bpmn").deploy();
3- I start Process Instance ByKey then find below error
ProcessInstance processInstance = runtimeService.startProcessInstanceByKey(OFFLINE_PROCESS_ID,variables);
————————– Error DESCRIPTION —————————
-The execution of a job has failed.JobHandlerType=async-continuation

-ExecuteAsyncR E org.activiti.engine.impl.asyncexecutor.ExecuteAsyncR E org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable run Job 75043 failed

-org.apache.ibatis.exceptions.PersistenceException

-Cause: org.apache.ibatis.type.TypeException:

-Error setting null for parameter #1 with JdbcType OTHER

-Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property

-java.sql.SQLException: Invalid column type: 1111

-The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectLatestProcessDefinitionByKey-Inline

-The error occurred while setting parameters

-SQL: select *     from ACT_RE_PROCDEF      where KEY_ = ? and           (TENANT_ID_ = ''  or TENANT_ID_ is null) and           VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ? and (TENANT_ID_ = '' or TENANT_ID_ is null))

-Cause: org.apache.ibatis.type.TypeException

-org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)

[martin_grofcik]

Hi Moustafa.

I have found one test in activiti source which is similar to your case:
org.activiti.engine.test.bpmn.async.AsyncTaskTest#testBasicAsycCallActivity.
Please have a look.

Regards
Martin

[javacorner]

Hello Martin
I am using latest version of activiti 5.17 .
I have org.activiti.engine.impl.test.PluggableActivitiTestCase in JAR of activiti-engine-5.17.0.jar
I can not find AsyncTaskTest .
In github.com I found AsyncTaskTest but I can not find method of testBasicAsycCallActivity.
link=https://github.com/Activiti/Activiti/blob/master/modules/activiti-engine/src/test/java/org/activiti/...

what is the jar I have to include to find AsyncTaskTest ?
or what I have to do?

[martin_grofcik]

Hi,
https://github.com/Activiti/Activiti/blob/77895c126163266d8cf662f1914c829ea627e0e6/modules/activiti-...

Regards
Martin

[javacorner]

Hi martin,

I appropriate your replay
AsyncTaskTest which is in github.com  is not part of the JAR of activiti-engine-5.17.0.jar.
If I copied the java source of AsyncTaskTest  and run the unit test in my environment so I still need files like "org/activiti/engine/test/bpmn/async/AsyncTaskTest.testBasicAsyncCallActivity.bpmn20.xml" which I don't have .

- Why activiti-engine-5.17.0.jar doesn't have package of "bpmn" under "org.activiti.engine.test"?

- Any way the test of AsyncTaskTest is use the same code that I tried before .  The problem still exists . which is -as I understand -:
Why the activiti engine try to set value of "KEY_" as NULL in the following SQL when it try to get process definition from aciviti database?
select * from ACT_RE_PROCDEF where KEY_ = ? and (TENANT_ID_ = '' or TENANT_ID_ is null) and VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ? and (TENANT_ID_ = '' or TENANT_ID_ is null))

[javacorner]

Hi,

I tried deploy the process at the "activiti-explorer" and I faced the following error in LOG file of tomcat :


10-Mar-2015 10:24:59.145 SEVERE [http-apr-8080-exec-6] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/activiti-explorer] threw exception [Request processing failed; nested exception is org.activiti.engine.ActivitiIllegalArgumentException: key is null] with root cause
org.activiti.engine.ActivitiIllegalArgumentException: key is null
at org.activiti.engine.impl.ProcessDefinitionQueryImpl.processDefinitionKey(ProcessDefinitionQueryImpl.java:129)
at org.activiti.engine.impl.ProcessDefinitionQueryImpl.processDefinitionKey(ProcessDefinitionQueryImpl.java:36)
at org.activiti.rest.diagram.services.BaseProcessDefinitionDiagramLayoutResource.getActivity(BaseProcessDefinitionDiagramLayoutResource.java:441)
at org.activiti.rest.diagram.services.BaseProcessDefinitionDiagramLayoutResource.getDiagramNode(BaseProcessDefinitionDiagramLayoutResource.java:211)
at org.activiti.rest.diagram.services.ProcessDefinitionDiagramLayoutResource.getDiagram(ProcessDefinitionDiagramLayoutResource.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.activiti.explorer.servlet.JsonpCallbackFilter.doFilter(JsonpCallbackFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.activiti.explorer.filter.ExplorerFilter.doFilter(ExplorerFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:277)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2407)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2396)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1177)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:795)

10-Mar-2015 10:25:27.991 SEVERE [http-apr-8080-exec-5] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/activiti-explorer] threw exception [Request processing failed; nested exception is org.activiti.engine.ActivitiIllegalArgumentException: key is null] with root cause
org.activiti.engine.ActivitiIllegalArgumentException: key is null
at org.activiti.engine.impl.ProcessDefinitionQueryImpl.processDefinitionKey(ProcessDefinitionQueryImpl.java:129)
at org.activiti.engine.impl.ProcessDefinitionQueryImpl.processDefinitionKey(ProcessDefinitionQueryImpl.java:36)
at org.activiti.rest.diagram.services.BaseProcessDefinitionDiagramLayoutResource.getActivity(BaseProcessDefinitionDiagramLayoutResource.java:441)
at org.activiti.rest.diagram.services.BaseProcessDefinitionDiagramLayoutResource.getDiagramNode(BaseProcessDefinitionDiagramLayoutResource.java:211)
at org.activiti.rest.diagram.services.ProcessDefinitionDiagramLayoutResource.getDiagram(ProcessDefinitionDiagramLayoutResource.java:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.activiti.explorer.servlet.JsonpCallbackFilter.doFilter(JsonpCallbackFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.activiti.explorer.filter.ExplorerFilter.doFilter(ExplorerFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:277)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2407)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2396)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1177)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:795)

[javacorner]

Hi,
I found the error

in callActivity tag inside process definition I forget attribute of "calledElement"  .

[jbarrez]

Allright, thanks for posting back.