Asynchronous Process with DB2

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

kirek

Hi,
i have a problem with an asynchronous service task.
I built a very simple process..

[attachment=0]process.JPG[/attachment]

..with an asynchronous serviceTask.
The process fails all the time with db2 and throws this exception:  :roll:

### Error querying database.  Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.59.81
### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectExclusiveJobsToExecute-Inline
### The error occurred while setting parameters
### Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.59.81
‍‍‍‍‍

if I execute the process with h2, it runs without any exceptions..

Can anyone help, please?   ops:

process_1.JPG

kirek

I found the problem.

There is a bug in the activiti-engine-5.9.jar/org.activiti.db.mapping.entity/job.xml

&nbsp; <select id="selectExclusiveJobsToExecute" parameterType="map" resultMap="jobResultMap"><br>&nbsp;&nbsp;&nbsp; select * <br>&nbsp;&nbsp;&nbsp; from ACT_RU_JOB&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; where (RETRIES_ &gt; 0)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (DUEDATE_ is null or DUEDATE_ &lt; #{now, jdbcType=TIMESTAMP})<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; #{now, jdbcType=TIMESTAMP})<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (RETRIES_ &gt; 0)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (EXCLUSIVE_ = TRUE)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and (PROCESS_INSTANCE_ID_ = #{pid})&nbsp; <br>&nbsp; </select>
This sql tries to compare the EXCLUSIVE_ with "TRUE". But in DB2 "EXCLUSIVE_" is created as a smallint and should be compared with "1" (like oracle)

I fixed the problem by replacing "TRUE" with "1"