ODK Aggregate to Fusion Tables error

Hi, Using version ODK Aggregate 0.9.6, I'm trying to Create
Connection to External Service to Fusion Tables. I'm "Upload Existing
Submission Data ONLY" and every time I get this error:

Uncaught exception from servlet
java.net.SocketTimeoutException: Timeout while fetching:
http://tables.googlelabs.com/api/query
at
com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationException(URLFetchServiceImpl.java:
117)
at
com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchServiceImpl.java:
42)
at
org.opendatakit.http.conn.GaeManagedClientConnection.flush(GaeManagedClientConnection.java:
310)
at
org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecutor.java:
252)
at
org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.java:
124)
at
org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:
483)
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:
641)
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:
576)
at
org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:
554)
at
org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTableOAuth.java:
164)
at
org.odk.aggregate.table.SubmissionFusionTable.insertNewDataOAuth(SubmissionFusionTable.java:
178)
at
org.odk.aggregate.table.SubmissionFusionTable.uploadSubmissionDataToSpreadsheet(SubmissionFusionTable.java:
101)
at
org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java:
169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)
at
com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java:
97)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
35)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:
43)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
418)
at
com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
249)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:923)
at
com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
76)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:
135)
at
com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java:
262)
at com.google.apphosting.base.RuntimePb$EvaluationRuntime
$2.handleRequest(RuntimePb.java:9819)
at com.google.net.rpc.impl.RpcUtil.handleRequest(RpcUtil.java:445)
at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java:
414)
at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java:
579)
at com.google.tracing.TraceContext$TraceContextRunnable
$1.run(TraceContext.java:454)
at com.google.tracing.TraceContext.runInContext(TraceContext.java:
694)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:
332)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:
324)
at com.google.tracing.TraceContext
$TraceContextRunnable.run(TraceContext.java:452)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:
1110)
at java.util.concurrent.ThreadPoolExecutor
$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)

I'm using a portable version of Google Chrome (ver. 13.0.782.112)

 My ODK Build XML file is:
  • Date Sample Taken
  • Inspector
  • Greg Pommen
  • Brittany Hogaboam
  • Kerilynn Mercier
  • Peter Daly
  • Quadrant
  • NE
  • NW
  • SE
  • SW
  • Section
  • GPS Point
  • Photo of water source
  • Treatment
  • pre-treatment
  • post-treatment
  • unsure
  • Water Body Size
  • Width (m)
  • Length (m)
  • Depth (cm)
  • Water Body Type
  • Temp
  • Semi-perm
  • Perm
  • Ditch
  • # of Dips
  • Avg # of 1st instars
  • Avg # of 2nd instars
  • Avg # of 3rd instars
  • Avg # of 4th instars
  • Avg # of Pupae
  • Notes





  • <bind nodeset="/data/Notes" type="string" constraint="(regex(., "^.
    {1,90}$"))" />

    </h:head>

    • <h:body>
    • gregpommen
    • brittanyhogaboam
    • kerilynnmercier
    • peterdaly
    • NE
    • NW
    • SE
    • SW
    • pre-treatment
    • post-treatment
    • unsure
    • temp
    • semi
    • perm
    • ditch

    Any ideas, Thank you, Greg

I am getting the same thing. It started this week.

··· On Aug 25, 1:33 pm, Greg Pommen wrote: > Hi, Using version ODK Aggregate 0.9.6, I'm trying to Create > Connection to External Service to Fusion Tables. I'm "Upload Existing > Submission Data ONLY" and every time I get this error: > > Uncaught exception from servlet > java.net.SocketTimeoutException: Timeout while fetching:http://tables.googlelabs.com/api/query > at > com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationExc eption(URLFetchServiceImpl.java: > 117) > at > com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchService Impl.java: > 42) > at > org.opendatakit.http.conn.GaeManagedClientConnection.flush(GaeManagedClient Connection.java: > 310) > at > org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecu tor.java: > 252) > at > org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.ja va: > 124) > at > org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDi rector.java: > 483) > at > org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > 641) > at > org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > 576) > at > org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > 554) > at > org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTa bleOAuth.java: > 164) > at > org.odk.aggregate.table.SubmissionFusionTable.insertNewDataOAuth(Submission FusionTable.java: > 178) > at > org.odk.aggregate.table.SubmissionFusionTable.uploadSubmissionDataToSpreads heet(SubmissionFusionTable.java: > 101) > at > org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java: > 169) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > 511) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1166) > at > com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlo bUploadFilter.java: > 97) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionF ilter.java: > 35) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(Trans actionCleanupFilter.java: > 43) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > 388) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > 216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > 182) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > 765) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > 418) > at > com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionH andlerMap.java: > 249) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > 152) > at org.mortbay.jetty.Server.handle(Server.java:326) > at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > 542) > at org.mortbay.jetty.HttpConnection > $RequestHandler.headerComplete(HttpConnection.java:923) > at > com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequ estParser.java: > 76) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceReques t(JettyServletEngineAdapter.java: > 135) > at > com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java: > 262) > at com.google.apphosting.base.RuntimePb$EvaluationRuntime > $2.handleRequest(RuntimePb.java:9819) > at com.google.net.rpc.impl.RpcUtil.handleRequest(RpcUtil.java:445) > at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java: > 414) > at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java: > 579) > at com.google.tracing.TraceContext$TraceContextRunnable > $1.run(TraceContext.java:454) > at com.google.tracing.TraceContext.runInContext(TraceContext.java: > 694) > at com.google.tracing.TraceContext > $AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.jav a: > 332) > at com.google.tracing.TraceContext > $AbstractTraceContextCallback.runInInheritedContext(TraceContext.java: > 324) > at com.google.tracing.TraceContext > $TraceContextRunnable.run(TraceContext.java:452) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java: > 1110) > at java.util.concurrent.ThreadPoolExecutor > $Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:636) > > I'm using a portable version of Google Chrome (ver. 13.0.782.112) > > My ODK Build XML file is: > > - xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:jr="http:// > openrosa.org/javarosa"> > - > MosqForm-current > - > - > - > > > > > > > > + > > > > > > > > > > > > > > > - > - > - > Date Sample Taken > > - > > > - > Inspector > > - > > > - > Greg Pommen > > - > Brittany Hogaboam > > - > Kerilynn Mercier > > - > Peter Daly > > - > Quadrant > > - > > > - > NE > > - > NW > > - > SE > > - > SW > > - > Section > > - > > > - > GPS Point > > - > > > - > Photo of water source > > - > > > - > Treatment > > - > > > - > pre-treatment > > - > post-treatment > > - > unsure > > - > Water Body Size > > - > Width (m) > > - > > > - > Length (m) > > - > > > - > Depth (cm) > > - > > > - > Water Body Type > > - > > > - > Temp > > - > Semi-perm > > - > Perm > > - > Ditch > > - > # of Dips > > - > > > - > Avg # of 1st instars > > - > > > - > Avg # of 2nd instars > > - > > > - > Avg # of 3rd instars > > - > > > - > Avg # of 4th instars > > - > > > - > Avg # of Pupae > > - > > > - > Notes > > - > > > > > > > > > > > > > > > > > > > > > > {1,90}$"))" /> > > > - > - > > > > - > > > - > > gregpommen > > - > > brittanyhogaboam > > - > > kerilynnmercier > > - > > peterdaly > > > - > > > - > > NE > > - > > NW > > - > > SE > > - > > SW > > > - > > > > - > > > > - > > > > - > > > - > > pre-treatment > > - > > post-treatment > > - > > unsure > > > - > > - > > > > - > > > > - > > > > > - > > > - > > temp > > - > > semi > > - > > perm > > - > > ditch > > > - > > > > - > > > > - > > > > - > > > > - > > > > - > > > > - > > > > > > > Any ideas, Thank you, Greg

Have you upgraded to Aggregate 0.9.7? We did this to improve the
timeouts because of some changes to fusion tables.

Additionally there are timeouts if you are moving an extremely large
amounts of data that will be solved in Aggregate 1.0 when released.
Originally when Aggregate 0.9.x was written App engine had no concept
of a background task, this has changed and Aggregate 1.x takes
advantage of this new functionality.

Waylon

··· On Thu, Sep 1, 2011 at 1:39 PM, Alex Pavluck wrote: > I am getting the same thing. It started this week. > > > > On Aug 25, 1:33 pm, Greg Pommen wrote: >> Hi, Using version ODK Aggregate 0.9.6, I'm trying to Create >> Connection to External Service to Fusion Tables. I'm "Upload Existing >> Submission Data ONLY" and every time I get this error: >> >> Uncaught exception from servlet >> java.net.SocketTimeoutException: Timeout while fetching:http://tables.googlelabs.com/api/query >> at >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationExc eption(URLFetchServiceImpl.java: >> 117) >> at >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchService Impl.java: >> 42) >> at >> org.opendatakit.http.conn.GaeManagedClientConnection.flush(GaeManagedClient Connection.java: >> 310) >> at >> org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecu tor.java: >> 252) >> at >> org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.ja va: >> 124) >> at >> org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDi rector.java: >> 483) >> at >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> 641) >> at >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> 576) >> at >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> 554) >> at >> org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTa bleOAuth.java: >> 164) >> at >> org.odk.aggregate.table.SubmissionFusionTable.insertNewDataOAuth(Submission FusionTable.java: >> 178) >> at >> org.odk.aggregate.table.SubmissionFusionTable.uploadSubmissionDataToSpreads heet(SubmissionFusionTable.java: >> 101) >> at >> org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java: >> 169) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: >> 511) >> at org.mortbay.jetty.servlet.ServletHandler >> $CachedChain.doFilter(ServletHandler.java:1166) >> at >> com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlo bUploadFilter.java: >> 97) >> at org.mortbay.jetty.servlet.ServletHandler >> $CachedChain.doFilter(ServletHandler.java:1157) >> at >> com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionF ilter.java: >> 35) >> at org.mortbay.jetty.servlet.ServletHandler >> $CachedChain.doFilter(ServletHandler.java:1157) >> at >> com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(Trans actionCleanupFilter.java: >> 43) >> at org.mortbay.jetty.servlet.ServletHandler >> $CachedChain.doFilter(ServletHandler.java:1157) >> at >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: >> 388) >> at >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: >> 216) >> at >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: >> 182) >> at >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: >> 765) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: >> 418) >> at >> com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionH andlerMap.java: >> 249) >> at >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: >> 152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: >> 542) >> at org.mortbay.jetty.HttpConnection >> $RequestHandler.headerComplete(HttpConnection.java:923) >> at >> com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequ estParser.java: >> 76) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at >> com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceReques t(JettyServletEngineAdapter.java: >> 135) >> at >> com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java: >> 262) >> at com.google.apphosting.base.RuntimePb$EvaluationRuntime >> $2.handleRequest(RuntimePb.java:9819) >> at com.google.net.rpc.impl.RpcUtil.handleRequest(RpcUtil.java:445) >> at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java: >> 414) >> at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java: >> 579) >> at com.google.tracing.TraceContext$TraceContextRunnable >> $1.run(TraceContext.java:454) >> at com.google.tracing.TraceContext.runInContext(TraceContext.java: >> 694) >> at com.google.tracing.TraceContext >> $AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.jav a: >> 332) >> at com.google.tracing.TraceContext >> $AbstractTraceContextCallback.runInInheritedContext(TraceContext.java: >> 324) >> at com.google.tracing.TraceContext >> $TraceContextRunnable.run(TraceContext.java:452) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java: >> 1110) >> at java.util.concurrent.ThreadPoolExecutor >> $Worker.run(ThreadPoolExecutor.java:603) >> at java.lang.Thread.run(Thread.java:636) >> >> I'm using a portable version of Google Chrome (ver. 13.0.782.112) >> >> My ODK Build XML file is: >> >> - > xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:jr="http:// >> openrosa.org/javarosa"> >> - >> MosqForm-current >> - >> - >> - >> >> >> >> >> >> >> >> + >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> - >> - >> - >> Date Sample Taken >> >> - >> >> >> - >> Inspector >> >> - >> >> >> - >> Greg Pommen >> >> - >> Brittany Hogaboam >> >> - >> Kerilynn Mercier >> >> - >> Peter Daly >> >> - >> Quadrant >> >> - >> >> >> - >> NE >> >> - >> NW >> >> - >> SE >> >> - >> SW >> >> - >> Section >> >> - >> >> >> - >> GPS Point >> >> - >> >> >> - >> Photo of water source >> >> - >> >> >> - >> Treatment >> >> - >> >> >> - >> pre-treatment >> >> - >> post-treatment >> >> - >> unsure >> >> - >> Water Body Size >> >> - >> Width (m) >> >> - >> >> >> - >> Length (m) >> >> - >> >> >> - >> Depth (cm) >> >> - >> >> >> - >> Water Body Type >> >> - >> >> >> - >> Temp >> >> - >> Semi-perm >> >> - >> Perm >> >> - >> Ditch >> >> - >> # of Dips >> >> - >> >> >> - >> Avg # of 1st instars >> >> - >> >> >> - >> Avg # of 2nd instars >> >> - >> >> >> - >> Avg # of 3rd instars >> >> - >> >> >> - >> Avg # of 4th instars >> >> - >> >> >> - >> Avg # of Pupae >> >> - >> >> >> - >> Notes >> >> - >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > {1,90}$"))" /> >> >> >> - >> - >> >> >> >> - >> >> >> - >> >> gregpommen >> >> - >> >> brittanyhogaboam >> >> - >> >> kerilynnmercier >> >> - >> >> peterdaly >> >> >> - >> >> >> - >> >> NE >> >> - >> >> NW >> >> - >> >> SE >> >> - >> >> SW >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> - >> >> pre-treatment >> >> - >> >> post-treatment >> >> - >> >> unsure >> >> >> - >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> >> - >> >> >> - >> >> temp >> >> - >> >> semi >> >> - >> >> perm >> >> - >> >> ditch >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> - >> >> >> >> >> >> >> Any ideas, Thank you, Greg > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >

Can I upgrade when data is being actively collected?

··· On Sep 1, 6:01 pm, "W. Brunette" wrote: > Have you upgraded to Aggregate 0.9.7? We did this to improve the > timeouts because of some changes to fusion tables. > > Additionally there are timeouts if you are moving an extremely large > amounts of data that will be solved in Aggregate 1.0 when released. > Originally when Aggregate 0.9.x was written App engine had no concept > of a background task, this has changed and Aggregate 1.x takes > advantage of this new functionality. > > Waylon > > > > > > > > On Thu, Sep 1, 2011 at 1:39 PM, Alex Pavluck wrote: > > I am getting the same thing. It started this week. > > > On Aug 25, 1:33 pm, Greg Pommen wrote: > >> Hi, Using version ODK Aggregate 0.9.6, I'm trying to Create > >> Connection to External Service to Fusion Tables. I'm "Upload Existing > >> Submission Data ONLY" and every time I get this error: > > >> Uncaught exception from servlet > >> java.net.SocketTimeoutException: Timeout while fetching:http://tables.googlelabs.com/api/query > >> at > >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationExc eption(URLFetchServiceImpl.java: > >> 117) > >> at > >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchService Impl.java: > >> 42) > >> at > >> org.opendatakit.http.conn.GaeManagedClientConnection.flush(GaeManagedClient Connection.java: > >> 310) > >> at > >> org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecu tor.java: > >> 252) > >> at > >> org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.ja va: > >> 124) > >> at > >> org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDi rector.java: > >> 483) > >> at > >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > >> 641) > >> at > >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > >> 576) > >> at > >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: > >> 554) > >> at > >> org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTa bleOAuth.java: > >> 164) > >> at > >> org.odk.aggregate.table.SubmissionFusionTable.insertNewDataOAuth(Submission FusionTable.java: > >> 178) > >> at > >> org.odk.aggregate.table.SubmissionFusionTable.uploadSubmissionDataToSpreads heet(SubmissionFusionTable.java: > >> 101) > >> at > >> org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java: > >> 169) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > >> 511) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1166) > >> at > >> com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlo bUploadFilter.java: > >> 97) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionF ilter.java: > >> 35) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(Trans actionCleanupFilter.java: > >> 43) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > >> 388) > >> at > >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > >> 216) > >> at > >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > >> 182) > >> at > >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > >> 765) > >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > >> 418) > >> at > >> com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionH andlerMap.java: > >> 249) > >> at > >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > >> 152) > >> at org.mortbay.jetty.Server.handle(Server.java:326) > >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > >> 542) > >> at org.mortbay.jetty.HttpConnection > >> $RequestHandler.headerComplete(HttpConnection.java:923) > >> at > >> com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequ estParser.java: > >> 76) > >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > >> at > >> com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceReques t(JettyServletEngineAdapter.java: > >> 135) > >> at > >> com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java: > >> 262) > >> at com.google.apphosting.base.RuntimePb$EvaluationRuntime > >> $2.handleRequest(RuntimePb.java:9819) > >> at com.google.net.rpc.impl.RpcUtil.handleRequest(RpcUtil.java:445) > >> at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java: > >> 414) > >> at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java: > >> 579) > >> at com.google.tracing.TraceContext$TraceContextRunnable > >> $1.run(TraceContext.java:454) > >> at com.google.tracing.TraceContext.runInContext(TraceContext.java: > >> 694) > >> at com.google.tracing.TraceContext > >> $AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.jav a: > >> 332) > >> at com.google.tracing.TraceContext > >> $AbstractTraceContextCallback.runInInheritedContext(TraceContext.java: > >> 324) > >> at com.google.tracing.TraceContext > >> $TraceContextRunnable.run(TraceContext.java:452) > >> at > >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java: > >> 1110) > >> at java.util.concurrent.ThreadPoolExecutor > >> $Worker.run(ThreadPoolExecutor.java:603) > >> at java.lang.Thread.run(Thread.java:636) > > >> I'm using a portable version of Google Chrome (ver. 13.0.782.112) > > >> My ODK Build XML file is: > > >> - >> xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:jr="http:// > >> openrosa.org/javarosa"> > >> - > >> MosqForm-current > >> - > >> - > >> - > >> > >> > >> > >> > >> > >> > >> > >> + > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> - > >> - > >> - > >> Date Sample Taken > >> > >> - > >> > >> > >> - > >> Inspector > >> > >> - > >> > >> > >> - > >> Greg Pommen > >> > >> - > >> Brittany Hogaboam > >> > >> - > >> Kerilynn Mercier > >> > >> - > >> Peter Daly > >> > >> - > >> Quadrant > >> > >> - > >> > >> > >> - > >> NE > >> > >> - > >> NW > >> > >> - > >> SE > >> > >> - > >> SW > >> > >> - > >> Section > >> > >> - > >> > >> > >> - > >> GPS Point > >> > >> - > >> > >> > >> - > >> Photo of water source > >> > >> - > >> > >> > >> - > >> Treatment > >> > >> - > >> > >> > >> - > >> pre-treatment > >> > >> - > >> post-treatment > >> > >> - > >> unsure > >> > >> - > >> Water Body Size > >> > >> - > >> Width (m) > >> > >> - > >> > >> > >> - > >> Length (m) > >> > >> - > >> > >> > >> - > >> Depth (cm) > >> > >> - > >> > >> > >> - > >> Water Body Type > >> > >> - > >> > >> > >> - > >> Temp > >> > >> - > >> Semi-perm > >> > >> - > ... > > read more »

In theory yes you can upgrade from 0.9.6 to 0.9.7 as there should be
very minimal interaction problems.

You can NOT upgrade to 1.0, it's a completely different database
structure. We are preparing a tool to do this after we release 1.0.
Right now 1.0 is in beta.

Waylon

··· On Thu, Sep 1, 2011 at 6:28 PM, Alex Pavluck wrote: > Can I upgrade when data is being actively collected? > > On Sep 1, 6:01 pm, "W. Brunette" wrote: >> Have you upgraded to Aggregate 0.9.7? We did this to improve the >> timeouts because of some changes to fusion tables. >> >> Additionally there are timeouts if you are moving an extremely large >> amounts of data that will be solved in Aggregate 1.0 when released. >> Originally when Aggregate 0.9.x was written App engine had no concept >> of a background task, this has changed and Aggregate 1.x takes >> advantage of this new functionality. >> >> Waylon >> >> >> >> >> >> >> >> On Thu, Sep 1, 2011 at 1:39 PM, Alex Pavluck wrote: >> > I am getting the same thing. It started this week. >> >> > On Aug 25, 1:33 pm, Greg Pommen wrote: >> >> Hi, Using version ODK Aggregate 0.9.6, I'm trying to Create >> >> Connection to External Service to Fusion Tables. I'm "Upload Existing >> >> Submission Data ONLY" and every time I get this error: >> >> >> Uncaught exception from servlet >> >> java.net.SocketTimeoutException: Timeout while fetching:http://tables.googlelabs.com/api/query >> >> at >> >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationExc eption(URLFetchServiceImpl.java: >> >> 117) >> >> at >> >> com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchService Impl.java: >> >> 42) >> >> at >> >> org.opendatakit.http.conn.GaeManagedClientConnection.flush(GaeManagedClient Connection.java: >> >> 310) >> >> at >> >> org.apache.http.protocol.HttpRequestExecutor.doSendRequest(HttpRequestExecu tor.java: >> >> 252) >> >> at >> >> org.apache.http.protocol.HttpRequestExecutor.execute(HttpRequestExecutor.ja va: >> >> 124) >> >> at >> >> org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDi rector.java: >> >> 483) >> >> at >> >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> >> 641) >> >> at >> >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> >> 576) >> >> at >> >> org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.j ava: >> >> 554) >> >> at >> >> org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTa bleOAuth.java: >> >> 164) >> >> at >> >> org.odk.aggregate.table.SubmissionFusionTable.insertNewDataOAuth(Submission FusionTable.java: >> >> 178) >> >> at >> >> org.odk.aggregate.table.SubmissionFusionTable.uploadSubmissionDataToSpreads heet(SubmissionFusionTable.java: >> >> 101) >> >> at >> >> org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java: >> >> 169) >> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: >> >> 511) >> >> at org.mortbay.jetty.servlet.ServletHandler >> >> $CachedChain.doFilter(ServletHandler.java:1166) >> >> at >> >> com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlo bUploadFilter.java: >> >> 97) >> >> at org.mortbay.jetty.servlet.ServletHandler >> >> $CachedChain.doFilter(ServletHandler.java:1157) >> >> at >> >> com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionF ilter.java: >> >> 35) >> >> at org.mortbay.jetty.servlet.ServletHandler >> >> $CachedChain.doFilter(ServletHandler.java:1157) >> >> at >> >> com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(Trans actionCleanupFilter.java: >> >> 43) >> >> at org.mortbay.jetty.servlet.ServletHandler >> >> $CachedChain.doFilter(ServletHandler.java:1157) >> >> at >> >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: >> >> 388) >> >> at >> >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: >> >> 216) >> >> at >> >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: >> >> 182) >> >> at >> >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: >> >> 765) >> >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: >> >> 418) >> >> at >> >> com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionH andlerMap.java: >> >> 249) >> >> at >> >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: >> >> 152) >> >> at org.mortbay.jetty.Server.handle(Server.java:326) >> >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: >> >> 542) >> >> at org.mortbay.jetty.HttpConnection >> >> $RequestHandler.headerComplete(HttpConnection.java:923) >> >> at >> >> com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequ estParser.java: >> >> 76) >> >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> >> at >> >> com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceReques t(JettyServletEngineAdapter.java: >> >> 135) >> >> at >> >> com.google.apphosting.runtime.JavaRuntime.handleRequest(JavaRuntime.java: >> >> 262) >> >> at com.google.apphosting.base.RuntimePb$EvaluationRuntime >> >> $2.handleRequest(RuntimePb.java:9819) >> >> at com.google.net.rpc.impl.RpcUtil.handleRequest(RpcUtil.java:445) >> >> at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java: >> >> 414) >> >> at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java: >> >> 579) >> >> at com.google.tracing.TraceContext$TraceContextRunnable >> >> $1.run(TraceContext.java:454) >> >> at com.google.tracing.TraceContext.runInContext(TraceContext.java: >> >> 694) >> >> at com.google.tracing.TraceContext >> >> $AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.jav a: >> >> 332) >> >> at com.google.tracing.TraceContext >> >> $AbstractTraceContextCallback.runInInheritedContext(TraceContext.java: >> >> 324) >> >> at com.google.tracing.TraceContext >> >> $TraceContextRunnable.run(TraceContext.java:452) >> >> at >> >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java: >> >> 1110) >> >> at java.util.concurrent.ThreadPoolExecutor >> >> $Worker.run(ThreadPoolExecutor.java:603) >> >> at java.lang.Thread.run(Thread.java:636) >> >> >> I'm using a portable version of Google Chrome (ver. 13.0.782.112) >> >> >> My ODK Build XML file is: >> >> >> - > >> xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:jr="http:// >> >> openrosa.org/javarosa"> >> >> - >> >> MosqForm-current >> >> - >> >> - >> >> - >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> + >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> - >> >> - >> >> - >> >> Date Sample Taken >> >> >> >> - >> >> >> >> >> >> - >> >> Inspector >> >> >> >> - >> >> >> >> >> >> - >> >> Greg Pommen >> >> >> >> - >> >> Brittany Hogaboam >> >> >> >> - >> >> Kerilynn Mercier >> >> >> >> - >> >> Peter Daly >> >> >> >> - >> >> Quadrant >> >> >> >> - >> >> >> >> >> >> - >> >> NE >> >> >> >> - >> >> NW >> >> >> >> - >> >> SE >> >> >> >> - >> >> SW >> >> >> >> - >> >> Section >> >> >> >> - >> >> >> >> >> >> - >> >> GPS Point >> >> >> >> - >> >> >> >> >> >> - >> >> Photo of water source >> >> >> >> - >> >> >> >> >> >> - >> >> Treatment >> >> >> >> - >> >> >> >> >> >> - >> >> pre-treatment >> >> >> >> - >> >> post-treatment >> >> >> >> - >> >> unsure >> >> >> >> - >> >> Water Body Size >> >> >> >> - >> >> Width (m) >> >> >> >> - >> >> >> >> >> >> - >> >> Length (m) >> >> >> >> - >> >> >> >> >> >> - >> >> Depth (cm) >> >> >> >> - >> >> >> >> >> >> - >> >> Water Body Type >> >> >> >> - >> >> >> >> >> >> - >> >> Temp >> >> >> >> - >> >> Semi-perm >> >> >> >> - > >> ... >> >> read more » > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >