Time out exception
To solve this issue you might want first try to update to Bonita 7.8.0 as some improvement has been done on performance of deletion of archived cases (see changelog).
Also I guess that QueryTimeoutException actually refer to an SQL query that taking to long to run based on the settings of the database. So increasing the timeout in the database configuration might fix this issue. In order to make sure this timeout is related to the database can you share with me the full Bonita Engine log file using for example Google Drive, Dropbox...
Thanks a lot for your response, we have a heavy log file so it was dificult for me to share the full log, instead Ill share a fragment with the sql QueryTimeoutException that I mentioned.
The improvement made to case deletion apply to open cases too?
After reading the changelog it says that some events are not triggered anymore "ARCHIVED_FLOWNODE_INSTANCE_DELETED" does that mean that it will not delete the records of the table arch_flownode_instance anymore? because we are trying to reduce the size of that table.
And again, thanks a lot for your time Antoine,