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:

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