DPL-048-2: malformed root_sample_ids without duplicates in MLWH, unpicked

[Jonnie-Bevan]

User story
Part of the wider DPL-048-1 issue which spawned in turn from DPL-048. Related are DPL-0483-3, DPL-0483-4 and DPL-0483-5.

This story concerns the 4,699 malformed root_sample_ids in the MLWH lighthouse_sample table. These came from the MK lighthouse lab in August 2021 and have an extra substring (something like '_RNA123456789') concatenated on the end of the correct ID.

Fix
Since these samples were never picked they are not in SequenceScape, Event Warehouse or the MLWH sample table, so the only places that these need to be fixed are in the MongoDB sample table and MLWH lighthouse_sample table.

These can be fixed by using a script to correct the ID (remove everything after underscore) and then updating the relevant row with the correct ID.

Who are the primary contacts for this story
Jonnie B
Alan K

Acceptance criteria

• data are fixed in MLWH lighthouse_sample table
• data are fixed in MongoDB sample table
• have double-checked that this data does not exist in SS/Ev. Warehouse/MLWH Sample table.

[KatyTaylor]

Closing, as is in Done column.