We have become aware of a problem that occurs only in specific circumstances relating to merged records.
This is fixed from Mosaic 22.2.4.1, 22.2.5.0 and 24.1.0.0.
A diagnostic script (unmerged_subject_answers_ss.sql and unmerged_subject_answers_ora.sql) is available, this should be run at the time of the upgrade and a new case raised if any results are returned, we'll then provide a data fix script to correct any historical records.
The issue:
Only affects merged records.
Affect multi-subject's tables, find party tables, and find party subsections.
Only affects records where the source record was recorded within the above sections, either as a subject or a party.
Does not delete or lose the data, it is still in the database, it is just not visible in the front-end form.
To replicate:
Setup
Create or identify a group form containing a multi-subjects table, find party table and find party subsection (Form X).
Add a text field in to the multi-subjects table with no URI/pre-pop.
Add a name field in to the find party table with a URI (nameAndAddress) - plus another field, such as a text field, with no URI.
Add a find party subsection with a URI (nameAndAddress).
For ease, you can make available outside of workflow.
Create Person 1 and Person 2 (who will later be merged with Person 1) and Person 3 (separate person).
Create Group K containing Person 1 and Person 3.
Test
Add Form X for Person 1 and Person 3 in Group K
Multisubjects table
Add a row for Person 1 with text.
Add a row for Person 3 with text.
Add a row for Persons 1 and 3 together with text.
Find party table.
Add a row for person 1 with text.
Find party subsection
Add Person 1.
Save or complete the form.
Merge
Go to the record of Person 1.
Go to file management - Merge and Delete.
Find Person 2 as the target person.
Ensure Merge job is performed and Persons 1 and 2 are merged into Person 2's record.
Result
Go back to Group K and view the completed Form.
Multisubjects table.
Row for person 1 will be missing subject but retain text.
Row for person 3 will remain completed.
Row for persons 1 and 3 will appear as if completed for Person 3 only.
Find the party table.
Row will appear with text but without a party.
Find party subsection.
No party will show as selected.
As stated above, the information is not lost, it is retained in the database and can be retrieved. We are currently working on establishing the best solution to this issue, both for existing cases and to prevent it happening in the future. We will update the linked knowledge article as soon as we have any further update.
We recommend that you review the likelihood of you having this issue, given the specific circumstances detailed above, as it is likely it will not affect all customers.
Where you do identify this as a potential issue, we recommend that you advise workers of the possibility of this missing information, the form sections it may be missing from and raise a support case where you require an urgent fix for this, where it is affecting a live case. Otherwise please keep an eye on this article for further updates, which we will provide as soon as possible.