Boomi · Data Integration: Google BigQuery

RVR-LTBQ-100: failure loading data into BigQuery

Short answer

RVR-LTBQ-100 means loading data into BigQuery failed. The documented causes are data type mismatches, a region difference between the bucket and the dataset, or missing service account permissions.

VerifiedLast verified

01Error text

Boomi error
Error Code: RVR-LTBQ-100

02Likely causes

  • Data type mismatches, for example strings inserted into a date field.
  • The GCS bucket region differs from the BigQuery dataset region.
  • Permission or connection issues.

03How to fix it

  1. Make the source types match the BigQuery target.
  2. Confirm the GCS bucket region matches the dataset region.
  3. Give the service account "BigQuery Data Viewer" and "BigQuery Job User", plus access to the source bucket and dataset.
  4. Check the Custom File Zone setting under Advanced Options against the service account and bucket.

iNotes

Boomi's page words these causes as typical scenarios, not a definitive diagnosis.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Boomi work:Open Boomi jobsBoomi rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.