Error:
"### Error querying database. Cause: uk.co.corelogic.mosaic.domain.group.exception.TooManySubjectsException
### Cause: uk.co.corelogic.mosaic.domain.group.exception.TooManySubjectsException'
Further down in the stack trace there will also be this line of logging:
'uk.co.corelogic.mosaic.repository.workflow.StepRepository.retrieveOptionalCopyForwardTemplateDetails'
This happens when starting a group step after amending next action subjects to add recipients in a previous workstep.
Steps to replicate
Create a group containing Person A and Person B
Start an initiating, group-enabled workstep on Person A from the individual summary, not the group.
Add a group-enabled next action for Person A.
Save and close the workstep.
Resume the workstep and add Person B to the workstep, using the existing group.
Complete any mandatory fields on the form.
Go to Next actions section and click the pencil to edit the next action you had previously added.
Select Person B to add them to this action and save and close.
Finish (‘green tick’) the workstep.
Attempt to start the next action, you will get an error.
This is a bug that occurs in very specific scenarios, but there is an easy workaround.
Training to avoid the problem occurring
Training: users should ensure that in the scenario where they need to add a subject to a next action, instead of editing the next action with the pencil, they should remove it with the bin icon. They should then add the next action again for all the relevant subjects.
Resolving existing issues
Where this error occurs, the previous workstep should be re-opened by a system administrator and the next action recalled. The next action should then be added again afresh with all relevant subjects. It should then start without any errors.
Child protection worksteps
As child protection worksteps cannot be re-opened, you would need to follow the procedure for data changes in Child Protection worksteps and ensure the next actions are added correctly for the subjects when re-completing the workstep.
If you have a scenario not as described, please raise a new case online and reference the title of this article.