2

Google Sheets Add-on is erroring on Chrome when running a google.script.run.myFunction(). It runs correctly on Safari and Firefox and an exact copy of the project on another google user account also runs correctly.

Console error message just says uncaught as per the following screenshot:

No error is caught by adding .withFailureHandler() and the execution logs don't show the google.script.run as being run

doongie
  • 31
  • 3
  • 1. Catch the error with `.withFailureHandler()` 2. Check script editor>view> executions for timestamps, and whether it correlates with when the user triggered `google.script.run` and for any other errors. [Edit] your question with such debugging details. – TheMaster Sep 01 '20 at 04:06
  • https://issuetracker.google.com/issues/36764900 https://issuetracker.google.com/issues/36763018 – TheMaster Sep 01 '20 at 04:26
  • Thank you. Adding the logging from the first link exposed the error - is the issue as described here https://stackoverflow.com/questions/60230776/were-sorry-a-server-error-occurred-while-reading-from-storage-error-code-perm (logged in to multiple google accounts). Disabling App Script V8 runtime resolves. – doongie Sep 01 '20 at 05:08
  • I thought you said `FailureHandler()` didn't catch it. What logging do you mean? – TheMaster Sep 01 '20 at 06:42

1 Answers1

1

Issue is as described here We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED (logged in to multiple google accounts). Disabling App Script V8 runtime resolves.

doongie
  • 31
  • 3