Skip to content

Life Sciences

Replacing an EMS: migrate the data before the old system goes

  • Life Sciences
  • 1 min read

A year after the old EMS was switched off, an inspector asks for the temperature trend behind a batch and nobody can open the file.

Replacing a monitoring system is also a data migration. The sequence that keeps the records usable:

  1. List what the old system holds and how long each record has to be kept: values, alarms, the audit trail.
  2. Specify what moves and in what form: values with time stamps and units, alarm events, the audit trail, metadata such as tag and range. Write down what will not move and how it stays readable.
  3. Run a trial migration and verify it: record counts per tag and month, and sampled values compared between old and new.
  4. Migrate under change control, with the old system set to read-only first.
  5. Keep the old data, and a way to read it, until the verification report is signed.

The 2011 text of EU GMP Annex 11 (clause 4.8) says that when data are transferred to another format or system, validation should include checks that data are not altered in value and/or meaning. "Meaning" is where migrations go wrong: a temperature that lost its unit, or a time stamp that moved seven hours because the old system stored Viet Nam local time and the new one UTC.

PIC/S PI 041-1 adds that migration should follow documented protocols and include verification that it is complete.

Ask for the old system's export format before the purchase order for the new one is signed.

Industries

Related

More on this subject

GMP on the electrical side

Where a SCADA, BMS or EMS records GMP-relevant data, access control, clock synchronization, alarm records and audit trails are decided by the electrical and automation engineers. Many sites keep those parameters on a separate validated EMS. Humiley's cross-functional training covers GMP, validation and project management.

InsightRead

Metadata: what a stored value needs to mean anything

A stored value of 22.4 means nothing without its sensor tag, unit, time stamp, status flag, author and audit trail. The MHRA's 2018 data integrity guidance defines metadata as data that describe the attributes of other data and provide context and meaning. Test that backups, exports and migrations carry them.

InsightRead

Part 11 starts with the predicate rule

Part 11 applies to electronic records that a predicate rule such as 21 CFR 211 requires. For a BMS or EMS, name the rule behind each point: GMP-critical monitoring usually belongs in a validated EMS. For EU export, Annex 11 has no predicate-rule test, so the BMS still needs a risk assessment.

InsightRead