Why am I getting an error and how to fix it?

Use this guide to troubleshoot the possible issues you might face when sending requests to Google Sheets or Google BigQuery through our add-on.

Error/Issue Reason Solution

Invalid argument: timeZone. Should be of type: String.

There is no timezone provided.

To resume an automatic report update, provide the required timezone manually: File > Spreadsheet settings > Time zone.

Note: If you face a timezone error, please report it to our Support team at bi@owox.com. We’ll use this information for further investigation.
toLowerCase.

The error might require further analysis by developers.

Please report the full error message along with all the steps to reproduce this error to our Support team at bi@owox.com.
Too many simultaneous invocations: Spreadsheets. The script exceeded the maximum allowable number of simultaneous invocations to a single spreadsheet.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Limit exceeded: {feature name}. The script exceeded one of the quotas or limitations listed for the given feature.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Service invoked too many times: {service name}. The script called the given service too many times in one day.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Service invoked too many times in a short time: {service name}. Try Utilities.sleep(1000) between calls. The script called the given service too many times in a short period.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Service using too much computer time for one day. The script exceeded the total allowable execution time for one day.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Script invoked too many times per second for this Google user account.

You ran the script too many times in a short period.

Read more

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

There are too many scripts running simultaneously for this Google user account. You ran too many scripts at once, although it is not necessarily the same script.

Follow the Apps Script’s quotas and limitations.

To prevent the excess of quotas and limitations, use separate accounts per user and avoid updating all the reports at the same time.

Connection failure. There are some network difficulties.

Try to reload a webpage. If the issue persists, turn off the 3rd party extensions in your browser, then try again.

Note, this error may also occur if you are logged in to several Google accounts simultaneously. Log out from all the accounts except the one you use to work with the OWOX BI add-on. After that, reload the webpage.
ScriptError: API call to bigquery.jobs.insert failed with error: Field {field_name} already exists in schema. You try to export the Google Spreadsheets table, which duplicates a field in the Google BigQuery table. Provide a different name for the duplicated field either in Google Spreadsheets or in Google BigQuery. Then try again.
The schedule of automatic report update doesn’t work.

The possible reasons are:

  • the destination table was changed;
  • the requested fields were renamed;
  • access token became invalid;
  • SQL request was modified that prevent the script from being run.
Fix the mentioned reasons.
Changes are not applied to the schedule of automatic report update. Unexpected error on the add-on’s or Google’s side.

Remove the function "timeBasedTriggerHandler" in My Triggers. Then provide a new schedule using the Schedule reports option in the OWOX BI BigQuery Reports add-on.

Note, your account should have the permissions to both the data source and data destination.

You can opt for the regular notifications about report updates in the Schedule reports configurations. Read more

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.