Error log:
'Error updating database. Cause: java.sql.SQLException: Cancel has been invoked on this Statement.'
'The error may involve Group.createSubGroup-Inline'
'The error occurred while setting parameters'
'SQL: {call mosaic_groups.use_subgroup( ?, ?, ?)}'
'Cause: java.sql.SQLException: Cancel has been invoked on this Statement.'
Mosaic uses a group named Task_Recipients_Config to configure recipients of requests in workflow steps.
Every time you add a new worker or organisation as a configured recipient of a request, it creates a new subgroup within this group. This could lead to a large increase in the number of subgroup subjects configured in this group.
We’ve produced a script to clean up unused ‘Task Recipient’ subgroups, and it’ll run as part of the upgrade from Mosaic 22.2.0.0.
If you experience this issue in earlier Mosaic versions please raise a new case on the customer success portal and reference the title of this article.