Why would I be getting the error: Too many simultaneous invocations: Spreadsheets on a simple once a day trigger?

Question

I've searched around and still can't find anything directly related to the failure message I'm receiving. The script hasn't changed and it used to run just fine, but now in the past week or so it's failing more and more often. There are only 3 triggers on this file onOpen, onEdit(e) and the installed trigger that calls the percentChange function once a day in the morning. It's super simple, it grabs 2 named ranges, one is a column of percentages and the other contains the length of that data and then copies the percentages to another column so that we can track the daily percentage difference.

Here is the code(link to a bare spreadsheet):

function percentChange() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Overview Status');

  var calcPercentRangeObject = ss.getRange('calcPerc');
  var calcPercentRow = calcPercentRangeObject.getRow()+2;
  var calcPercentColumn = calcPercentRangeObject.getColumn();

  var dataRangeObject = ss.getRange('numCabs');
  var dataRow = dataRangeObject.getRow()+2;
  var dataColumn = dataRangeObject.getColumn();
  var dataLength =  dataRangeObject.getValue();
  var currentPercent = ss.getRange(calcPercentRow, calcPercentColumn, dataLength, 1).getValues();

  ss.getRange(dataRow, dataColumn, dataLength, 1).setValues(currentPercent);

}

Should I add a delay? That seems like a "janky" workaround...

Another question: why does this code take 10+seconds to run from the trigger but generally takes less than a second to run from the script editor?

---

Edit: It's not really a correct fix but I put in a 400ms delay after line 6 and have only gotten the error message once more...what an odd work around... This stopped working, I tried multiple delays spread out and removing the delay altogether. I still don't understand why it's intermittent without the code changing?!?!

---

I am the owner. It's shared with less than 60 people I created the trigger manually The only other installable trigger is onEdit() The script is set to run when no-one would really be looking at it a couple hours before the shift would start.

Answer 1

According to https://developers.google.com/apps-script/guides/services/quotas, quotas are per account and per day, so triggers created for other project scripts may be consuming your account quota.

Feature	Consumer (e.g., gmail.com) and G Suite free edition (legacy)	Google Workspace accounts
Triggers total runtime	90 min / day	6 hr / day

Answer 2

https://developers.google.com/apps-script/guides/services/quotas

Script invoked too many times per second for this Google user account. This indicates that the script began executing too many times in a short period. It most commonly occurs for custom functions that are called repeatedly in a single spreadsheet. To avoid this error, code your custom functions so that they only need to be called once per range of data, as explained in the guide to custom functions.

Answer 3

I think this has to do with the amount of time onEdit is being invoked. Maybe try to limit the amount of times this function is invoked per second. For me, I needed to only send 30 rows to the sheet at a time, let it process, and then try again. Let us know if that helps or you disagree.