BigQuery Error: Could Not Handle the Request, Error Code 500 or 502

BigQuery Error: Could Not Handle the Request, Error Code 500 or 502

This article will assist you with the following errors:

Error: could not handle the request (500), Error: could not handle the request (502)

The description for a BigQuery error in the logs in your PMA hub.

Cause

These errors can occur when your export is larger than BigQuery's limits. This will cause your export to fail.

Solution

Make sure your reports contain fewer than 40,000 rows. If you are exporting a larger amount of data, please follow the steps in BigQuery Export Limitations.

    • Related Articles

    • BigQuery Error: Code 403; Message: Access Denied

      This article will assist you with the following errors: Code: 403; Message: Access Denied: BigQuery BigQuery: Streaming insert is not allowed in the free tier (accessDenied) Code: 403; Message: Access Denied: Dataset: Permission denied on dataset (or ...

    • Troubleshooting BigQuery

      When troubleshooting BigQuery, you may need to view your BigQuery export logs. This article will show you how to check the logs and see details about any errors. Viewing Export Logs Your BigQuery export logs show a timestamped record of your exports ...

    • Bad Request: Error 400 or Code: 400

      When adding a new data source to your Power My Analytics hub, you may encounter a "Bad Request: Error 400" or "Code: 400" message. This guide will help you understand the cause of this error and provide simple steps to resolve it. Error "Bad Request: ...

    • Troubleshooting BigQuery Export Errors: Setup, Schema, and Code 500

      If your BigQuery export is failing (or you are not sure whether you set it up correctly), this guide walks you through the prerequisites, explains how Power My Analytics creates your tables and schema for you, and shows you how to resolve the most ...

    • Error: Missing BigQuery Scopes

      When setting up or running BigQuery exports in Power My Analytics, you may see an error message stating “Missing BigQuery Scopes.” This means the Google account you use as your BigQuery destination is missing the permissions Power My Analytics needs ...