Fixed
Status Update
No update yet.
Comments
se...@gmail.com
Hello,
Thank you for the details. This has been forwarded internally.
Best regards
lb...@gmail.com
Hi,
Same here. We have a set-up running which is far below the quota, but on certain occasions it fails when accessing a document with the same error message: "service spreadsheets timed out while accessing document with id".
While normally happening only once in a while, for the last weekend it has been happening on every occasion of it running, which is every hour, so for the last 40+ times of it running it has thrown an error.
For me it fails most often on this row:
spreadsheetApp.openById("...").getSheetByName("name").getRange(1,1, sheet.getLastRow().createTextFinder("...").matchCase(false).findNext();
It would be very helpful if this could be investigated!
Thanks.
Same here. We have a set-up running which is far below the quota, but on certain occasions it fails when accessing a document with the same error message: "service spreadsheets timed out while accessing document with id".
While normally happening only once in a while, for the last weekend it has been happening on every occasion of it running, which is every hour, so for the last 40+ times of it running it has thrown an error.
For me it fails most often on this row:
spreadsheetApp.openById("...").getSheetByName("name").getRange(1,1, sheet.getLastRow().createTextFinder("...").matchCase(false).findNext();
It would be very helpful if this could be investigated!
Thanks.
jk...@gmail.com
I think this is a V8 Runtime issue. I disabled V8 Runtime early last week and I haven't had this issue since. V8 is technically still in BETA and I've posted a seperate bug previously regarding specifically the V8 Runtime in which Google was able to replicate and is currently working on a fix
EDIT: The error happened again this morning (May 22nd) and the code ran on the previous runtime enviornment. So this bug is not specific to the V8 runtime enviornment
EDIT: The error happened again this morning (May 22nd) and the code ran on the previous runtime enviornment. So this bug is not specific to the V8 runtime enviornment
ha...@sannsyn.com
Any update on this? This has started to become a daily issue for my organization..
uc...@google.com
ud...@google.com
mt...@gmail.com
I am also experiencing this issue, with the same use case, we also have a script that pulls data every morning. for the past months, it has been running great. and then it just started behaving weirdly.
During the different parts of the execution,
- deleting existing data
- creating new data
It is having issue with the Spreadsheet Service, with no helpful information.
During the different parts of the execution,
- deleting existing data
- creating new data
It is having issue with the Spreadsheet Service, with no helpful information.
ud...@google.com
mt...@gmail.com
I am also experiencing the same issue.
My code:
line 1: function Racer(event)
line 2: {
line 3: var sheetName1 = "Applications: Account# Entry"; // labeling sheet names
line 4: var sheetName2 = "Applications: Credit Entry";
line 5: var sheetName3 = "Applications: Sage Entry";
line 6: var sheet = event.source.getActiveSheet()
line 7: console.log(sheet)
line 8:
line 9: //-----------------------------------------------------------------------------------------------------------------------------------
line 10: if (sheet.getName() == sheetName3) //if it is an edit in the correct sheet then
Sometimes my code will function without any problems. Other times without any changes it will get stuck on line 10 and not stop executing until I cancel the execution or my computer time for the day runs out.
The error message I am receiving via email:
Service Spreadsheets timed out while accessing document with id 1QDqGgQtAncVZS0zx2N7P7BA4-zakPB0k15P******. (line 10, file "Code")
A temporary solution that seemed to work for me:
copy and paste your code into a newcode.gs file
My code:
line 1: function Racer(event)
line 2: {
line 3: var sheetName1 = "Applications: Account# Entry"; // labeling sheet names
line 4: var sheetName2 = "Applications: Credit Entry";
line 5: var sheetName3 = "Applications: Sage Entry";
line 6: var sheet = event.source.getActiveSheet()
line 7: console.log(sheet)
line 8:
line 9: //-----------------------------------------------------------------------------------------------------------------------------------
line 10: if (sheet.getName() == sheetName3) //if it is an edit in the correct sheet then
Sometimes my code will function without any problems. Other times without any changes it will get stuck on line 10 and not stop executing until I cancel the execution or my computer time for the day runs out.
The error message I am receiving via email:
Service Spreadsheets timed out while accessing document with id 1QDqGgQtAncVZS0zx2N7P7BA4-zakPB0k15P******. (line 10, file "Code")
A temporary solution that seemed to work for me:
copy and paste your code into a new
hu...@google.com
+ 1 i am seeing this consistently when running a script from a trigger which attempts to reformat a range.
Number of cells, normally no greater than 300k.
function formatTable(range) {
SpreadsheetApp
.getActiveSheet()
.autoResizeColumns(1, SpreadsheetApp.getActiveSheet().getLastColumn() )
.setActiveRange(range)
.setVerticalAlignment("top")
.setWrap(true)
.applyRowBanding(SpreadsheetApp.BandingTheme.CYAN) ;
};
Number of cells, normally no greater than 300k.
function formatTable(range) {
SpreadsheetApp
.getActiveSheet()
.autoResizeColumns(1, SpreadsheetApp.getActiveSheet().getLastColumn() )
.setActiveRange(range)
.setVerticalAlignment("top")
.setWrap(true)
.applyRowBanding(SpreadsheetApp.BandingTheme.CYAN) ;
};
lb...@gmail.com
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`);
}
da...@google.com
I am affected by the same issue. This is affecting several domains where our script is used and it's a very major issue for us.
I am trying to use the setValues() method on a range of 1200 rows x 140 columns ( about 170 000 cells). Usually that takes less than 20 seconds according to the executions log. Starting this week we have started getting a lot of time out errors at this line of code. I created the attached spreadsheet to replicate the issue. Our code is deployed in several different domains, as a google apps script running behind a spreadsheet, not as a web app. This problem happens over at least three different domains so far. Very frustrating. Usually it's accompanied by the spreadsheet saying it's trying to connect, but not always. We have tried this at several different sites with no known internet connectivity issues and this keeps happening.
To replicate: open linked spreadsheet, go to tools->script, select myFunction and press run. View execution log from view -> executions. I have recorded the number of rows and columns in the array passed to setValues().
https://docs.google.com/spreadsheets/d/1uZNSNfx3r7JkuN9WD7eZ6WpZasl86wjt-wxAshAQqio/edit?usp=drive_web (Replicating setValues Issue)
This is my code:
function myFunction() {
var row1 = 5;
var col1 = 5;
var row2 = 1300;
var col2 = 140;
console.log({numrows:row2, numcols:col2} );
var rng = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange(row1,col1,row2,col2);
var values_to_set = rng.getValues();
var rng2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2").getRange(row1,col1,row2,col2);
rng2.setValues(values_to_set);
}
I am trying to use the setValues() method on a range of 1200 rows x 140 columns ( about 170 000 cells). Usually that takes less than 20 seconds according to the executions log. Starting this week we have started getting a lot of time out errors at this line of code. I created the attached spreadsheet to replicate the issue. Our code is deployed in several different domains, as a google apps script running behind a spreadsheet, not as a web app. This problem happens over at least three different domains so far. Very frustrating. Usually it's accompanied by the spreadsheet saying it's trying to connect, but not always. We have tried this at several different sites with no known internet connectivity issues and this keeps happening.
To replicate: open linked spreadsheet, go to tools->script, select myFunction and press run. View execution log from view -> executions. I have recorded the number of rows and columns in the array passed to setValues().
This is my code:
function myFunction() {
var row1 = 5;
var col1 = 5;
var row2 = 1300;
var col2 = 140;
console.log({numrows:row2, numcols:col2} );
var rng = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange(row1,col1,row2,col2);
var values_to_set = rng.getValues();
var rng2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2").getRange(row1,col1,row2,col2);
rng2.setValues(values_to_set);
}
lb...@gmail.com
This issue is affecting our production. Is there a timeline for resolution?
da...@google.com
I am affected by the same issue. Is there a timeline for resolution?
Description
Version of Gradle Plugin:
Version of Gradle:
Version of Java:
OS:
Android Studio 3.3 Canary 6
Build #AI-182.3684.101.33.4954005, built on August 15, 2018
JRE: 1.8.0_152-release-1136-b06 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Windows 10 10.0
Steps to Reproduce:
1. Have a project that has Firebase and Crashlytics in it, with this :
classpath 'com.google.gms:google-services:4.0.2'
2. Notice it builds fine.
3. Now update to this:
classpath 'com.google.gms:google-services:4.1.0'
The bug is that now it doesn't build at all, showing you this issue:
> Task :app:fabricGenerateResourcesDebug FAILED
ERROR - Crashlytics Developer Tools error.
java.lang.IllegalArgumentException: Crashlytics found an invalid API key: null.
Check the Crashlytics plugin to make sure that the application has been added successfully!
Contact support@fabric.io for assistance.
at com.crashlytics.tools.android.DeveloperTools.processApiKey(DeveloperTools.java:375)
at com.crashlytics.tools.android.DeveloperTools.processProperties(DeveloperTools.java:517)
at com.crashlytics.tools.android.DeveloperTools.processArgsInternal(DeveloperTools.java:348)
at com.crashlytics.tools.android.DeveloperTools.gradleMain(DeveloperTools.java:292)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.invoke(StaticMetaMethodSite.java:46)
at org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:91)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
at com.crashlytics.tools.gradle.tasks.FabricTaskBuilder.callDevtoolsWrappingRuntimeExceptions(FabricTaskBuilder.groovy:359)
at com.crashlytics.tools.gradle.tasks.FabricTaskBuilder.this$2$callDevtoolsWrappingRuntimeExceptions(FabricTaskBuilder.groovy)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:384)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1022)
at org.codehaus.groovy.runtime.callsite.PogoMetaClassSite.callCurrent(PogoMetaClassSite.java:69)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:52)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:154)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:166)
at com.crashlytics.tools.gradle.tasks.FabricTaskBuilder$_pluginGenerateResources_closure4.doCall(FabricTaskBuilder.groovy:132)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1022)
at groovy.lang.Closure.call(Closure.java:414)
at groovy.lang.Closure.call(Closure.java:430)
at org.gradle.api.internal.AbstractTask$ClosureTaskAction.execute(AbstractTask.java:724)
at org.gradle.api.internal.AbstractTask$ClosureTaskAction.execute(AbstractTask.java:697)
at org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter$1.run(ExecuteActionsTaskExecuter.java:131)
at org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:300)
at org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:292)
at org.gradle.internal.operations.DefaultBuildOperationExecutor.execute(DefaultBuildOperationExecutor.java:174)
at org.gradle.internal.operations.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
at org.gradle.internal.operations.DelegatingBuildOperationExecutor.run(DelegatingBuildOperationExecutor.java:31)
at org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeAction(ExecuteActionsTaskExecuter.java:120)
at org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.executeActions(ExecuteActionsTaskExecuter.java:99)
at org.gradle.api.internal.tasks.execution.ExecuteActionsTaskExecuter.execute(ExecuteActionsTaskExecuter.java:77)
at org.gradle.api.internal.tasks.execution.OutputDirectoryCreatingTaskExecuter.execute(OutputDirectoryCreatingTaskExecuter.java:51)
at org.gradle.api.internal.tasks.execution.SkipUpToDateTaskExecuter.execute(SkipUpToDateTaskExecuter.java:59)
at org.gradle.api.internal.tasks.execution.ResolveTaskOutputCachingStateExecuter.execute(ResolveTaskOutputCachingStateExecuter.java:54)
at org.gradle.api.internal.tasks.execution.ValidatingTaskExecuter.execute(ValidatingTaskExecuter.java:59)
at org.gradle.api.internal.tasks.execution.SkipEmptySourceFilesTaskExecuter.execute(SkipEmptySourceFilesTaskExecuter.java:101)
at org.gradle.api.internal.tasks.execution.FinalizeInputFilePropertiesTaskExecuter.execute(FinalizeInputFilePropertiesTaskExecuter.java:44)
at org.gradle.api.internal.tasks.execution.CleanupStaleOutputsExecuter.execute(CleanupStaleOutputsExecuter.java:91)
at org.gradle.api.internal.tasks.execution.ResolveTaskArtifactStateTaskExecuter.execute(ResolveTaskArtifactStateTaskExecuter.java:62)
at org.gradle.api.internal.tasks.execution.SkipTaskWithNoActionsExecuter.execute(SkipTaskWithNoActionsExecuter.java:59)
at org.gradle.api.internal.tasks.execution.SkipOnlyIfTaskExecuter.execute(SkipOnlyIfTaskExecuter.java:54)
at org.gradle.api.internal.tasks.execution.ExecuteAtMostOnceTaskExecuter.execute(ExecuteAtMostOnceTaskExecuter.java:43)
at org.gradle.api.internal.tasks.execution.CatchExceptionTaskExecuter.execute(CatchExceptionTaskExecuter.java:34)
at org.gradle.api.internal.tasks.execution.EventFiringTaskExecuter$1.run(EventFiringTaskExecuter.java:51)
at org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:300)
at org.gradle.internal.operations.DefaultBuildOperationExecutor$RunnableBuildOperationWorker.execute(DefaultBuildOperationExecutor.java:292)
at org.gradle.internal.operations.DefaultBuildOperationExecutor.execute(DefaultBuildOperationExecutor.java:174)
at org.gradle.internal.operations.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:90)
at org.gradle.internal.operations.DelegatingBuildOperationExecutor.run(DelegatingBuildOperationExecutor.java:31)
at org.gradle.api.internal.tasks.execution.EventFiringTaskExecuter.execute(EventFiringTaskExecuter.java:46)
at org.gradle.execution.taskgraph.LocalTaskInfoExecutor.execute(LocalTaskInfoExecutor.java:42)
at org.gradle.execution.taskgraph.DefaultTaskExecutionGraph$BuildOperationAwareWorkItemExecutor.execute(DefaultTaskExecutionGraph.java:273)
at org.gradle.execution.taskgraph.DefaultTaskExecutionGraph$BuildOperationAwareWorkItemExecutor.execute(DefaultTaskExecutionGraph.java:258)
at org.gradle.execution.taskgraph.DefaultTaskPlanExecutor$ExecutorWorker$1.execute(DefaultTaskPlanExecutor.java:135)
at org.gradle.execution.taskgraph.DefaultTaskPlanExecutor$ExecutorWorker$1.execute(DefaultTaskPlanExecutor.java:130)
at org.gradle.execution.taskgraph.DefaultTaskPlanExecutor$ExecutorWorker.execute(DefaultTaskPlanExecutor.java:200)
at org.gradle.execution.taskgraph.DefaultTaskPlanExecutor$ExecutorWorker.executeWithWork(DefaultTaskPlanExecutor.java:191)
at org.gradle.execution.taskgraph.DefaultTaskPlanExecutor$ExecutorWorker.run(DefaultTaskPlanExecutor.java:130)
at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:63)
at org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:46)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:55)
at java.lang.Thread.run(Thread.java:745)
Attached video to show issue.
Also attached IDE log.