RVR-BQ-RDBMS-003

Issue summary

• The error code RVR-BQ-RDBMS-003 with the description FAILED_TO_EXECUTE relates to a failure in executing a Data Flow operation with a BigQuery data source in Data Integration. This can commonly be due to configuration issues, connectivity problems, or internal errors during execution.

Action steps

To resolve the error, follow these steps:

• Check Connection: Verify that the connection settings to BigQuery are correct. This includes checking the authentication credentials and ensuring all required permissions are properly set. Double-check the dataset IDs and table names used in the configuration.
• Review Execution Logs: Go through the logs available in Data Integration for the specific Data Flow that is failing. The logs might provide a more detailed error message that can direct you to the source of the problem.
• Validate Permissions: Ensure that the Google Cloud project associated with the BigQuery dataset has granted all necessary permissions to the Data Integration service account.
• Test BigQuery Configuration Independently: Run a simple query or data operation directly in the BigQuery console to ensure that the dataset and table are accessible and operational.
• Reinitialize or Redefine Data Flow Logic: If configuration settings recently changed, such as schema changes in the source dataset, you may need to modify your Data Flow's schema settings or reinitialize it to accommodate these changes.

External references

• Data Integration BigQuery Connection Setup: Data Integration Documentation - For verifying connection parameters and setup instructions.
• Google BigQuery Documentation: BigQuery Documentation - For permissions and dataset setup instructions.

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.