500 Server error when trying to create an external service connection in ODK Aggregate

[GoogleCodeExporter]

Apologies if this isn't an ODK bug, but rather an AppEngine issue, but there's 
no way for me to debug, and this was previously working (as recently as a 
couple of weeks ago).

1. Click "External Service Connection" button from ODK Aggregate's Form Manager
2. Click "Google Fusion Tables" button, choose an option, and click "Create 
Connection to External Service"
3. Click "Authorize Fusion Table Creation from Google Account"
4. Click "Grant Access" on the Google Accounts authorization page
5. Receive a 500 Server error "Error: Server rejected one time use token."

The expected (and previously working) output was that the accounts would sync 
and data uploaded to my AppEngine instance would update to Fusion Tables.

This is using appengine-java-sdk-1.3.6 in an AppEngine instance.

As I said, this was previously working (using appengine-java-sdk-1.3.6). Any 
thoughts/help would be great - thank you!

Original issue reported on code.google.com by lgknowl...@gmail.com on 9 Mar 2011 at 8:07

[GoogleCodeExporter]

Original comment by wbrune...@gmail.com on 10 Mar 2011 at 6:00

• Changed state: Accepted
• Added labels: Aggregate

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I also get the same error: Error: Server rejected one time use token.
I have downloaded the latest version of ODK Aggregate using mercurial in my 
eclipse IDE and plus App Engine SDK v1.4.2 but still I get the same error. 
Please can you provide us some help in this issues

Original comment by bahtijar...@gmail.com on 13 Mar 2011 at 5:12

[GoogleCodeExporter]

Unfortunately Google App Engine has changed their security protocols when 
running on the cloud. You now have to register your application. We are working 
with Google on an alternative but it will take some time.

In the mean time if you are tech savy you can register your application and it 
will work. 
http://code.google.com/apis/accounts/docs/RegistrationForWebAppsAuto.html

This is not an easy process for non tech savy people so we are going to change 
the way Aggregate works which will hopefully eliminate this. We are working 
with Goolge and will keep this issue updated when it's complete.

Original comment by wbrune...@gmail.com on 14 Mar 2011 at 1:06

[GoogleCodeExporter]

Thanks for the update. Any thoughts on when you think the modifications to 
Aggregate might be available (as it seems to be that if one is running an 
application on appspot.com, one cannot register it via Google...).

Original comment by lgknowl...@gmail.com on 14 Mar 2011 at 5:00

[GoogleCodeExporter]

You actually can register it if you modify the source for Aggregate which is 
beyond the scope of many our users so we don't recommend it. A new version of 
0.9.x series is planned for release on Monday, March 19th that will change the 
authentication scheme. 

Original comment by wbrune...@gmail.com on 19 Mar 2011 at 1:06

[GoogleCodeExporter]

Fantastic - thank you so much for the quick response and solution. I'll keep an 
eye out and download (and use) the new version on Monday.

Thanks again (and for those curious, I'm using ODK for a project with the 
California Academy of Sciences to allow for capturing and recording data on 
ants - http://www.antweb.org/antweb_test/antcollect.jsp).

Original comment by lgknowl...@gmail.com on 19 Mar 2011 at 2:23

[GoogleCodeExporter]

And just wanted to thank you for the new version - I just downloaded and 
deployed ODKAggregateDeploy v0.9.5, and it does indeed communicate with Fusion 
Tables. Thanks again!

Original comment by lgknowl...@gmail.com on 21 Mar 2011 at 11:16

[GoogleCodeExporter]

Original comment by wbrune...@gmail.com on 22 Mar 2011 at 1:12

• Changed state: Fixed

[GoogleCodeExporter]

This is happening again.

Both when I try this with my own ODK form data and when I follow the steps in 
the tutorial at http://earth.google.com/outreach/tutorial_odk_visualize.html, 
odk-tutorial.appspot.com returns an error.  For my data the error is "Error: 
Server rejected one time use token." (this happened in Aug 2010 
http://code.google.com/p/opendatakit/issues/detail?id=110).  The error from the 
tutorial is a 500 server error with text "Error: Server Error; The server 
encountered an error and could not complete your request.; If the problem 
persists, please report your problem and mention this error message and the 
query that caused it." (again, this seemed to be happening back in March 2011 
http://code.google.com/p/opendatakit/issues/detail?id=192).

Original comment by plorc...@gmail.com on 24 Jun 2011 at 3:28

[GoogleCodeExporter]

Are you using Aggregate 0.9.6? All previous versions will have issues.

Original comment by wbrune...@gmail.com on 24 Jun 2011 at 9:22