Incorrect data in ACT_RU_execution table

[ambikakhatri]

Hi,

  I have built few activiti processes. I noticed when these process run, act_ru_execution table has entry only for first task. No other tasks make it to this table. I want to query this table for active tasks and show on UI. Am I doing anything wrong. Do only async tasks make it to this table. Thanks in advance.

Regards,
Ambika

[hari]

Hi Ambika,

Only a user task or a receive task will be persisted to the ACT_RU_EXECUTION table.
Also its not always that just one entry will be there. If you have multiple parallel flows then you will have multiple entries in that table for the same process instance.  And when the flows join, the entries will also be reduced.

[ambikakhatri]

Thanks so much Hari for immediate reply. First task is a plain Java service task. Any idea how is it making to this table? There is no entry for any other task in this table. How do I get currently executing tasks from db?

Thanks in advance!
Ambika

[hari]

Hi Ambika,

Can you please post your bpmn here ? Also please tell us which version of Activiti you are using.

[ambikakhatri]

I am using 5.19. Attached is process bpmn file.

Thanks,
Ambika

[jbarrez]

You only have one user task in your process … the rest are automatic steps and don't need persisting in the db. What exactly are you expecting?