Error uploading to Fusion Tables

Support
1

Hi all,

I tried uploading data from our own instance of ODK Aggregate 1.0, on
Google AppEngine, to Fusion Tables, and getting an error message:

Unauthenticated access is allowed only for SELECT andDESCRIBE statements

Error 401

CREATE TABLE 'zambia-ranq-round3'(...)

Error: org.opendatakit.aggregate.exception.ODKExternalServiceException:
Unauthenticated access is allowed only for SELECT andDESCRIBE statements

Any ideas?

Cheers, Chris.

··· -- Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES

Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.

2

Sounds like your google token got messed up somehow. It could just be
a transient google problem. I would try again some time later and if
it occurs again file a bug. The access is controlled by Google and
Aggregate receives an authentication token to use when you go navigate
to google authorization page and select "allow".

Waylon

··· On Tue, Nov 8, 2011 at 9:56 AM, Chris Wilson wrote: > Hi all, > > I tried uploading data from our own instance of ODK Aggregate 1.0, on Google > AppEngine, to Fusion Tables, and getting an error message: > >> Unauthenticated access is allowed only for SELECT andDESCRIBE statements >> >> Error 401 >> >> CREATE TABLE 'zambia-ranq-round3'(...) >> >> Error: org.opendatakit.aggregate.exception.ODKExternalServiceException: >> Unauthenticated access is allowed only for SELECT andDESCRIBE statements > > Any ideas? > > Cheers, Chris. > -- > Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 > The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES > > Aptivate is a not-for-profit company registered in England and Wales > with company number 04980791. > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >
3

Hi Waylon,

Sounds like your google token got messed up somehow. It could just be
a transient google problem. I would try again some time later and if
it occurs again file a bug. The access is controlled by Google and
Aggregate receives an authentication token to use when you go navigate
to google authorization page and select "allow".

Thanks for the answer. I tried again today and it asked for permission
again, but failed in the same way immediately after.

Here is the authorization page that I saw just before that:

The site anonymous is requesting access to your Google Account for the
product(s) listed below.

Fusion Tables

Google is not affiliated with anonymous, and we recommend that you grant
access only if you trust the site.

If you grant access, you can revoke access at any time under 'My
Account'. anonymous will not have access to your password or any other
personal information from your Google Account. Learn more

This website has not registered with Google to establish a secure
connection for authorization requests. We recommend that you deny access
unless you trust the website.

Can you see anything wrong here?

Cheers, Chris.

··· On Tue, 8 Nov 2011, W. Brunette wrote: -- Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES

Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.

4

Chris,

I am sorry you are having an issue. I submitted an issue into our
tracking system
http://code.google.com/p/opendatakit/issues/detail?id=419.

If you don't mind please go to the issue link and create a comment
with more detail and upload a copy of your form into that issue so
that we can try to reproduce your problem exactly. Any additional
information you can add to the issue will make it easier to figure out
what your problem is.

Waylon

··· On Wed, Nov 9, 2011 at 7:24 AM, Chris Wilson wrote: > Hi Waylon, > > On Tue, 8 Nov 2011, W. Brunette wrote: > >> Sounds like your google token got messed up somehow. It could just be >> a transient google problem. I would try again some time later and if >> it occurs again file a bug. The access is controlled by Google and >> Aggregate receives an authentication token to use when you go navigate >> to google authorization page and select "allow". > > Thanks for the answer. I tried again today and it asked for permission > again, but failed in the same way immediately after. > > Here is the authorization page that I saw just before that: > >> The site anonymous is requesting access to your Google Account for the >> product(s) listed below. >> >> Fusion Tables >> >> Google is not affiliated with anonymous, and we recommend that you grant >> access only if you trust the site. >> >> If you grant access, you can revoke access at any time under 'My Account'. >> anonymous will not have access to your password or any other personal >> information from your Google Account. Learn more >> >> This website has not registered with Google to establish a secure >> connection for authorization requests. We recommend that you deny access >> unless you trust the website. > > Can you see anything wrong here? > > Cheers, Chris. > -- > Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 > The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES > > Aptivate is a not-for-profit company registered in England and Wales > with company number 04980791. > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >