Records in and records out do not match

Edit online

If the number of records out is less than the number of records in, check connector behavior and missing account or location information.

Problem

The Records In count is higher than the Records Out count:
Records In
The number of valid rows in the file that are loaded for processing. The number excludes rows to be skipped, rows that do not conform to the specification, the column header row, or empty rows.
Records Out
The number of new records that are loaded into the system.

Cause

Possible causes include a multi-read connector that combines several rows into one record, missing location information, missing account information, or an update operation that creates zero new records.

Generally, the number of records in is the same as the number of records out. For example, if your file contains 10 electricity bills, 10 records are loaded. However, sometimes records out is less than records in, possibly because of one of the following reasons:
  • A multi-read connector is used, which means several rows of records are combined into one record and then loaded.
  • The connector is unable to find the location information for a record in the file.
  • The connector is unable to find the account information for a record in the file.
  • For system configuration, an update operation is performed rather than a create operation, which means that zero new records are added.

Solution

Verify connector behavior and file content:
  1. Confirm which connector processed the file and whether it aggregates rows.
  2. Check that each record includes valid location information.
  3. Check that each record includes valid account information.
  4. For system configuration, check whether an operation updated existing records rather than creating records.