Public Health England loses ~16,000 COVID-19 cases via Excel error
Roughly 16,000 positive COVID-19 test results were dropped from England's contact-tracing system for several days, delaying isolation notices to an estimated tens of thousands of contacts.
The damage was public. The root cause was preventable.
Roughly 16,000 positive COVID-19 test results were dropped from England's contact-tracing system for several days, delaying isolation notices to an estimated tens of thousands of contacts.
What the software actually got wrong
Lab result files were compiled into older Excel (.XLS) template files limited to about 65,000 rows; as case counts grew, additional rows silently fell off the bottom of the spreadsheet and were never loaded into the tracing system.
Lab result files were compiled into older Excel (.XLS)...
Lab result files were compiled into older Excel (.XLS) template files limited to about 65,000 rows
Requs AI Edge Case flags this exact pattern at the requirements and architecture stage — before a single line of code implementing it exists — so the assumption behind it gets challenged while it is still cheap to fix.
As case counts grew, additional rows silently fell off...
as case counts grew, additional rows silently fell off the bottom of the spreadsheet and were never loaded into the tracing system
Requs AI Software FMEA traces this failure mode back to the system-level hazard it feeds, tagging it against the Common Defect Enumeration so it surfaces in review instead of in the field.
Beyond code coverage and "shall" testing
Root causes like this one rarely show up in code coverage or requirements-compliance testing, because nobody wrote a requirement anticipating the specific edge case that broke. Requs AI Edge Case and Requs AI Software FMEA are built to surface exactly this class of overlooked failure mode — before the software is written.
Surfaces this before code exists
Identifies edge cases like this one at requirements and architecture time, using the Common Defect Enumeration to catalog failure patterns seen across hundreds of real-world software failures — including this one.
Connects the failure mode to the hazard
Traces this class of root cause directly to the system-level hazard it can produce, so a defect pattern like this one gets flagged during design review instead of after it ships.
Find the overlooked root causes before they ship.
Schedule a demonstration, or explore how Requs AI Edge Case and Software FMEA use the Common Defect Enumeration.