RVR-BQ-RDBMS-004

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 configuration issues in the BigQuery settings.

Action steps

To resolve the error, follow these steps:

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

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

3. Check for Regional Compatibility:

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

4. Test the Connection:

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

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

External references

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

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.