Databases
StackOverflow2013
Postsdbo
POUnexpected exception upon serializing continuation Google Apps Script
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnexpected exception upon serializing continuation Google Apps Script
    primarykey
    data
    text
    <p>I recently started getting the error "Unexpected exception upon serializing continuation" on a spreadsheet Google Apps Script when trying to debug. The error seem to start after I created a connection to the Google CloudSQL api. This error still occurs even after commenting out the jdbc object constructor. It appears that others have had this issue and needed a Google Tech to resolve the issue.</p> <p>I have searched all of the discussion boards for a solution to this issue with no luck. Any chance there is a Google tech out there who could take a look under the hood for me? I would post code if I could determine what line was actually triggering the error.</p> <p>EDIT:</p> <p>Ok, I think I have discovered where the error is occuring. Seems to be the</p> <pre><code>var response = UrlFetchApp.fetch(url + nextPage,oauth_options); </code></pre> <p>in the while loop. Here is the entire function code.</p> <pre><code>function retrieveEvents(endTimeMinimum, updatedAfter, orderBy){ //var url = 'https://www.googleapis.com/calendar/v3/calendars/' + source_cal + '/events?key=' + api_key + "&amp;futureevents=true&amp;orderBy=updated&amp;sortOrder=descending&amp;updatedMin=" + last_sync_date_formated; //var url = 'https://www.googleapis.com/calendar/v3/calendars/' + source_cal + '/events?key=' + api_key + "&amp;orderBy=updated&amp;sortOrder=descending&amp;updatedMin=" + last_sync_date_formated; var url = 'https://www.googleapis.com/calendar/v3/calendars/' + source_cal + '/events?key=' + api_key + "&amp;singleEvents=true"; if ((orderBy != null) &amp;&amp; (orderBy != "")){ url += "&amp;orderBy=" + orderBy; } else url += "&amp;orderBy=updated"; if ((updatedAfter != null) &amp;&amp; (updatedAfter != "")){ url += "&amp;updatedMin=" + updatedAfter; } else url += "&amp;updatedMin=" + last_sync_dateTime; //if no endTimeMinimum is specified, the current time will be used. if (endTimeMinimum == null || endTimeMinimum == ""){ endTimeMinimum = date_rfc339("Today"); } url += "&amp;timeMin=" + endTimeMinimum; Logger.log("Request URL:" + url); var largeString = ""; var events = new Array(); var nextPage = ""; var jsonObj while(true){ var response = UrlFetchApp.fetch(url + nextPage,oauth_options); largeString = response.getContentText(); if ((largeString != null) &amp;&amp; (largeString != "")) { jsonObj = JSON.parse(largeString); } if ('items' in jsonObj) events = events.concat(jsonObj.items); if ('nextPageToken' in jsonObj){ nextPage = "&amp;pageToken=" + jsonObj.nextPageToken; continue; } break; } if (events.length == 0)return null; return events; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2085215
    1. USuser2085215
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI assume you've seen this question? http://stackoverflow.com/questions/10954075/unexpected-exception-upon-serializing-continuation It looks like you need to trigger the authorization popup because your script may not be currently authorized.
      singulars
      1. POUnexpected exception upon serializing continuation Google Apps Script
      1. USPhil Bozak
    2. COHi Phil. Yes, I have seen that thread. I was able to remove the urlfetchapp.fetch call from the list of culprits, (Or atleast I am able to get past that line of code and have the error popup elsewhere.)
      singulars
      1. POUnexpected exception upon serializing continuation Google Apps Script
      1. USuser2085215
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload