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
Error Code: RVR-LTBQ-10002Likely 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
- Make the source types match the BigQuery target.
- Confirm the GCS bucket region matches the dataset region.
- Give the service account "BigQuery Data Viewer" and "BigQuery Job User", plus access to the source bucket and dataset.
- 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
→Related errors
- RVR-LTBQ-102: keys not selected in mapping for mergeRVR-LTBQ-102 means no key fields are selected in the column mapping, and the upsert-merge mode needs keys to match records. Select the key fields in Column Mapping and save.
- RVR-DTBR-100: missing credentials for the file zoneRVR-DTBR-100 means the credentials for the storage service used as the file zone are missing or misconfigured. Add valid AWS keys or a Google service account file with the needed permissions.
- RVR-RDS-100: inconsistent data length (Redshift)RVR-RDS-100, inconsistent data length, means the data being loaded does not fit the Redshift table's column types or lengths. Align the source with the target schema, or use the Truncate Columns option.
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