PAT-239 · Pattern

When Poor Data Quality Becomes an Automation Failure

Automation does not remove uncertainty from bad inputs. It often makes the hidden corrections people were performing manually impossible to ignore.

Mellorca Patterns·Data Quality, Ownership & Governance·7 September 2026

Observable condition

An automated process works for some records but stops on others. Required fields are blank, customer names differ between systems, statuses mean different things to different teams, or a person still has to inspect the data before the next step can safely run.

Realisation

People often compensate for weak data without recording the effort. They recognise a customer despite a naming difference, infer a missing category, phone someone to confirm a field or know which value should be ignored. Automation removes that invisible interpretation layer. The resulting failures can therefore reveal a data problem that already existed.

Identification

This is an operational-data-quality and automation-readiness problem.

Diagnosis

The mechanism usually includes unclear data ownership, weak validation at capture, duplicated records, inconsistent definitions or systems that allow the same business fact to be maintained independently. Automation then receives inputs that are structurally ambiguous. Adding more workflow logic can create a growing catalogue of exceptions without fixing the source.

Commercial impact

The value wrapper is reliability, capacity, decision quality and scalability. Failed runs create rework and monitoring demand. Teams lose confidence and keep manual controls beside the automation. Scaling the workflow increases the number of records exposed to the same input problem.

Common misidentification

The symptom is frequently labelled an automation bug. Some failures are technical, but repeated failures tied to particular records, fields or definitions deserve a data diagnosis before the automation is rebuilt.

Possibility

A stronger model treats critical data fields as operational infrastructure. Ownership is explicit, required values are validated close to capture, definitions are shared and exceptions are observable. Automation then operates on a narrower, more reliable contract instead of compensating for every historical inconsistency.

Intervention

Take a sample of recent failed or manually corrected workflow cases. Identify the exact fields or definitions that caused intervention. Trace where each value originates, who owns it and where it can change. Fix the highest-impact capture or ownership failure first, then rerun the same cases to determine whether workflow reliability improves.

Practical diagnostic questions

  • Which fields cause the most automation exceptions?
  • Who is accountable for the correctness of those fields?
  • Can the same business fact be edited independently in multiple systems?
  • What data corrections do experienced staff make without documenting them?
  • Are new automation rules treating symptoms that should be fixed at capture?

Bottom line

When automation repeatedly needs humans to repair its inputs, the constraint may be the data contract underneath the workflow.

Article summaryAutomation often exposes data-quality work that people were quietly performing by hand. Strengthening ownership, definitions and validation at the source can make automation more reliable without turning every bad input into another technical workaround.