topic Re: Incorrect data in ACT_RU_execution table in Alfresco Archive

Incorrect data in ACT_RU_execution table

ambikakhatri — Thu, 05 May 2016 09:46:15 GMT

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. Th

Re: Incorrect data in ACT_RU_execution table

hari — Thu, 05 May 2016 10:30:40 GMT

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.

Re: Incorrect data in ACT_RU_execution table

ambikakhatri — Thu, 05 May 2016 10:38:34 GMT

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

Re: Incorrect data in ACT_RU_execution table

hari — Thu, 05 May 2016 12:55:36 GMT

Hi Ambika,

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

Re: Incorrect data in ACT_RU_execution table

ambikakhatri — Thu, 05 May 2016 14:52:35 GMT

I am using 5.19. Attached is process bpmn file.

Thanks,
Ambika

Re: Incorrect data in ACT_RU_execution table

jbarrez — Tue, 10 May 2016 10:05:31 GMT

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?