We are using jbpm4.4 with DB2 as database. When there are large number of opentasks for a group, then a call to taskService.findGroupTasks fails.
The DB2 SQL code is 54001 which says the query is too long or complex.
Upon further investigation, we found that the api call is translation into a sql query that has in clause. If we reduce the number of tasks, the methods runs fine.
I am wondering if there is any alternate implementation method or combination of methods that uses a join between participations and tasks rather than using a in clause ?
Appreciate if anyone who faced similar problems and solved/worked around this can share their experience.
Retrieving data ...