IssueTracker

Hello,

Thank you for the details. This has been forwarded internally.

Best regards

Also getting this, but I can narrow it down to one line.

I have tried different workarounds based on other responses. This is a simplified script, basically, if I comment out setNumberFormat and setNumberFormats then it works, but no matter which one I use, the moment I use it I get the error.

Sep 14, 2020, 7:06:14 PM Error Service Spreadsheets failed while accessing document with id 1w-U7-Zh6bcY9_d0EARN8qes6k72zJy5Q2Nw-70tkYOM.

function onEdit_projections_UsageUnit(e) {
  // the sheet that we are generating the dropdowns on
  const range_check = (row, column) => (column === 2 && 1 <= row && row < 10);

  if (!(
    e.value != null
    // value has changed
    && e.oldValue !== e.value
    && e.source.getSheetName() === SHEET_PROJECTIONS
    && range_check(e.range.getRow(), e.range.getColumn())
  )) {
    return;
  }
  Logger.info('onEdit_projections_UsageUnit activate');
  
  // Option i
  // const sheet = e.range.getSheet();
  // Option ii
  const sheet = e.source.getSheetByName(SHEET_PROJECTIONS);
  
  // const sheet = SpreadsheetApp.getActiveSpreadsheet();
  
  Logger.info(`onEdit_projections_UsageUnit sheet ${sheet.getSheetName()}`);
  
  const mapRange = sheet.getRange('D3:9');
  const mapColumns = mapRange.getNumColumns();
  Logger.info(`onEdit_projections_UsageUnit mapRange ${mapRange.getNumRows()}:${mapColumns}`);
  
  const modelRange = sheet.getRange('C3:C9');  //mapRange.offset(0, -1, mapRange.getNumRows(), 1);
  const models = modelRange.getValues();
  
  Logger.info(`onEdit_projections_UsageUnit models (${models.join(', ')})`);
  
  for (const [index, [model, ]] of models.entries()) {
    Logger.info(`onEdit_projections_UsageUnit each:${index} model:${model}`);
    
    if (model === '') { 
      // wipe out formatting.
    } else if (true) {
      
      // option A:
      //const rowRange = mapRange.offset(index, 0, 1, mapColumns);
      // option B:
      const rowRange = sheet.getRange(`D${3 + index + 1}:${3 + index + 1}`);
      
      Logger.info(`onEdit_projections_UsageUnit each:${index} range:${rowRange.getA1Notation()}`);
      
      // option 1:
      //rowRange.setNumberFormat(`0.## blah`);
      // option 2:
      const sploosh = [new Array(mapColumns).fill(`0.## blah`)];
      rowRange.setNumberFormats(sploosh);
      Logger.info(sploosh);
    }
  }

  Logger.info(`onEdit_projections_UsageUnit done done`);
}

Any news on this?
I am experiencing the same issue.
The last notification mentions a timeout in the Drive service (not in Spreadsheet service):
Drive service timed out opening the document with ID ...
(This is my own translation since I receive notifications in Dutch).

I'm having the same issue.

(Every 1 minutes trigger)

function myFunction() {
  // create data
  let data = [];
  for(let i = 0;i < 1000;i++){
    data.push([1,2,3,4,5,6,7,8,9,0]);
  }

  //write spreadsheet
  const spreadsheet = SpreadsheetApp.openById("**************");
  const sheet = spreadsheet.getSheets()[0];
  sheet.clear();
  sheet.getRange("A:A").setNumberFormat('@');
  sheet.getRange(1, 1, data.length, data[0].length).setValues(data);

  console.log("complete");
}

Recently I get this error with charts, similar as reported above here and here. This only happens for charts which have a right vertical axis. This is a very recent issue (started last week) for me in daily run scripts, as such I believe it to be a different bug from what has been reported here originally. I have created a detailed bug report here. Please star my report if you experience the same issue.

Temporary workaround: change any right vertical axes to left vertical axes (obviously this won't work if you need both axes).

I am receiving the same error in multiple script implementations anytime I call sheet.insertChart().

Here is the sample sheet to reproduce the error

To reproduce the error, from the custom menu item select LAD Options/Build Dashboards/Build Simple Dashboard

The error is thrown on line 797 of the Dashboards/DashboardBuilder.gs file

What should happen is that 4 charts should be created on the Simple Dashboard Sheet, but instead it is throwing the exception described above

This script has been working for years, but has suddenly started producing this error within the last month

Hi All, I am also facing the same while pasting data from one sheet to another sheet. at initial stage my script was working fine but now i am facing this issue every time i run the script.

Exception: Service Spreadsheets timed out while accessing document with id 1nSz6FHI0dZg6vilDUWdwCLgLXYat8Y1yM2RXnCAJjs0.
at update_Rm_fms_V4(update RM FMS:10:136)

Code

function update_Rm_fms_V4()

{var e=SpreadsheetApp.openById("1K4c2H18shDU6YM72vw4Msp8AaWQkQaCguDRRvLMCIWQ").getSheetByName("RM FMS"),

//t=e.getLastRow(),

a=e.getRange(2,1,4000,17).getValues();

SpreadsheetApp.openById("1nSz6FHI0dZg6vilDUWdwCLgLXYat8Y1yM2RXnCAJjs0").getSheetByName("Sheetgo_RM Unique Data").getRange(2,1,4000,17).setValues(a),Logger.log(a)

}

Hello everyone,

For the purpose of this investigation, can anyone share an affected spreadsheet? Please make sure you are sharing a sanitized version of it - meaning any confidential information is erased.

Has the problem been resolved? I always catch: Exception: Service Spreadsheets failed while accessing document with id *****. In few really heavy tables.
But now all is working.

Not sure how to share the spreadsheet better. Sanitized version of my script is pretty simple as below.

function updateConvertHistory()
{
  var sheet = SpreadsheetApp.getActive().getSheetByName("Convert History");
  var values = [ ["x", "x", "x", "x", "x", "x", "x", "x", "x"] ];

  sheet.insertRowAfter(1);
  sheet.getRange("A2:I2").setValues(values);
}

Setup an hourly trigger to run updateConvertHistory() would get the error 1-2 times a week.

adam

+1, we're seeing this issue newly since last week on a bunch of spreadsheets that worked without any issues for months and months.

After not seeing this error for almost a year it has now happened again to one of my spreadsheets. Coincidentally or not, I recently (finally?) switched to the new IDE. When I run the scripts manually, the problem seems to occur less often. I have not applied any workarounds because I don't think this should be necessary. I hope the Google team finally comes up with a solution, if not at least an explanation.

I found out that for some obscure reason sheet.getLastColumn() was the problem (although it had worked fine before). I hardcoded the last column and since then I haven't seen the problem.