RVR-RDS-100

Issue summary

The error "Inconsistent data length with error code RVR-RDS-100 occurs when there is a mismatch in the data structure loaded into Amazon Redshift. This indicates that the data types or length of fields in the source data do not match the corresponding columns in the Redshift table. This inconsistency can result from changes in the source data that have not been reflected in the Redshift table or schema mismatches when integrating different data sources.

Action steps

1. Validate data source: Ensure that the data fields in the source exactly match the target table's schema in terms of data types and lengths. You might need to inspect the source data or the transformation logic to identify discrepancies.
2. Check Schema: Double-check the schema of the target Redshift table to ensure it matches the expected structure of the incoming data. Look for any modifications in data lengths or types between the source and the target.
3. Truncate columns option: Consider using the "Truncate Columns" option in Data Integration, which is found under Advanced Options in the Target tab. This option can help when the length of an array or string exceeds the defined length in Redshift.
4. Conversion and mapping: Ensure all necessary data type conversions have been handled appropriately in the data mapping phase. Adjust the mapping settings if needed.

External references

• For more information on handling Redshift integrations and setting up columns appropriately in Data Integration, refer to Configuring Amazon Redshift as a Target topic.
• For additional insights on Redshift data type and length management, refer to AWS Redshift topic.

note

If the issue persists or you need further assistance, open a ticket with Data Integration support.