ERRORGTFS Schedule notice

A record refers to an ID that does not exist

foreign_key_violation
Severity
ERROR
Files to check
See report
Report fields
6
Documentation
Curated

Diagnosis

What this notice means

The value in childFieldName cannot be found in the referenced file and field named by the report.

Operational effect

Why it matters

An app may reject or omit the affected stop, trip, route, or other record.

Scope

Files to check and report fields

Use the file or input resource identified in the report. Check the message and available context fields; runtime failures may not identify a GTFS row.

Report fieldTypeMeaning
childFieldNamestringThe name of the field that makes reference.
childFilenamestringThe name of the file from which reference is made.
csvRowNumberintegerThe row of the faulty record.
fieldValuestringThe faulty record's value.
parentFieldNamestringThe name of the field that is referred to.
parentFilenamestringThe name of the file that is referred to.

Repair

How to fix it

  1. 1

    Open childFilename at csvRowNumber, then search for the exact fieldValue in parentFilename and parentFieldName.

  2. 2

    Correct a mistyped reference, restore the real missing record, or remove an obsolete record and its dependencies. Check case and whitespace. For service IDs, consider both calendar files; never invent a placeholder stop or service.

  3. 3
    Check the result

    After a repair, rebuild the archive and validate it again. Confirm that the affected records are correct and that no new related notices appeared. A reviewed warning or informational notice may remain when it describes intentional, supported data.

Re-check your feed in the browserFree, no upload for a file you pick.

Worked example

Example correction

Assume the source timetable confirms that this trip serves STOP_41. These are field-level excerpts, not a complete feed.

Before

stops.stop_id: STOP_41
stop_times.stop_id: STOP_42

After

stops.stop_id: STOP_41
stop_times.stop_id: STOP_41

Illustrative excerpt, not a complete GTFS feed. Keep all other required records and fields.

Sources

References