Jitterbit · Database Insert, Update and Upsert activities

Field value too long / values were truncated

Short answer

This Jitterbit database error means a mapped source value is longer than the target column, and by default the value is rejected. In the activity configuration, enable Allow truncation of character fields.

VerifiedLast verified

01Error text

Jitterbit error
One or more values were truncated when inserting and/or updating the field
Field value too long

02Likely causes

  • A mapped source value is longer than the target column. By default the value is rejected and the activity reports an Error status.

03How to fix it

  1. In the activity configuration, enable Allow truncation of character fields.
  2. Or trim or transform the source field in the mapping so values never exceed the column length.
  3. Or widen the target column on the database side.
  4. Redeploy and rerun the operation.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.