RVR-SF-RDBMS-310

1. Issue Summary

   • The error code RVR-SF-RDBMS-310 with the description "Column name not found in column description" typically indicates that there is a mismatch between the column names expected by the Rivery pipeline and the actual column names in the source or target database schema. This often occurs due to schema changes, such as renaming columns, dropping columns, or incorrect mappings during the configuration of data ingestion.

2. Action Steps:

   • Verify Column Names: Ensure that the column names used in the Rivery configuration match exactly with the ones in your database schema. Check for differences in case sensitivity, spelling, or unexpected characters.
   • Update Schema in Rivery: If there have been recent changes in the database schema (e.g., columns added, removed, or renamed), resync the schema in Rivery. This can be done by accessing the Rivery platform and updating the target schema mapping, which should detect and adapt to any changes.
   • Check Auto Mapping Settings: If using auto mapping, confirm that all columns are being correctly identified and mapped. You may need to manually adjust the mapping if any columns are missing or incorrectly aligned.
   • Consult Connection Settings: Review the connection settings for your RDBMS source to ensure that there is no misconfiguration that could prevent Rivery from reading the schema properly.

3. External References:

   • Rivery Documentation: Schema Configuration for adjusting your column mappings and ensuring correct data ingestion.
   • General SQL Guidelines: Check your database's documentation for SQL naming conventions to ensure compatibility with Rivery.

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