Fixed
Status Update
Comments
[Deleted User] <[Deleted User]> #2
Sorry! forgot project key... MkJFYmutPLe-ome_7Zkfr2nq4WKbcYvGS.
fo...@blockspring.com <fo...@blockspring.com> #3
And let me use your format just in case it's a prerequisite:
Please search through existing issues first to ensure that the bug has
- not already been reported. // OK
Please provide a short description of the issue:
- Any custom function I try to run via Google App Scripts returns a #Error.
Please provide a small sample script that reliably reproduces the issue.
The sample should run as-is or with minimal setup, without external
dependencies.
- See here:https://docs.google.com/spreadsheets/d/1vZl8Z6xC5BUcN6MI9FcwGXGPTkbt4QNllT5Eoj27PtI/edit#gid=0 .
What steps will reproduce the problem?
1. Go to that spreadsheet.
2. Copy and paste the app script into your own.
3. Run a =hello() function.
4. Drag down and you'll get #ERROR.
What is the expected output? What do you see instead?
- Expecting to see the result of the script rather than #ERROR. For =hello() it should return "world".
*To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.*
Please search through existing issues first to ensure that the bug has
- not already been reported. // OK
Please provide a short description of the issue:
- Any custom function I try to run via Google App Scripts returns a #Error.
Please provide a small sample script that reliably reproduces the issue.
The sample should run as-is or with minimal setup, without external
dependencies.
- See here:
What steps will reproduce the problem?
1. Go to that spreadsheet.
2. Copy and paste the app script into your own.
3. Run a =hello() function.
4. Drag down and you'll get #ERROR.
What is the expected output? What do you see instead?
- Expecting to see the result of the script rather than #ERROR. For =hello() it should return "world".
*To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.*
[Deleted User] <[Deleted User]> #4
This might be related to: https://code.google.com/p/google-apps-script-issues/issues/detail?id=5130
Although for us, the error became apparently obvious yesterday. Since May custom functions have been unpredictably delivering #ERROR, but it was rare. Since yesterday it has almost been 100% #ERROR.
Although for us, the error became apparently obvious yesterday. Since May custom functions have been unpredictably delivering #ERROR, but it was rare. Since yesterday it has almost been 100% #ERROR.
ni...@openadviser.com <ni...@openadviser.com> #5
I have the same issue with my custom function as well. Even the simple function returning "test" in multiple cells results in a bunch of "#ERROR". When refreshing one of the parameters the desired value sometime appears and sometimes it's "#ERROR'-> Internal error executing custom function.
zm...@gmail.com <zm...@gmail.com> #6
FYI I also confirm this is a bug in alps script. stackoverflow today has several people asking about this.
Im an apps script "GDE".
Im an apps script "GDE".
pi...@geotab.com <pi...@geotab.com> #8
Note that I've managed to temporarily work around this by using the old Google sheets. This is not ideal cause I had to make some code changes to make it work again but URLFetch works perfectly fine in the old Google Sheet format.
For the old sheets go here:
http://g.co/oldsheets or http://goo.gl/GIPO9h
For the old sheets go here:
an...@gmail.com <an...@gmail.com> #9
Yup I can confirm that once the new Google Sheets took effect all my google sheets with scripts are no longer working. I get a generic error saying "Internal Error executing custom function"
I tried restoring from previous revisions with no luck.
I tried restoring from previous revisions with no luck.
ja...@gmail.com <ja...@gmail.com> #10
I'm in the same boat. Thought maybe it was my code making too many calls. Spent some time trying to debug the code then found this thread. Hoping for a quick solution because... whats' the alternative? VBA? Ugh!
ko...@gmail.com <ko...@gmail.com> #11
I tried to replicate this problem but I wasn't able to. Are you still seeing this problem? If so, please provide the exact steps and code that you used.
zm...@gmail.com <zm...@gmail.com> #12
have you tried the linked s.o. questions?
On Tue, Jul 14, 2015, 8:17 PM <google-apps-script-issues@googlecode.com>
wrote:
On Tue, Jul 14, 2015, 8:17 PM <google-apps-script-issues@googlecode.com>
wrote:
pk...@gmail.com <pk...@gmail.com> #13
Works now for me. Problem was fixed?
ja...@gmail.com <ja...@gmail.com> #14
After posting my comment, everything started working again. So as of now, it looks like the problem has been resolved (for me).
ko...@gmail.com <ko...@gmail.com> #15
I'm marking this as fixed, but let me know if you are still seeing these errors.
ja...@gmail.com <ja...@gmail.com> #16
Seems to be happening again today after working most of last week. Anything change? All of my functions are returning the #ERROR plus the "Internal error executing the custom function." message. The troubling thing is that I never know, day to day whether I'll have access to my data and charts because when this error occurs, all I see are errors. :-(
pk...@gmail.com <pk...@gmail.com> #17
I also still see this error. Although now I only see it ~15% of the time, as opposed to 95% when I opened this issue.
FYI - We're running thousands of custom functions an hour.
FYI - We're running thousands of custom functions an hour.
[Deleted User] <[Deleted User]> #18
Now seeing this error again a substantial % of time (over 50% of times we're running scripts). I vote to re-open issue until Google Scripts is stable.
ja...@gmail.com <ja...@gmail.com> #19
I agree that the issue should be reopened. I am constantly confronted with the ERRORs in my spreadsheets. Often, the only way I can get the functions to work is to delete the functions from the cell and then paste or retype them in again. Frustrating.
[Deleted User] <[Deleted User]> #20
That's my tactic too! Delete and rerun :). Wish Google Scripts was
production ready - it has so much potential.
On Sun, Jul 26, 2015 at 10:25 PM, <google-apps-script-issues@googlecode.com>
wrote:
production ready - it has so much potential.
On Sun, Jul 26, 2015 at 10:25 PM, <google-apps-script-issues@googlecode.com>
wrote:
ko...@gmail.com <ko...@gmail.com> #21
I've tested again, and again the functions seem to be working correctly. Can someone please re-test?
The problem seems to have occurred around the same time each week (Sunday night / Monday morning EDT). It could be there is some temporary outage taking place at this time.
The problem seems to have occurred around the same time each week (Sunday night / Monday morning EDT). It could be there is some temporary outage taking place at this time.
[Deleted User] <[Deleted User]> #22
I'm linking back to my original Test sheet. As you can see a vast majority (back up to 90%+) of script calls are failing again:
https://docs.google.com/spreadsheets/d/1vZl8Z6xC5BUcN6MI9FcwGXGPTkbt4QNllT5Eoj27PtI/
[Deleted User] <[Deleted User]> #23
It looks like custom functions and Google Scripts are now 100% offline. Nothing going through.
ko...@gmail.com <ko...@gmail.com> #24
@paul, I'm seeing nearly 100% success on the test sheet. Are you seeing the same thing?
[Deleted User] <[Deleted User]> #25
Yes. Thank you so much for fix.
ko...@gmail.com <ko...@gmail.com>
ek...@google.com <ek...@google.com>
mi...@gmail.com <mi...@gmail.com> #26
Have been experiencing this problem for weeks! Anybody else?
kd...@ext.uber.com <kd...@ext.uber.com> #27
I received this error with the following code:
function VarTitle(input) {
var count = input.length; //count of array rows
var str = toString(input);
var str1 = str.replace(/{/g,"");
var str2 = str1.replace(/}/g,"");
var str3 = str2.replace(/'/g,"");
//Remove "{" , "}" , and "'" from the string
var str4 = str3.replace(/:/g,",");
//Replace ':' with "," to split the number variables in the string
var array1 = str4.split(",");
//Split the string into an array
var array0a = new Array(13)
for (i = 0; i < 6; i++) {
array0a [i] = array1 [i*2];
array0a [i+7] = array1 [1+(i*2)];
}
//Create array with Title and Value
var array1a = new Array (7)
for (i = 0; i < count; i+7) {
array1a [0+i] = array1 [15+(i*7)];
array1a [1+i] = array1 [17+(i*7)];
array1a [2+i] = array1 [19+(i*7)];
array1a [3+i] = array1 [21+(i*7)];
array1a [4+i] = array1 [23+(i*7)];
array1a [5+i] = array1 [25+(i*7)];
array1a [6+i] = array1 [27+(i*7)];
}
//Create arrays with Values
var array2d = new Array(7)
for (i = 0; i <count; i++){
array2d[i] = new Array(7)
}
for (i = 0; i <1; i++){
array2d[i][0] = array0a[(i*7)];
array2d[i][1] = array0a[(i*7)+1];
array2d[i][2] = array0a[(i*7)+2];
array2d[i][3] = array0a[(i*7)+3];
array2d[i][4] = array0a[(i*7)+4];
array2d[i][5] = array0a[(i*7)+5];
array2d[i][6] = array0a[(i*7)+6];
}
//Add titles and value to 2D Array
for (i = 2; i <count; i++) {
array2d[i][0] = array1a [(i*7)-14];
array2d[i][1] = array1a [(i*7)-13];
array2d[i][2] = array1a [(i*7)-12];
array2d[i][3] = array1a [(i*7)-11];
array2d[i][4] = array1a [(i*7)-10];
array2d[i][5] = array1a [(i*7)-9];
array2d[i][6] = array1a [(i*7)-8];
}
//Finish 2D Array by adding all values
return array2d;
//Returns the new 2D Array
Meant to produce a 2D array of values with headers.
function VarTitle(input) {
var count = input.length; //count of array rows
var str = toString(input);
var str1 = str.replace(/{/g,"");
var str2 = str1.replace(/}/g,"");
var str3 = str2.replace(/'/g,"");
//Remove "{" , "}" , and "'" from the string
var str4 = str3.replace(/:/g,",");
//Replace ':' with "," to split the number variables in the string
var array1 = str4.split(",");
//Split the string into an array
var array0a = new Array(13)
for (i = 0; i < 6; i++) {
array0a [i] = array1 [i*2];
array0a [i+7] = array1 [1+(i*2)];
}
//Create array with Title and Value
var array1a = new Array (7)
for (i = 0; i < count; i+7) {
array1a [0+i] = array1 [15+(i*7)];
array1a [1+i] = array1 [17+(i*7)];
array1a [2+i] = array1 [19+(i*7)];
array1a [3+i] = array1 [21+(i*7)];
array1a [4+i] = array1 [23+(i*7)];
array1a [5+i] = array1 [25+(i*7)];
array1a [6+i] = array1 [27+(i*7)];
}
//Create arrays with Values
var array2d = new Array(7)
for (i = 0; i <count; i++){
array2d[i] = new Array(7)
}
for (i = 0; i <1; i++){
array2d[i][0] = array0a[(i*7)];
array2d[i][1] = array0a[(i*7)+1];
array2d[i][2] = array0a[(i*7)+2];
array2d[i][3] = array0a[(i*7)+3];
array2d[i][4] = array0a[(i*7)+4];
array2d[i][5] = array0a[(i*7)+5];
array2d[i][6] = array0a[(i*7)+6];
}
//Add titles and value to 2D Array
for (i = 2; i <count; i++) {
array2d[i][0] = array1a [(i*7)-14];
array2d[i][1] = array1a [(i*7)-13];
array2d[i][2] = array1a [(i*7)-12];
array2d[i][3] = array1a [(i*7)-11];
array2d[i][4] = array1a [(i*7)-10];
array2d[i][5] = array1a [(i*7)-9];
array2d[i][6] = array1a [(i*7)-8];
}
//Finish 2D Array by adding all values
return array2d;
//Returns the new 2D Array
Meant to produce a 2D array of values with headers.
si...@gmail.com <si...@gmail.com> #28
Happened to me with some variation, If I run my custom function for array with more then 18 elements in it - I'm getting internal error - http://prntscr.com/j60kxb
Any suggestions?
Any suggestions?
[Deleted User] <[Deleted User]> #29
This is happening for me, and yet when I duplicate my entire sheet with the same custom functions they work fine in the duplicate. The issue seems to be tied to a specific sheet. Anyone else experiencing this?
ra...@nomad.systems <ra...@nomad.systems> #30
Is happening to me now! Not sure what is causing it.
al...@apps4gs.com <al...@apps4gs.com> #31
+1
oh...@gmail.com <oh...@gmail.com> #32
+1
na...@apps4gs.com <na...@apps4gs.com> #33
More than 15 random people have reported the same problem to us
ki...@familyfreshfoodservice.com <ki...@familyfreshfoodservice.com> #34
Custom functions is failing to load/work properly. It seemed to be fixed last week, but it is back to not working! Please FIX!!!! Thank you!
ma...@roche.com <ma...@roche.com> #35
Comment has been deleted.
da...@richinsight.co.uk <da...@richinsight.co.uk> #36
+1
Here's the solution we've found:
Exponential backoff + automatic recalculation of cell
```
async function myFunction(params) {
let result = -1
for (let i = 0; i<10; i++){
try {
let response = await UrlFetchApp.fetch("MY URL");
result = await response.getContentText()
if (result >= 0) {return result}
} catch(err) {
await setTimeout(r, 1000*i);
}
}
return err.message
}
```
https://developers.google.com/sheets/api/limits
https://spreadsheetpoint.com/auto-refresh-google-sheets/
Here's the solution we've found:
Exponential backoff + automatic recalculation of cell
```
async function myFunction(params) {
let result = -1
for (let i = 0; i<10; i++){
try {
let response = await UrlFetchApp.fetch("MY URL");
result = await response.getContentText()
if (result >= 0) {return result}
} catch(err) {
await setTimeout(r, 1000*i);
}
}
return err.message
}
```
Description
Google Scripts no longer works for me.
Example 1: Drag down a fun "hello world" function and you'll see a bunch of #ERROR.
Example 2: Drag down a function that makes a URLFetch and you'll see all #ERROR.
If I run a custom function in one cell, it's likely to work. But as soon as I drag, #ERROR.
See example:
Really looking forward to the help. I have thousands of users of my script running into this problem. Thank you!