Skip to main content
Feedback

RVR-BQ-RDBMS-011

  1. Issue Summary

    • The error FAILED_TO_GET_COLUMN_MAPPING with code RVR-BQ-RDBMS-011 occurs when working with the BigQuery data connector in Data Integration. This error typically indicates an issue with the automatic or manual column mapping between source and target within Data Integration. An initial diagnosis suggests that this may be due to a mismatch in data types or an incomplete column mapping configuration.

  2. Action Steps:

    • Verify Data Source and Target Structure: Check to ensure that the schema of the data source matches the mapping settings in Data Integration. This includes verifying data types and column names in both the source and target configurations.

    • Automatic Mapping: Utilize Data Integration Auto Mapping feature, which automatically determines your table/query metadata and maps the columns from the source to the target.

    • Manual Adjustments: If automatic mapping does not resolve the issue, manually adjust the mapping settings. Make sure that all required columns are defined and properly mapped without conflicts or missing attributes.

    • Check Data Type Compatibility: Ensure that the data types in both source and target systems are compatible. If there are specific data types that might cause conflicts, consider casting them to a compatible type before performing the data load.

    • Review Data Integration Logs: Examine logs in the Data Integration platform to identify any additional errors or warnings that might shed light on the mapping failure.

  3. External References:

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