We are encountering an issue on getting the task availa ble of certaing group. I

@rishub356 Could you please throw some more light into the problem description by answering the following questions?

1. Are you using SAIL interface?
2. How are you making the query to check the next unassigned task?
3. How are you assigning the next task?

We are using Action for that. We are using query actibeve tasks. We assigne thiat task to te person & update DB. This is a race condition issue.

@rishub356 One more question please - Is the query made from database?

Here goes one of the possible ways to overcome race condition if you are making a query on database:

To the best of my knowledge, if you do as follows, the race condition can be eliminated:

Instead of depending on database for checking the task status, depend on any one of the following options in order to check the status of the task:
1. getportalreportdatasubset (plugin)
2. queryProcessAnalytics function (OOTB)
3. Execute portal report OOTB smart service (OOTB)

Opting for any one of the options will get you the most recent data. For example, let's assume that a task is assigned to user. At the same time when some other user tries to get the same task and if you query the status of the task using process analytics data, within fraction of seconds you can get the updated data. (Where as in case of DB, you could observe some lag time between capturing the status, updating the same in database and querying the status in parallel in case of other users, which thereby leads to race condition.) Perform the database updates still if desired, but I would like to suggest to depend on process analytics for calculating the task availability.

Please do let me know if you have any follow up questions.

Thanks Sikhivahans. I am going for this approach today & will keep you updated on this thread.

Great!! Any question is welcome.