The issue is related to the process dependencies resolution. It is executed every time the engine is paused and then resumed. The big number of processes (mote than 150 in my case) is causing trasaction timeout, because dependencies resolution is executed for all the process in one transaction. The default transaction time limit is set to 60 seconds and can be increased. However it can be increased only globally and that can be bad for stability and performance. Do you think it is reasonable to break this single transaction to separate transactions for every process and resuming tenat as well?
You can workaround this problem by setting timeout to higher value. After resuming tenant it can be decreased. However it requires server restarts.
Sorry for the late answer. I got some clarification from our R&D team and actually prior to version 7.9.0 loading of process dependencies was done in one single operation when starting or resuming Bonita Engine. That was causing issue as you described. But since 7.9.0 the process dependencies are loaded only on the first access of each individual process definition. This new behavior should prevent performance issue as you report in this issue.
I’m confused about the affected versions you set fort this issue. Can you confirmed that you still face this issue on 7.9.4?
Sorry, I must have missed your answer.
The issue originally have occured on 7.9 version of production environment. I have also reproduced it locally on 7.5.4, that is why I set both versions in the current ticket.
I believe you meant 7.10 is the version in which it was fixed. I didn’t verified it yet, but I see changes in the engine’s code which affect dependencies resolving.
Actually you are right the last update regarding this issue is available since 7.10.0 ( )
So I recommend to update to 7.10.0 to fix this issue.
Is it possible for you to do this upgrade?
I was reviewing issues and I see this one is still waiting for your confirmation; have you finally udgraded to 7.10 ?
The project with this issue was not developed for a while and there was no urgency for upgrade. If it is already solved, you can close this ticket.