We're sorry, a server error occurred while reading from storage. Error code NOT_FOUND

Question

I'm facing this issue while I'm running the script. one day before if was working fine for me. I did clear all the cache of chrome browser and I tried another laptop also but the issue is as it is. please help me to resolve the issue.

The code I'm running is:

function onOpen(e) {
  var menu = SpreadsheetApp.getUi().createMenu('Reporting Tools');
  menu.addItem('Create Unit Scorecards', 'HSIPScorecard2021CountryScripts.createInputSheets');
  menu.addItem('Notify Unit H&S Heads', 'HSIPScorecard2021CountryScripts.sendNotifications');
  menu.addItem('Consolidate Unit Data', 'HSIPScorecard2021CountryScripts.Consolidate');
  menu.addToUi();
}

Answer 1

I just ran into the same problem last week. After wasting a few day's time, I found it was caused by a reference to a library using development mode. Change it to a deployment version solved that.

Answer 2

Assuming that the name of the library is correct you can write that like this:

function onOpen(e) {
      SpreadsheetApp.getUi().createMenu('Reporting Tools')
      .addItem('Create Unit Scorecards', 'HSIPScorecard2021CountryScripts.createInputSheets');
      .addItem('Notify Unit H&S Heads', 'HSIPScorecard2021CountryScripts.sendNotifications');
      .addItem('Consolidate Unit Data', 'HSIPScorecard2021CountryScripts.Consolidate');
      .addToUi();
    }

Answer 3

There are two things that need to be checked in order to fix this issue.

1. The Library reference should link to the Deployment Version and not to the Development Mode.
2. The Library file should not be restricted in case you are sharing the copy of the original file with somebody else.

Answer 4

I had the same error... It appeared that the library (HSIPScorecard2021CountryScripts in your case) had a reference to another library (BasicTools). From the account that owned both, it worked. However, from any other account, that error appeared. Even if Edit permission was given.

The solution was to move the functions from BasicTools to HSIPScorecard2021CountryScripts (and fix the functions calls).

So, in short, one more solution to try is to make sure the library you are using doesn't use any other libraries.

Answer 5

Using an installable trigger in the parent library (instead of onOpen() in the dependent script) also fixes this issue.

ScriptApp.newTrigger('exported.createDefaultMenuAndAddToUI')
  .forSpreadsheet(SpreadsheetApp.getActive())
  .onOpen()
  .create(); 

It will give you a new problem in that the menu item actions are outside of the dependent library scope. I manage referencing things that need to be accessed by both the library and its dependent scripts like this:

function getExports () {
  return {  
    /* TRIGGERS */
    hourlyCronTask, 
    createDefaultMenuAndAddToUI,
    /* MENU ITEMS */
    actionInitialHelp,
    ...
  };
}

const exported = getExports();

Then in dependent script Code.js

const exported = MyParentLibrary.getExports();

These need to be defined in a hoistable function rather than a constant since only these are exposed to dependent scripts.