Use this guide to troubleshoot the possible issues you might face when sending requests to Google Sheets or Google BigQuery through our extension.
| 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 have run the script 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. |
| There are too many scripts running simultaneously for this Google user account. | You have run 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, that this error may also happen when you have signed in with multiple Google accounts in your web browser. Sign out from any other Google accounts except the one you used to install the OWOX Reports extension. Then reload the page. |
| 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. |
|
drive.google.com refused to connect |
Most probably, you have signed in with multiple Gmail accounts in your web browser. |
Sign out from any other Google accounts except the one you used to install the OWOX Reports extension. Then try to use the add-on again. Alternatively, open an incognito window and sign in with your Google account used to install the Extension. |
| The schedule of automatic report updates doesn’t work. |
The possible reasons are:
|
Fix the mentioned reasons. |
| Changes are not applied to the schedule of automatic report updates. | 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 Scheduled Refreshes option in the OWOX Reports extension. Note, that your account should have the permissions to both the data source and data destination. |
Note: You can opt for regular notifications about report updates in the Scheduled Refreshes configurations. Read more
0 Comments