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
Inconsistent data length. Error Code: RVR-RDS-10002Likely 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
- Confirm source fields match the target table's data types and lengths.
- Confirm the Redshift table schema matches the incoming data.
- Consider Truncate Columns under Advanced Options in the Target tab when a string or array exceeds the column length.
- Handle data type conversions in the mapping.
04Official documentation
→Related errors
- RVR-LTBQ-100: failure loading data into BigQueryRVR-LTBQ-100 means loading data into BigQuery failed. The documented causes are data type mismatches, a region difference between the bucket and the dataset, or missing service account permissions.
- RVR-LTBQ-102: keys not selected in mapping for mergeRVR-LTBQ-102 means no key fields are selected in the column mapping, and the upsert-merge mode needs keys to match records. Select the key fields in Column Mapping and save.
- RVR-IPAL-001: IP address allowlist check failedRVR-IPAL-001 means the connecting IP addresses are not in the allowlist of the service you are connecting to. Add the Data Integration IP addresses to that service's inbound rules.
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