TM1 connection issue

If you get TeamOne is having issues connecting to TM1, try the following steps:

  • check your VPN connection (if you are using one)
  • check your TM1 SSL connection (by clicking the connection link link in the Check connection dialog) your VPN connection (if you are using one). If there is a connection issue, you will see a grey box with a sad faced emoji. If connection is fine, you will see the api version numbers. See SSL certificateimg
  • If you see a browser SSL warning (i.e. "Your connection is not private", "Your connection is not secure", etc.), you can accept it by clicking the Advanced button below and then Proceed to. After that you can go back to TeamOne, close the error dialog and click the refresh tab button. img
  • Check your TM1 is up
  • Is your TM1 server hosted on AWS or elsewhere? Check the firewall rules and make sure the HTTPPortNumber port is open
  • Contact us

TeamOne add-on not working when signed in with multiple accounts

Additionally you may see the following messages in Dev console:

  • Exception: You do not have permission to access the requested document.
  • ERROR: Authorization is required to perform that action. (the error message can be different in different languagues) There is a limitation of add-ons when using multiple accounts. It is documented here: https://developers.google.com

You can use one of the next workarounds:

  • sing out from all accounts and sing it back first with the account you intend to use TeamOne add-on with
  • for Google Chrome, use a separate account profile
  • for Firefox, use a separate account containers
  • use a different browser for TeamOne add-on
  • use a new incognito window

TeamOne add-on not working. PERMISSION_DENIED

You may also see the next error in Dev console: We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED.? This is a random error when trying to access Google script functions. Try the following to resolve it:

  • re-open TeamOne Sidebar
  • re-fresh page and try opening TeamOne Sidebar
  • re-login to your Google account, re-open your Google sheet and try opening TeamOne Sidebar

TeamOne add-on not working in incognito window

You may also see the next error in Dev console: Error in v-on handler: "SecurityError: Failed to read the 'localStorage' property from 'Window': Access is denied for this document." TeamOne add-on is using cookies and it may be blocked by your browser, for instance under Chrome's Settings > Privacy > Content settings, you have the cookie setting set to "Block sites from setting any data". Enable cookies and try again.

=TEAMONE() formula returns "unknown function" error

Make sure you opened the TeamOne sidebar, it will load all the add-on scripts including the TEAMONE() function.

In some cases (like when you copy an existing sheet document), add-ons may require you to re-acivate them. Try the next steps:

  1. Go to Extensions > TeamOne > Help menu
  2. Click View in store
  3. Click the Settings icon at the top right and select Manage Apps
  4. Click the Options icon (3 vertical dots) on the TeamOne add-on card
  5. Uncheck Use in this document
  6. Click the Options icon icon again and select Use in this document
  7. Close the marketplace screen
  8. Refresh the page and try TEAMONE recalculate on the sidebar functions tab

ResultSetOutOfMemory: AuditLogMaxQueryMemory too small

If you are getting ResultSetOutOfMemory: AuditLogMaxQueryMemory too small please make sure you have PA 2.0.9.17 or later


Succeedium® TeamOne 2023 | Privacy Policy | Terms Of Service