Troubleshooting Transfer Configurations

This document is intended to help you troubleshoot the most common issues encountered when setting up a transfer. This document does not encompass all possible error messages or issues.

If you are experiencing issues that are not covered in this document, you can request support.

Examining errors in the run history

If your initial transfer run fails, examine the details in the run history. Errors listed in the run history can help you identify an appropriate resolution using this document.

Before contacting Google Cloud Support, capture any relevant information from the run history including any error messages.

General issues

When diagnosing general transfer issues, verify the following:

  • Verify that you have completed all the steps in the "Before You Begin" section of the documentation page for your transfer type.
  • The transfer configuration properties are correct.
  • The user account used to create the transfer has access to the underlying resources.

If your transfer configuration is correct, and the appropriate permissions are granted, refer to the following for solutions to commonly encountered issues.

Error: An unexpected issue was encountered. If this issue persists, please contact customer support.

Resolution: This error typically indicates a temporary outage or an issue within BigQuery. Wait approximately 2 hours for the issue to be resolved. If the problem persists, request support.

Error: Quota Exceeded.

Resolution: Transfers are subject to BigQuery quotas on load jobs. If you need to increase your quota, contact your Cloud Sales representative. For more information, see Calculating transfer quota usage.

DoubleClick Campaign Manager transfer issues

The following are common errors encountered when creating a DoubleClick Campaign Manager transfer.

Error: Import failed - no data was available for import. Please verify that data existence was expected.
Error: No data available for the requested date. Please try an earlier run date or verify that data existence was expected.

Resolution: Verify you are using the correct ID for the transfer. If you are using the correct ID, verify the DoubleClick Campaign Manager Cloud Storage bucket contains Data Transfer V2.0 files for the specified date range. If the files exist, schedule a backfill for the affected date range. For more information on creating a DoubleClick Campaign Manager backfill request, see Set up a backfill.

Error: ACCESS_DENIED: gaia user [USER] does not have BUCKETS_GET access to bucket [BUCKET].

Resolution: The user creating the DoubleClick Campaign Manager transfer must have read access to the Cloud Storage bucket containing the Data Transfer V2.0 files. You can obtain information about the Cloud Storage bucket and request access from your DoubleClick administrator.

DoubleClick for Publishers transfer issues

The following are common errors encountered when creating a DoubleClick for Publishers transfer.

Error: No data available for the requested date. Please try an earlier run date or verify that data existence was expected.
Error: Import failed - no data was available for import. Please verify that data existence was expected.

Resolution: Verify the DoubleClick for Publishers Cloud Storage bucket contains data transfer files for the specified date range. Your DoubleClick administrator manages the Cloud Storage bucket containing your Data Transfer files. Users creating DoubleClick transfers must be members of the Google Group with read access to the bucket.

You can verify Cloud Storage permissions by attempting to read files in the DoubleClick Data Transfer bucket. For more information on DoubleClick for Publishers Cloud Storage buckets, see Access DFP storage buckets.

If the files exist in the Data Transfer bucket and you have read permissions, schedule a backfill for the affected date range. For more information on creating a DoubleClick for Publishers backfill request, see Set up a backfill.
Error: AuthenticationError: NO_NETWORKS_TO_ACCESS.

Resolution: Ensure you have read access to the DoubleClick for Publishers network. If you need assistance determining network access, contact DoubleClick for Publishers support.

Error: Error code 9 : Field [FIELD_NAME]?[FIELD_NAME]?[FIELD_NAME]?RefererURL is unknown.; Table: [TABLE_NAME]

Resolution: Ensure you are not using the thorn (þ) delimiter. The thorn delimiter is currently unsupported. Use of the thorn is indicated by the ? in the error message.

Google AdWords transfer issues

The following are common errors encountered when creating a Google AdWords transfer.

Error: CUSTOMER_SERVING_TYPE_REPORT_MISMATCH.

Resolution: AdWords manager accounts (MCCs) are not currently supported. Until the BigQuery Data Transfer Service adds support for AdWords manager accounts, you must create a separate transfer for each customer ID.

Error: Import failed - no data was available for import. Please verify that data existence was expected.
Error: No data available for the requested date. Please try an earlier run date or verify that data existence was expected.

Resolution: If you receive this error when you are creating a Google AdWords transfer, request support and include a screen capture of the error message.

Error: AuthenticationError.NOT_ADS_USER.

Resolution: The user setting up the Google Adwords transfer must have a Google AdWords account/login.

YouTube transfer issues

The following are common errors encountered when creating a YouTube transfer.

Error: Import failed - no data was available for import. Please verify that data existence was expected.
Error: No data available for requested date. Please try an earlier run date or verify that data existence was expected.

Resolution: If you have not previously created YouTube reporting jobs, allow YouTube at least 2 days for the BigQuery Data Transfer Service to generate the reports on your behalf. No additional action is required. Transfers will fail for the first 2 days and should succeed on day 3. If you have previously created YouTube reporting jobs, confirm the user creating the transfers has read access to the reports.

Also, verify the transfer was set up for the correct account. Specifying the correct YouTube page ID is not sufficient. In the OAuth dialog, you must select the channel for which you would like to load data.

Error: No reports for reporting job with name [NAME].

Resolution: This is not an error. It is a warning that indicates no data was found for the specified report. You can ignore this warning. Future transfers will continue to run.

Issue: The resulting tables created by the transfer are incomplete, or the results
are unexpected.

Resolution: If you have multiple accounts, you must choose the correct account when you receive the YouTube permissions dialog. Specifying the correct YouTube page ID without choosing the correct account will give you unexpected results.

YouTube permissions issues

For YouTube Content Manager reports, the user setting up the transfer must have CMS user permissions (at a minimum). CMS user permissions must be granted to each content manager for whom you are creating a transfer.

Quota issues

Error: Quota exceeded: Your project exceeded quota for imports per project.

Resolution: Verify you have not scheduled too many transfers in your project. For information on calculating the number of load jobs initiated by a transfer, see Transfer quotas.

Monitor your resources on the go

Get the Google Cloud Console app to help you manage your projects.

Send feedback about...