topic Re: Update done by one task into DB is not getting reflected by second task when multiple tasks are triggered at once in Alfresco Archive

Update done by one task into DB is not getting reflected by second task when multiple tasks are triggered at once

tkarthik26 — Wed, 18 May 2016 13:39:54 GMT

Hi,I am claiming two different tasks in UI and when submitting it, it is entering a service task. Below are the sequence of actions taking place.Task1: 1. Enters the service task 2. Fetches count of records matching some condition from DB 3. Performs some logic 4. Updates the count to DB at the end

Re: Update done by one task into DB is not getting reflected by second task when multiple tasks are triggered at once

jbarrez — Wed, 18 May 2016 17:00:18 GMT

Make the task async, and the transaction will be committed to the database, thus giving you the latest values in the next talk.

Re: Update done by one task into DB is not getting reflected by second task when multiple tasks are triggered at once

swamy2156 — Thu, 19 May 2016 14:07:51 GMT

I too face the similar problem!!
1. I have a workflow as follows. START->TASK->SERVICETASK->END
2. I have a counter(incremented based on history variables of completed instances + current execution data).
3. From My UI, I selected 2 tasks and completed them simultaneously in multi-threaded environment. 2 tasks completed concurrently in 2 seperate threads and both executions sits in ServiceTask. TASK1 counter variable calculated correctly. But, TASK2 counter not considering TASK1 refreshed db data from database.
Is there a way to solve this concurrency problem?

thanks,
Swamy.

Re: Update done by one task into DB is not getting reflected by second task when multiple tasks are triggered at once

jbarrez — Tue, 31 May 2016 08:23:20 GMT

I'm not sure I'm following this? How does these two threads relate to one process instance? They both complete the task? (which should not be possible)