RVR-SF-RDBMS-310

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 Data Integration 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.

Action steps

To resolve the error, follow these steps:

• Verify Column Names: Ensure that the column names used in the Data Integration configuration match exactly with the ones in your database schema. Check for differences in case sensitivity, spelling, or unexpected characters.
• Update Schema in Data Integration: If there have been recent changes in the database schema (e.g., columns added, removed, or renamed), resync the schema in Data Integration. This you can do this by accessing the Data Integration 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 Data Integration from reading the schema properly.

External references

• Data Integration 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 Data Integration.

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.