Failure to publish when user is a non-gmail.com account (i.e., Google apps domain) about aggregate HOT 17 OPEN

After adding additional logging, I've opened this issue to http://stackoverflow.com/questions/15167068/problems-changing-ownership-from-service-account-to-google-apps-domain

You might try granting access to Fusion Tables within your apps domain:

http://support.google.com/fusiontables/answer/1657096

Not sure if this will resolve this issue or not.  Would apply only to Fusion Tables.

My current speculation is that the service account -- e.g., 

322300403941-9ejjp4ovps95s9sn8vl2tbh9s0bdm5dh@developer.gserviceaccount.com

does not have permission to transfer ownership to users in the apps domain (including,
ironically, the user who created the service account). If you can grant that service
account user permission to access your data in your apps domain, the problem might
be resolved (let me know if this works and what URL you had to visit to make the change).

Posted on this in the forum (https://groups.google.com/forum/?fromgroups=#!topic/opendatakit/mhYHrzdodCw)
and got redirected here. For the record (and so other people facing this issue can
be directed here), I get this error when trying to publish from ODK Aggregate to Fusion
Tables with a Google Apps account:

Error: RequestFailureException ({ "error": {  "errors": [   {    "domain": "global",
   "reason": "internalError",    "message": "Internal Error"   }  ],  "code": 500,
 "message": "Internal Error" }}{"value":"[email protected]","role":"owner","type":"user","kind":"drive#permission"})

Looking forward to seeing this fixed!

Can people try the ODK Aggregate installer here (added a Linux and 64-bit Linux version):

 http://homes.cs.washington.edu/~msundt/aggregate/ 

And the instructions also appearing there, to let me know if the work-around does fix
this issue?

Please update this issue with your findings.

If you can upload a version for OS X, I'll test it out.

OK. Uploaded an OSX installer.

Did this work after following the instructions:

http://homes.cs.washington.edu/~msundt/aggregate/

I.e., You must follow the instructions to "Delegate domain-wide authority to your service
account" here: https://developers.google.com/drive/delegation The list of scopes is
as follows:

https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/fusiontables
https://docs.google.com/feeds/ https://docs.googleusercontent.com/ https://spreadsheets.google.com/feeds/

Waiting for confirmation. If the instructions are followed, this might be fixed in 1.3.2.

Sorry, haven't had a chance so far to do so. I'll try for this week!

This is once again broken for the 1.4 release. The Google libraries we switched to using
have an incompatible implementation of this feature w.r.t. the way the Google services
do it.

Either it will magically start working when Google updates their services, or a future
library revision and release of ODK Aggregate will fix the issue.

I've just updated to 1.4.1, and according to the notes here, publishing from Google
Apps domains doesn't work. Is that correct? Is there anything I can do to help confirm/diagnose
a fix?

We removed our custom code that published to Google services, replacing it with a Google-written
library; during that move, it became clear that our hand-coded solution in 1.3.4 was
broken in the underlying implementation of the Google-written library.

Since nobody appeared to be critically bent-out-of-shape over the lack of support,
we decided the reduction in custom code was worth the loss of functionality.

More recently, it appears that Google is moving away from the XML-based API we are
now using toward a JSON-based API. It is unclear, however, whether they have fixed
the apps domain issues that plagued the older API.

Will test it out and let you know, then.—
Sent from Mailbox for iPad

Was this issue ever resolved? Have been trying out all sorts of solution till I got
to this page.
with v1.4.3 i cannot even publish to Google spreadsheet :(

1.4.3 had the production release of Google's library. 

I would recommend opening an issue with Google Apps Domain support saying that you
cannot publish data from your appEngine instance into your Apps Domain user's spreadsheet
or fusion table.

They may require your appengine instance be configured to be within your AppsDomain
(no idea how to do that) or that the superUser you configured in the installer must
be an Apps Domain user, or have special instructions for constructing the Google Credentials.

In the unlikely event that you are actually contacted by Google support (or if you
don't want to be depressed by the lack of support Google offers, you can simply make
a note of the following within your initial bug report), you can tell them that the
ODK Aggregate application is using:

The 1.17.0-rc release when interacting with their services. E.g., 

google-oauth-client-1.17.0-rc.jar
google-oauth-client-appengine-1.17.0-rc.jar
google-http-client-1.17.0-rc.jar
google-http-client-appengine-1.17.0-rc.jar
etc.

and the 1.47.1 update of the various gdata jars

gdata-client-1.0-1.47.1.jar
gdata-spreadsheet-3.0-1.47.1.jar
etc.