How To Fix 5G220 - Record already exists in the table NI Data Take-on (T5G_DTONI)

5G220 - Overview

• Message type: E = Error

• Message class: 5G - HR: Messages for Britain

• Message number: 220

• Message text: Record already exists in the table NI Data Take-on (T5G_DTONI)

What causes this issue?

An entry from the old <LS>National Insurance Data Take-on</> table
(T5G_NIDTO) cannot be migrated to the new <LS>National Insurance Data
Take-on </>table (T5G_DTONI), as an entry with the same key already
exists in the new table.

System Response

The system rejects this entry.

How to fix this error?

Check why the entry exists in both tables and make the correction in
the appropriate table.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

5G220 - Details

• The SAP error message 5G220, which states "Record already exists in the table NI Data Take-on (T5G_DTONI)," typically occurs during the data take-on process in the SAP system, particularly when dealing with the NI (National Insurance) data for employees. This error indicates that there is an attempt to insert a record into the T5G_DTONI table that already exists, which violates the uniqueness constraint of the table.
  
  Cause:
  
  Duplicate Entry: The most common cause of this error is that the record you are trying to insert already exists in the T5G_DTONI table. This could happen if the data was previously uploaded or entered manually.
  Incorrect Data Load: If you are using a data upload tool or program, it may be configured incorrectly, leading to duplicate entries being attempted.
  Data Migration Issues: During data migration from another system, if the same records are being migrated multiple times, this error can occur.
  
  
  Solution:
  
  Check Existing Records: Before attempting to