AnsweredAssumed Answered

ExecuteAsyncRunnable run Job failed

Question asked by javacorner on Mar 9, 2015
Latest reply on Mar 10, 2015 by jbarrez

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)

Outcomes