Connection issue
If you get TeamOne is having issues connecting to IBM PA, try the following steps:
- check your VPN connection (if you are using one)
- click the CHECK connection button below and if you see a SSL warning (i.e. "Your connection is not private", "Your connection is not secure", etc.), you should configure a [custom SSL certificate].(https://www.ibm.com/support/pages/how-configure-ssl-planning-analytics-data-tier-using-gskit-new-certificate-signing-request) for your IBM PA server. You can temporarily accept the warning by clicking the Advanced button below and then Proceed to. After that you can go back to Google Sheets and re-open TeamOne sidebar.
- Check your IBM PA (TM1) server is up
- Are you using IBM PA 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 following 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
We recommend using a separate Google Chrome profile (or Firefox ount container) with your work email.
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:
- Go to Extensions > TeamOne > Help menu
- Click View in store
- Click the Settings icon at the top right and select Manage Apps
- Click the Options icon (3 vertical dots) on the TeamOne add-on card
- Uncheck Use in this document
- Click the Options icon icon again and select Use in this document
- Close the marketplace screen
- 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