Ingestion error: value too long

An ingestion failed with the following error message appearing in the log file:

PG::StringDataRightTruncation: ERROR: value too long for type character varying(128)

Explanation:

A value exceeded the character limit for a given field.

Solution:

Check the values in the ingested file. The error is often associated with a field that has multiple value. The values must be separated with a semi-colon not a comma or other character.