Skip to main content
Feedback

RVR-BQ-RDBMS-009

Issue summary

The error code RVR-BQ-RDBMS-009 with the description BUCKET_LOCATION_MISMATCH in the context of the Data Connector bq_src typically indicates a mismatch between the location (region) of a Google Cloud Storage bucket and the BigQuery dataset. This mismatch occurs when the regional settings for either the bucket or the dataset do not match, causing a failure in data transfer between them.

Action steps

To resolve the error, follow these steps:

  1. Verify Locations:
  • Check the region specifications for your Google Cloud Storage bucket and ensure it matches the region of the BigQuery dataset.
  • You can find the region of your bucket in the Google Cloud Console under the Cloud Storage section.
  • Similarly, verify your BigQuery dataset's region in the BigQuery Console.
  1. Update Settings if Necessary:
  • If there is a mismatch, update either the bucket to match the dataset's region or the dataset to match the bucket's region. This may involve creating a new bucket or dataset in the correct region.
  • Modify your Data Integration connection configuration to reflect these changes.
  1. Test Configuration:
  • After ensuring the region match, test the connection in Data Integration to ensure the error you resolve.

External references

For more information on storage bucket locations and how to set them, you can refer to the Google Cloud official documentation: Google Cloud Storage Locations.

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