RVR-BQ-RDBMS-004

1. Issue Summary

   • The error code RVR-BQ-RDBMS-004 with the message DB_ERROR through the bq_src connector typically indicates a database-related issue in Data Integration, specifically when using BigQuery as a source. This error can occur due to several reasons such as connection issues, missing permissions, or misconfigurations in the BigQuery settings.

2. Action Steps:

   • Check Connection Details:

     • Verify the credentials used in the BigQuery connection. Ensure that the project ID, service account credentials, and any required permissions (such as BigQuery Data Viewer and BigQuery Job User roles) are correctly assigned.

   • Review Permissions:

     • Ensure that your Google Cloud service account has the necessary permissions to access the datasets and manage stored data. The service account should have the "storage.buckets.list" permission linked to a role.

   • Check for Regional Compatibility:

     • Confirm that the region of the datasets and the connection match. Misalignment in regions can cause data load failures.

   • Test the Connection:

     • Use the "Test Connection" feature in Data Integration to ensure that the connection to BigQuery is working as expected.

   • Examine Logs for Details:

     • Review any relevant logs in the BigQuery and Data Integration consoles for more detailed error messages which might provide additional insights into the cause of the DB_ERROR.

3. External References:

   • For more detailed steps on setting up a BigQuery source in Data Integration, refer to the Data Integration BigQuery documentation.
   • Consult the Google Cloud service account and permission documentation for setting correct access roles in BigQuery.

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