Dear all,
Any help that can be offered would be much appreciated. When I try
to set up an ODK Aggregate (v.0.95) connection to Google Fusion
tables, the error below is returned. I've tried shortening field
names, changing survey IDs, and nothing seems to help. ODK can set
up a connection to Google Spreadsheets, but no data are transmitted
other than submission times.
What is the problem? The XML is attached for reference.
Thanks in advance.
Best,
David
Uncaught exception from servlet
java.net.MalformedURLException: Invalid URL:
http://tables.googlelabs.com/api/query?sql=CREATE+TABLE+'AdoptionSurvey'+('RBPsourcetechnologyintroduction'%3Astring%2C'NCarea'%3Anumber%2C'surveyordetailscollectortype'%3Astring%2C'IIWMirrigationfrequency'%3Astring%2C'locationfieldslocationtype'%3Astring%2C'DSRsourcetechnologyintroduction'%3Astring%2C'IIWMguide'%3Astring%2C'village'%3Astring%2C'IWMstaleseedbed'%3Astring%2C'ICarea'%3Anumber%2C'locationAltitude'%3Alocation%2C'SPinitialyear'%3Astring%2C'ICinitialyear'%3Astring%2C'RBPwidth'%3Astring%2C'RTtype'%3Astring%2C'RBPresidueretentionpreviouscrop'%3Astring%2C'CSDintroducedcrop'%3Astring%2C'DSRirrigation'%3Astring%2C'preDSRpractice'%3Astring%2C'LLLarea'%3Anumber%2C'manuallatitude'%3Anumber%2C'RCsourcetechnologyintroduction'%3Astring%2C'INMliming'%3Astring%2C'IIWMcrop'%3Astring%2C'RTmaincroppingsystem'%3Astring%2C'RCmaincrops'%3Astring%2C'ICmaincroppingsystem'%3Astring%2C'INMothernutrients'%3Astring%2C'UPTRmaincroppingsystem'%3Astring%2C'comment'%3Astring%2C'IIWMinitialyear'%3Astring%2C'farmarea'%3Anumber%2C'IIWMsourcetechnologyintroduction'%3Astring%2C'LLLmaincroppingsystem'%3Astring%2C'ZTmaincroppingsystem'%3Astring%2C'IWMUPTR'%3Astring%2C'IPHSinitialyear'%3Astring%2C'RCmaincroppingsystem'%3Astring%2C'LLLZT'%3Astring%2C'ZTinitialyear'%3Astring%2C'IWMZT'%3Astring%2C'CSDreplacedcrop'%3Astring%2C'RBPtype'%3Astring%2C'DSRirrigationscheduling'%3Astring%2C'locationAccuracy'%3Alocation%2C'adoptedtechnologies'%3Astring%2C'IPHSstoragetype'%3Astring%2C'surveyordetailssurveymethod'%3Astring%2C'IWMherbicides'%3Astring%2C'INMarea'%3Anumber%2C'RBParea'%3Anumber%2C'district'%3Astring%2C'IWMotherweedmanagement'%3Astring%2C'IPHSstoragecapacity'%3Anumber%2C'IWMbrownmanuring'%3Astring%2C'SubmissionDate'%3Adatetime%2C'LLLRT'%3Astring%2C'CFpreviouscropfallowperiod'%3Astring%2C'DSRarea'%3Anumber%2C'IWMRT'%3Astring%2C'INMguide'%3Astring%2C'farmerdetailsnamefarmer'%3Astring%2C'INMnutrients'%3Astring%2C'IWMsourcetechnologyintroduction'%3Astring%2C'LLLsourcetechnologyintroduction'%3Astring%2C'RTsourcetechnologyintroduction'%3Astring%2C'telephone'%3Anumber%2C'NCsourcetechnologyintroduction'%3Astring%2C'SPcrop'%3Astring%2C'location'%3Alocation%2C'percentagefarmarearented'%3Astring%2C'ZTarea'%3Anumber%2C'INMNPKincrease'%3Astring%2C'RBPmaincroppingsystem'%3Astring%2C'CFseasonnewcrop'%3Astring%2C'IIWMchangedirrigationtiming'%3Astring%2C'IWMherbicideapplicationfrequency'%3Astring%2C'CFinitialyear'%3Astring%2C'DSRmethod'%3Astring%2C'ICintercrop'%3Astring%2C'ICmaincrops'%3Astring%2C'CSDmaincroppingsystem'%3Astring%2C'IWMarea'%3Anumber%2C'UPTRarea'%3Anumber%2C'IWMDSR'%3Astring%2C'RTarea'%3Anumber%2C'NColdvariety'%3Astring%2C'RCarea'%3Anumber%2C'IPHSsourcetechnologyintroduction'%3Astring%2C'NCinitialyear'%3Astring%2C'DSRinitialyear'%3Astring%2C'INMsplitnitrogenapplication'%3Astring%2C'UPTRRT'%3Astring%2C'NCDSR'%3Astring%2C'CSDarea'%3Anumber%2C'RBPcrop'%3Astring%2C'RCinitialyear'%3Astring%2C'UPTRZT'%3Astring%2C'ZTcrop'%3Astring%2C'IWMinitialyear'%3Astring%2C'IIWMDSR'%3Astring%2C'ICsourcetechnologyintroduction'%3Astring%2C'SPseedtreatment'%3Astring%2C'preUPTRpractice'%3Astring%2C'ZTresidueretentionpreviouscrop'%3Astring%2C'INMbandedfertilizerapplication'%3Astring%2C'IIWMarea'%3Anumber%2C'RTcrop'%3Astring%2C'LLLlastyear'%3Astring%2C'NCZT'%3Astring%2C'CFsourcetechnologyintroduction'%3Astring%2C'ZTsourcetechnologyintroduction'%3Astring%2C'IWMRBP'%3Astring%2C'INMNPKdecrease'%3Astring%2C'RTinitialyear'%3Astring%2C'CSDinitialyear'%3Astring%2C'farmerdetailsfarmergender'%3Astring%2C'RTpriortillagepasses'%3Anumber%2C'NCnewvariety'%3Astring%2C'DSRmaincroppingsystem'%3Astring%2C'UPTRLLL'%3Astring%2C'NCcrop'%3Astring%2C'INMureagranulesplacement'%3Astring%2C'ZTpriortillagepasses'%3Anumber%2C'DSRZT'%3Astring%2C'DSRLLL'%3Astring%2C'RBPinitialyear'%3Astring%2C'manuallongitude'%3Anumber%2C'RTnumbertillages'%3Anumber%2C'NCRT'%3Astring%2C'UPTRtransplantingtype'%3Astring%2C'UPTRsourcetechnologyintroduction'%3Astring%2C'UPTRinitialyear'%3Astring%2C'IIWMUPTR'%3Astring%2C'RTresidueretentionpreviouscrop'%3Astring%2C'DSRRT'%3Astring%2C'INMinitialyear'%3Astring%2C'CSDsourcetechnologyintroduction'%3Astring%2C'INMsourcetechnologyintroduction'%3Astring%2C'IWMcrop'%3Astring%2C'INMcrop'%3Astring)
at com.google.appengine.api.urlfetch.URLFetchServiceImpl.convertApplicationException(URLFetchServiceImpl.java:106)
at com.google.appengine.api.urlfetch.URLFetchServiceImpl.fetch(URLFetchServiceImpl.java:41)
at com.google.apphosting.utils.security.urlfetch.URLFetchServiceStreamHandler$Connection.fetchResponse(URLFetchServiceStreamHandler.java:418)
at com.google.apphosting.utils.security.urlfetch.URLFetchServiceStreamHandler$Connection.getInputStream(URLFetchServiceStreamHandler.java:297)
at org.odk.aggregate.form.remoteserver.FusionTableOAuth.executeInsert(FusionTableOAuth.java:149)
at org.odk.aggregate.servlet.FusionTableServlet.doGet(FusionTableServlet.java:140)
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:238)
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:261)
at com.google.apphosting.base.RuntimePb$EvaluationRuntime$2.handleRequest(RuntimePb.java:9285)
at com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java:437)
at com.google.net.rpc.impl.Server$RpcTask.runInContext(Server.java:573)
at com.google.tracing.TraceContext$TraceContextRunnable$1.run(TraceContext.java:448)
at com.google.tracing.TraceContext.runInContext(TraceContext.java:688)
at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:326)
at com.google.tracing.TraceContext$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:318)
adoption-survey.xml (102 KB)