This is likely to only occur for customers who have converted from Frameworki (legacy system prior to Mosaic). In Frameworki a responsible worker and manager were recorded against a child protection episode and when performing an enquiry, the worker and manager would be returned as part of that. This can also cause an error when attempting to view child protection history on a record.
This error occurs in a specific scenario where the responsible worker or manager was changed on the same day as the Child Protection plan ended. Mosaic is looking for the most recent responsible worker and manager and the error occurs as it is finding two workers and two managers, as the end date for the previous relationships and the start date for the new relationships is the same - and is the same as the last day of the CP plan. It is only expecting to find one.
We have a fix that we can do that will amend the worker relationship so that:
The worker relationship that was ended on the CP Plan end date retains that as their end date, as it is likely they were the CP worker responsible
The worker relationship that was started on the CP Plan end date has the relationship has the start date amended to the day after the CP Plan ended.
You will need to confirm that you are happy with this data amendment as it is amending the child's record. If you're happy, please raise a new case online and reference the title of this article.
Error appears in the error logs
If you're viewing the error logs, this error shows like the below:
'An error was encountered while attempting to retrieve CP plan history. : EJB Exception: ; nested exception is:
uk.co.corelogic.common.exception.DAOException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
uk.co.corelogic.common.exception.FrameworkException: An error was encountered while attempting to retrieve CP plan history. : EJB Exception: ; nested exception is:
uk.co.corelogic.common.exception.DAOException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.'