Bug 1116020

Description of problem:

The issue reported in "JBPM-3722" is reproducible in BPM Suite 6 when using Mysql. It seems like the issue has been fixed only for databases that uses sequences.

I created a simple process and forced an exception when starting it. The process data is stored in processinstanceinfo table, but "processinstancebytearray" is null. Then it is not possible to abort the process.

Version-Release number of selected component (if applicable):

BPM Suite 6
Mysql (tested on 5.1 version)

How reproducible:

Always

Steps to Reproduce:
1. Setup your BPM Suite to use Mysql as external database
2. Create a really simple process using "Manual Task". It will not be needed to add anything to that as it should throw an exception after starting.
3. Save process/ Deploy project/ Start process


Actual results:

It will throw an error in console and in server.log:
10:46:31,959 WARN  [org.drools.persistence.SingleSessionCommandService] (http-localhost.localdomain/127.0.0.1:8080-5) Could not commit session: org.jbpm.workflow.instance.WorkflowRuntimeException: [project1.sample4:3 - :2] -- Could not find work item handler for Manual Task

But the rollback will not be performed and data will be stored in processinstanceinfo and processinstancelog.


Expected results:

It should rollback the transaction.


Additional info:

A workaround exist: You can delete the process manually in database using the following queries:

delete from ProcessInstanceInfo where InstanceId=XX;
delete from ProcessInstanceLog where processInstanceId=XX;

Note: Make sure you are deleting the right process.