Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

"We're sorry, a server error occurred. Please wait a bit and try again" error when running a function from a custom menu

I have received 341 error notification emails for the below error

We're sorry, a server error occurred. Please wait a bit and try again.

The notification email only tells about the name of function in which the issue is occurring.

The script is not running now. Any try to run any function in the script gave the above error. Also my custom menu that i have added into the Spreadsheet using the script is gone. I found no way to debug the script as every action on the script giving me the above error.


Below is the function in which error is coming

function crunchEmails() {   var sheet   = SpreadsheetApp.getActiveSheet();   var gLabel  = sheet.getRange("gmailLabel").getValues();           // check the current SpreadSheet for limits and create a    // new SpreadSheet if limits are approaching   checkSpreadSheet();         var gFolder = sheet.getRange("outputFolderName").getValues();   var gSpreadSheetName = sheet.getRange("outputSpreadsheetPrefix").getValues();   var threadsPerSearch  = sheet.getRange("threadsPerSearch").getValues();     // Number of emails per search:   var threads = GmailApp.search("-label:" + gLabel, 0, threadsPerSearch);       for (var x=0; x<threads.length; x++) {              var messages = threads[x].getMessages();          // getting null...a thread without messages is weird     if(messages != null) {      for (var y=0; y<messages.length; y++) {                  updateSpreadSheet(messages[y]);               }     }         GmailApp.getUserLabelByName(gLabel).addToThread(threads[x]);   } } 

I am stuck in the middle of nowhere, have no clue about why this is happening?

Could anyone please guide to resolve the issue?

like image 624
MA1 Avatar asked Sep 14 '13 17:09

MA1


2 Answers

Problem Solved.

The problem is with string replace function in some other function. I am using the string replace function with regular expression as input to replace function. The regular expression was incorrect due which i am getting the above error.

That's really weird, at least GAS should give some proper error.

like image 135
MA1 Avatar answered Sep 20 '22 06:09

MA1


  • In the script -> Resources -> Advanced google services -> turn on Drive API
  • Click in below message " Google Cloud Platform API Dashboard" to open thee cloud project for the script.
  • With the project selected, search in the search bar "Drive API" -> ENABLE, do the same for "Google Drive API".

Done, no more "we're are sorry server error" for DriveApp functions in the script.

like image 29
Hemaka Raveen Avatar answered Sep 19 '22 06:09

Hemaka Raveen