Skip to main content
Feedback

RVR-BQ-RDBMS-011

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.

Action steps

To resolve the error, follow these 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: Use Data Integration Auto Mapping feature, which automatically determines your table/query metadata and maps the columns from the source to the target.

  • Manual Corrections: If automatic mapping does not resolve the issue, manually adjust the mapping settings. Make sure that all required columns you define 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.

External references

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.

On this Page