Boomi · Data Integration: Amazon Redshift

RVR-RDS-100: inconsistent data length (Redshift)

Short answer

RVR-RDS-100, inconsistent data length, means the data being loaded does not fit the Redshift table's column types or lengths. Align the source with the target schema, or use the Truncate Columns option.

VerifiedLast verified

01Error text

Boomi error
Inconsistent data length. Error Code: RVR-RDS-100

02Likely causes

  • Data types or field lengths in the source do not match the target columns.
  • The source changed and the table does not reflect it.

03How to fix it

  1. Confirm source fields match the target table's data types and lengths.
  2. Confirm the Redshift table schema matches the incoming data.
  3. Consider Truncate Columns under Advanced Options in the Target tab when a string or array exceeds the column length.
  4. Handle data type conversions in the mapping.

04Official documentation

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

More for Boomi work:Open Boomi jobsBoomi 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.