!Error Message FAQ

When Analytics Edge encounters an error that it can’t handle automatically, Quick Queries will stop running and the error message appears in a popup dialog box. If you are running a macro, the message appears as a red bar in the Task Pane. If the message is too long, you can click the red bar, and the full text will appear in a popup.

If the error is not something you did wrong in your query or macro, check to see if there is an update available that fixes or avoids the error. Check the list on the right to see if there is additional guidance for dealing with the specific error you obtained. If not, contact support for assistance.

403 Request had insufficient authentication scopes

This error occurs when you do not select a required authentication item when adding your account for Analytics Edge use. When the login authentication screen opens in your browser, make sure to select (check) all of the boxes offered in the authorization request. In some cases, one or more of the boxes may be unchecked by default (as in the image below). More

Account not found. Check Account wizard

This error usually occurs when you share workbooks with coworkers, or after a computer move or rebuild. Analytics Edge stores a reference to the account in the workbook, but the actual security tokens are stored on your computer.  More

Authentication error

This error may indicate that a stored security token has expired and did not auto-renew. Delete the entry in the Account wizard and create a new one using the same reference name (case sensitive). Some Account wizards have a Refresh Login button that will update the selected entry.

Authentication failure

The login credentials or the API key being used have failed. Verify the account or API key and recreate (delete and add) the account using the Account wizard. More

Bad query combination

A combination of parameters in your query is not accepted by the server. Change the selections and try again.

Invalid client data

This error usually occurs when the account security token has expired or you have lost permission to access the specified account. More

Invalid dates

Usually caused by the selection of dates that are not recognized (formatting). Most Analytics Edge connectors will recognize Excel dates in cell references, or a combination of options that defines a range of dates (start+duration or start+end or duration+end).

Confirm that cell references used point to the cells that contain the dates (sometimes worksheet changes move the cell locations).

Invalid/missing dates

This error usually occurs when the cells you referenced in a query have moved or the contents are changed. Analytics Edge connectors offer the ability to use cell references for the dates, but the references can get out of alignment if you add rows or columns in the worksheet, or if you renamed the worksheet. More

License error: different computer

Analytics Edge is licensed by computer, so the add-in keeps track of the computer it is licensed for (even the free product is licensed). Sometimes a Windows Update or hardware change will mess up the license, and you will get an error saying “License issued to a different computer”. More

No account specified

This error happens when the query does not specify an account (bad cell reference?), or it uses the Default account setting and you have not saved a default account.

Not licensed

If the add-in or one of the installed connectors does not have a valid license, none of the queries or macros will run. Open the License wizard to see if all of the installed components have a valid license.

oauth_token_invalid

This error is usually caused by an expired security token that was saved on your computer. They would normally be auto-refreshed, but sometimes the refresh fails. More