RVR-RDS-100

1. Issue Summary

   • The error "Inconsistent data length Error Code: RVR-RDS-100" typically occurs when there is a mismatch in the data structure being loaded into Amazon Redshift. This can happen if the data types or lengths 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.

2. Action Steps:

   • 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.
   • Schema Check: 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.
   • Truncate Columns Option: Consider using the "Truncate Columns" option in Rivery, 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.
   • Conversion and Mapping: Ensure all necessary data type conversions have been handled appropriately in the data mapping phase. Adjust the mapping settings if needed.

3. External References:

   • For more information on handling Redshift integrations and setting up columns appropriately in Rivery, you can refer to Rivery's documentation on configuring Amazon Redshift as a Target here.
   • Additional insights on Redshift data type and length management can be found in Amazon's Redshift documentation at AWS Redshift.

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