topic Re: Possible Error in the activiti.oracle.create.engine.sql in Alfresco Archive

Possible Error in the activiti.oracle.create.engine.sql

casten2809 — Fri, 04 Apr 2014 09:28:43 GMT

I use Activiti since maybe one year.Now I use the ACT_RU_VARIABLE table to get the PROC_INST_ID of the execution.I use this, becaus I think this is one of the the easiest way to get the PROC_INST_ID.Now the Problem:If I create a processdefinition with a Parallel-Gateway( and I know the ExecutionId a

Re: Possible Error in the activiti.oracle.create.engine.sql

jbarrez — Tue, 22 Apr 2014 08:35:32 GMT

> I see that ExecutionId and the ProcessInstanceId are the same at the table

A process instance in activiti is also an execution. More specifically, a process instance is the root of an execution tree. If your process is simple enough, you will there is only one execution. Which is also your process instance.

In a more complex process, there will be a whole hierarchy of executions for a process instance.

Re: Possible Error in the activiti.oracle.create.engine.sql

casten2809 — Tue, 22 Apr 2014 11:46:05 GMT

>> "In a more complex process, there will be a whole hierarchy of executions for a process instance."

There is the Problem I mean.

When I use a Parallel Gateway there should be two Variables with the same Processinstance ID and different Executionen ID, but there ae only on with the same EXECUTION_ID_ like the PROC_INST_ID_ by the table ACT_RU_VARIABLE.
The Execution ID is thr Processinstaance ID in this table.

Re: Possible Error in the activiti.oracle.create.engine.sql

jbarrez — Thu, 24 Apr 2014 07:13:22 GMT

Well, the Activiti engine is smart enough to recycle certain executions, and reuse the same execution for multiple purposes.
If you could show your problem in a unit test it would clarify things a lot for me.

Re: Possible Error in the activiti.oracle.create.engine.sql

casten2809 — Thu, 22 May 2014 07:52:35 GMT

Here an Example of my Database-Entry:
ACT_RU_EXECUTION:
<table>
<th>ID_ </th>
<th>REV_</th>
<th> PROC_INST_ID_ </th>
<th>PARENT_ID_ </th>
<th> PROC_DEF_ID_</th>
<th> ACT_ID_</th>
<tr>
<td>3213</td>
<td>5</td>
<td>3213</td>
<td></td>
<td> vertragsanbahnung:48:3210</td>
<td>parallelGateway1</td>
</tr>
<tr>
<td>3366</td>
<td>1</td>
<td>3213</td>
<td>3213</td>
<td>vertragsanbahnung:48:3210</td>
<td>userTask1</td>
</tr>
<tr>
<td>3367</td>
<td>1</td>
<td>3213</td>
<td>3213</td>
<td>vertragsanbahnung:48:3210</td>
<td>userTask2</td>
</tr>
</table>

ACT_RU_VARIABLE
<table>
<th>ID_ </th>
<th>REV_</th>
<th>TYPE_ </th>
<th>NAME_ </th>
<th>EXECUTION_ID_ </th>
<th>PROC_INST_ID </th>
<th>TEXT_</th>
<tr>
<td>3250</td>
<td>1</td>
<td>string</td>
<td>result</td>
<td>3213</td>
<td>3213</td>
<td>400</td>
</tr>
</table>

The Entry by the ACT_RU _VARIABLE should be the variables of the Execution "3367" and not the Variables of the whole Process (3213).

Re: Possible Error in the activiti.oracle.create.engine.sql

jbarrez — Thu, 22 May 2014 11:33:03 GMT

Ok I see. Did you try .setVariableLocal (or any method that allows you to put vars locally?)

Re: Possible Error in the activiti.oracle.create.engine.sql

casten2809 — Thu, 22 May 2014 12:01:04 GMT

No! I will try it.