Roifile

Error codes ยท EBA technical checks (reception)

805: For open tables, the key columns values cannot be empty

Rejects the file also shown as EBA.805

Official text

For open tables, the key columns values cannot be empty

How it appears in feedback

What triggers it

A primary-key column is blank in some row (e.g. b_01.01 c0010, b_01.02 c0010/c0060, b_04.01 c0040, b_02.02 c0130/c0150/c0160). Rows without keys cannot be stored, the table is not integrated, and dependent tables then fail with 807.

A key column is empty in some row. Keys are the identifiers that other tables point at: LEI in B_01.02, contract reference in B_02.01, provider identifier in B_05.01, function identifier plus LEI in B_06.01, and so on.

Templates: all open tables. Columns: key columns per Data Model for DORA RoI

How to fix it

Fill every key column. Where a value is genuinely unknown use the DPM 'not applicable' code (e.g. eba_GA:qx2007 for the B_02.02 country keys) or, for a third-country provider without LEI, any relevant identifier (FAQ 40) rather than blank.

Fill the key. For a third-country provider without an LEI, the ESAs say to use another identifier rather than leave it empty: an empty key rejects the whole file.

Sources

Check a file for this