Google Apps Script : 서버에 오류가 발생했습니다. 나중에 다시 시도

나는 갇혀있다 .. 오류가 @ 줄 63 및 때로는 50 줄에 throw됩니다. 둘 다 appendTableRow () 메서드를 사용합니다. 나는 잘못된 것을 찾을 수 없습니다.

row3.appendTableCell(entryDesc)

생성 된 파일 링크 : 링크

실행 기록 : 링크

나는 새롭기 때문에 "나쁜 관행"을 발견하면 자유롭게 손가락을 조준하십시오.

    // Import data from the Calendar to the timesheet document
    function importDataToTS (dateStart,dateFinish,doc) {
      if (!dateStart) {
        var dateStart = new Date('January 1, 2014');
      }
      var cal = CalendarApp.getCalendarById('[email protected]')
      var events = cal.getEvents(dateStart, dateFinish);
      var oldDate = new Date(dateStart.getFullYear(), dateStart.getMonth(), dateStart.getDate() - 1);
      var paragraph = "";
      var totalHoursWorked = 0

      // START --- Text element styles
      // Date
      var entryDateStyle = {};
        entryDateStyle[DocumentApp.Attribute.BOLD] = true;
        entryDateStyle[DocumentApp.Attribute.FONT_SIZE] = 18;
      // Title
      var entryTitleStyle = {};
        entryTitleStyle[DocumentApp.Attribute.FONT_SIZE] = 14;
      // entryTimes
      var entryTimesStyle = {};
        entryTimesStyle[DocumentApp.Attribute.BOLD] = true;
        entryTimesStyle[DocumentApp.Attribute.FONT_SIZE] = 12;
      // entryDescription
      var entryDescriptionStyle = {};
        entryDescriptionStyle[DocumentApp.Attribute.ITALIC] = true;
        entryDescriptionStyle[DocumentApp.Attribute.FONT_SIZE] = 10;
      // END --- Text element styles 
      var entriesTable = doc.appendTable();
      Logger.log(entriesTable.getType());

      for (var i = 0; i in events; i++) {
    var entryDate = events[i].getStartTime();
    if (i > 0) {
      oldDate = (events[i-1].getStartTime());
    }
    // If it's a new day add a full width cell
    if (entryDate.getDate() > oldDate.getDate()) {   
      var row1 = entriesTable.appendTableRow();
      row1.appendTableCell(shortDate(entryDate,4));
        //.setAttributes(entryDateStyle);
    }

    // Add title, start/end times & hours worked
     // Add title, start/end times & hours worked
    var entryTitle = events[i].getTitle();
    Logger.log(i + ": " + entryTitle);
    var entryTimes = shortTime(events[i].getStartTime(),2) + " - " + shortTime(events[i].getEndTime(),2);
    Logger.log(i + ": " + entryTimes);
    var entryHoursWorked = ((events[i].getEndTime() - events[i].getStartTime())/(1000*60*60)%24) + "hr(s)";
    Logger.log(i + ": " + entryHoursWorked);
    var row2 = entriesTable.appendTableRow();
    row2.appendTableCell(entryTitle);
      //.setAttributes(entryTitleStyle);
    row2.appendTableCell(entryTimes + "\t\t" + entryHoursWorked);
      //.setAttributes(entryTimesStyle);


    // Add entry description
    var entryDesc = (events[i].getDescription().length > 1) ? events[i].getDescription().toString() : "";

    if (entryDesc.length > 1) { 
      var row3 = entriesTable.appendTableRow();
      row3.appendTableCell();
      row3.appendTableCell(entryDesc);
        //.setAttributes(entryDescriptionStyle);
    }

    totalHoursWorked += entryHoursWorked;
    if (i === (events.length - 1)) {
      var lastRow = entriesTable.appendTableRow(); 
      lastRow.appendTableCell("Total Hours: " + totalHoursWorked);
    }
  }
  for (var i = 0; i in entriesTable; i++) { 
    for (var j = 0; j in entriesTable[i]; j++) {
      Logger.log(i + ":" + j + " " + entriesTable[i][j].toString());
    }
  }

      doc.appendTable(entriesTable);
    }

shortDate () && shorttTime ()

function shortDate(date,n) {
  // Returns a date object as "MMMDD";
    if (date) {
      switch (n) {
        case 1:
          //Jul6
          return Utilities.formatDate(date, "EST", "MMMdd")
          break;
        case 2:
          //Jul 6
          return Utilities.formatDate(date, "EST", "MMM dd")
          break;
        case 3:
          //July 6
          return Utilities.formatDate(date, "EST", "MMMM dd")
          break;
        case 4:
          return Utilities.formatDate(date, "EST", "EEE, MMM dd")
          break;
        default:
          //Full Date unchanged
          return date;
      }
    }
}

function shortTime(date) {
  //Returns time string formatted as "hh:mm"am/pm
  //Still needs to be updated with Utilities.formatDate
  if (date) {
    var hours = (date.getHours() > 12) ? (date.getHours() - 12) : date.getHours();
    var ampm = (date.getHours() > 12) ? "pm" : "am";
    var minutes = (date.getMinutes() == 0) ? "00" : date.getMinutes();
    var time = hours + ":" + minutes + ampm
    return time.toString();
  }
}