[ODK Community] "500 Internal Error" when trying to publish from ODK Aggregate 1.3.0 to Fusion Tables

Support
1

See and "star" this issue:

http://code.google.com/p/opendatakit/issues/detail?id=776

I was hoping to have a resolution before the 1.3.1 release, but am having
trouble finding the right people to talk to...

The work-around is to publish as a @gmail.com user. I don't have an apps
account so I haven't been able to directly debug this.

··· On Thu, Apr 4, 2013 at 4:38 AM, wrote:

Hello,

I'm trying to export the submissions of a form from ODK Aggregate 1.3.0
(hosted on AppSpot) to Google Fusion Tables. I receive the following error
when I click "Publish" and choose to upload existing data and stream new
data to Fusion Tables:

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

I've followed the instructions on the ODK website for setting up OAuth2
authentication.

The same issue occurs if I try and upload existing data only.

Looking at the "Published Data" tab, I see a bunch of entries for the
Fusion Tables exports, with the status as "ESTABLISHED". If I click on the
link, I get the following message: "Sorry, jhiggs@ecoenergyfinance.orgdoes not have the permissions to view the requested table."

Has anyone seen this before, or have any tips on diagnosing what the
underlying issue is?

Thanks!

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

2

You need to be logged in as the gmail user when creating the publisher (and
then it works -- publishing to that user). Not sure what happens if you
then try to share that file with the apps domain user.

It apparently doesn't matter what user you create the service account
under.

Mitch

··· On Mon, Apr 8, 2013 at 5:41 AM, wrote:

Tried the workaround of setting up a service account as a GMail user,
filling in auth details in Aggregate. I even went so far as to log in as
the same GMail (not GApps) user into the Aggregate instance. When I
publish, this comes up:

Error: RequestFailureException ({ "error": { "errors": [ { "domain":
"usageLimits", "reason": "accessNotConfigured", "message": "Access Not
Configured" } ], "code": 403, "message": "Access Not Configured" }}null)

I checked, and the common cause of this seems to be referrers. However,
none are set in the API console.

Any idea what the cause could be?

On Thursday, April 4, 2013 10:02:36 PM UTC+5, Mitch wrote:

See and "star" this issue:

http://code.google.com/p/opendatakit/issues/detail?id=776

I was hoping to have a resolution before the 1.3.1 release, but am
having trouble finding the right people to talk to...

The work-around is to publish as a @gmail.com user. I don't have an
apps account so I haven't been able to directly debug this.

On Thu, Apr 4, 2013 at 4:38 AM, jhi...@ecoenergyfinance.org wrote:

Hello,

I'm trying to export the submissions of a form from ODK Aggregate 1.3.0
(hosted on AppSpot) to Google Fusion Tables. I receive the following error
when I click "Publish" and choose to upload existing data and stream new
data to Fusion Tables:

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

I've followed the instructions on the ODK website for setting up OAuth2
authentication.

The same issue occurs if I try and upload existing data only.

Looking at the "Published Data" tab, I see a bunch of entries for the
Fusion Tables exports, with the status as "ESTABLISHED". If I click on the
link, I get the following message: "Sorry, jhi...@ecoenergyfinance.orgdoes not have the permissions to view the requested table."

Has anyone seen this before, or have any tips on diagnosing what the
underlying issue is?

Thanks!

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

I logged in as the gmail user and then created the publisher, and received
that error too (tried it before posting, just to be sure). The auth keys
were created as the gmail user too.

Thoroughly confused!

You need to be logged in as the gmail user when creating the publisher (and
then it works -- publishing to that user). Not sure what happens if you
then try to share that file with the apps domain user.

It apparently doesn't matter what user you create the service account
under.

Mitch

··· On 08/04/2013, at 23:56, Mitch Sundt wrote:

On Mon, Apr 8, 2013 at 5:41 AM, jhiggs@ecoenergyfinance.org wrote:

Tried the workaround of setting up a service account as a GMail user,
filling in auth details in Aggregate. I even went so far as to log in as
the same GMail (not GApps) user into the Aggregate instance. When I
publish, this comes up:

Error: RequestFailureException ({ "error": { "errors": [ { "domain":
"usageLimits", "reason": "accessNotConfigured", "message": "Access Not
Configured" } ], "code": 403, "message": "Access Not Configured" }}null)

I checked, and the common cause of this seems to be referrers. However,
none are set in the API console.

Any idea what the cause could be?

On Thursday, April 4, 2013 10:02:36 PM UTC+5, Mitch wrote:

See and "star" this issue:

http://code.google.com/p/opendatakit/issues/detail?id=776

I was hoping to have a resolution before the 1.3.1 release, but am
having trouble finding the right people to talk to...

The work-around is to publish as a @gmail.com user. I don't have an
apps account so I haven't been able to directly debug this.

On Thu, Apr 4, 2013 at 4:38 AM, jhi...@ecoenergyfinance.org wrote:

Hello,

I'm trying to export the submissions of a form from ODK Aggregate 1.3.0
(hosted on AppSpot) to Google Fusion Tables. I receive the following error
when I click "Publish" and choose to upload existing data and stream new
data to Fusion Tables:

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

I've followed the instructions on the ODK website for setting up OAuth2
authentication.

The same issue occurs if I try and upload existing data only.

Looking at the "Published Data" tab, I see a bunch of entries for the
Fusion Tables exports, with the status as "ESTABLISHED". If I click on the
link, I get the following message: "Sorry, jhi...@ecoenergyfinance.orgdoes not have the permissions to view the requested table."

Has anyone seen this before, or have any tips on diagnosing what the
underlying issue is?

Thanks!

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/mhYHrzdodCw/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

4

Curious.

I have not seen a: "domain": "usageLimits", "reason":
"accessNotConfigured" ... error before.

What I was seeing was: "domain": "global", "reason": "internalError",

I would double-check that you have the correct private ky file for the
service account you configured.

If that all checks out, then it would appear that you got past one hurdle?

And now have an access rights issue on the service account?

Mitch

··· On Mon, Apr 8, 2013 at 1:06 PM, Jeremy Higgs wrote:

I logged in as the gmail user and then created the publisher, and received
that error too (tried it before posting, just to be sure). The auth keys
were created as the gmail user too.

Thoroughly confused!

On 08/04/2013, at 23:56, Mitch Sundt mitchellsundt@gmail.com wrote:

You need to be logged in as the gmail user when creating the publisher
(and then it works -- publishing to that user). Not sure what happens if
you then try to share that file with the apps domain user.

It apparently doesn't matter what user you create the service account
under.

Mitch

On Mon, Apr 8, 2013 at 5:41 AM, jhiggs@ecoenergyfinance.org wrote:

Tried the workaround of setting up a service account as a GMail user,
filling in auth details in Aggregate. I even went so far as to log in as
the same GMail (not GApps) user into the Aggregate instance. When I
publish, this comes up:

Error: RequestFailureException ({ "error": { "errors": [ { "domain":
"usageLimits", "reason": "accessNotConfigured", "message": "Access Not
Configured" } ], "code": 403, "message": "Access Not Configured" }}null)

I checked, and the common cause of this seems to be referrers. However,
none are set in the API console.

Any idea what the cause could be?

On Thursday, April 4, 2013 10:02:36 PM UTC+5, Mitch wrote:

See and "star" this issue:

http://code.google.com/p/opendatakit/issues/detail?id=776

I was hoping to have a resolution before the 1.3.1 release, but am
having trouble finding the right people to talk to...

The work-around is to publish as a @gmail.com user. I don't have an
apps account so I haven't been able to directly debug this.

On Thu, Apr 4, 2013 at 4:38 AM, jhi...@ecoenergyfinance.org wrote:

Hello,

I'm trying to export the submissions of a form from ODK Aggregate 1.3.0
(hosted on AppSpot) to Google Fusion Tables. I receive the following error
when I click "Publish" and choose to upload existing data and stream new
data to Fusion Tables:

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

I've followed the instructions on the ODK website for setting up OAuth2
authentication.

The same issue occurs if I try and upload existing data only.

Looking at the "Published Data" tab, I see a bunch of entries for the
Fusion Tables exports, with the status as "ESTABLISHED". If I click on the
link, I get the following message: "Sorry, jhi...@ecoenergyfinance.orgdoes not have the permissions to view the requested table."

Has anyone seen this before, or have any tips on diagnosing what the
underlying issue is?

Thanks!

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/mhYHrzdodCw/unsubscribe?hl=en
.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

5

Cracked it. And unfortunately it was my fault. I had enabled "Drive SDK"
service for the GMail user, instead of the "Drive API" service. Now it's
working!

Thanks for the help.

··· On Tue, Apr 9, 2013 at 1:35 AM, Mitch Sundt wrote:

Curious.

I have not seen a: "domain": "usageLimits", "reason":
"accessNotConfigured" ... error before.

What I was seeing was: "domain": "global", "reason": "internalError",

I would double-check that you have the correct private ky file for the
service account you configured.

If that all checks out, then it would appear that you got past one hurdle?

And now have an access rights issue on the service account?

Mitch

On Mon, Apr 8, 2013 at 1:06 PM, Jeremy Higgs jhiggs@ecoenergyfinance.orgwrote:

I logged in as the gmail user and then created the publisher, and
received that error too (tried it before posting, just to be sure). The
auth keys were created as the gmail user too.

Thoroughly confused!

On 08/04/2013, at 23:56, Mitch Sundt mitchellsundt@gmail.com wrote:

You need to be logged in as the gmail user when creating the publisher
(and then it works -- publishing to that user). Not sure what happens if
you then try to share that file with the apps domain user.

It apparently doesn't matter what user you create the service account
under.

Mitch

On Mon, Apr 8, 2013 at 5:41 AM, jhiggs@ecoenergyfinance.org wrote:

Tried the workaround of setting up a service account as a GMail user,
filling in auth details in Aggregate. I even went so far as to log in as
the same GMail (not GApps) user into the Aggregate instance. When I
publish, this comes up:

Error: RequestFailureException ({ "error": { "errors": [ { "domain":
"usageLimits", "reason": "accessNotConfigured", "message": "Access Not
Configured" } ], "code": 403, "message": "Access Not Configured" }}null)

I checked, and the common cause of this seems to be referrers. However,
none are set in the API console.

Any idea what the cause could be?

On Thursday, April 4, 2013 10:02:36 PM UTC+5, Mitch wrote:

See and "star" this issue:

http://code.google.com/p/opendatakit/issues/detail?id=776

I was hoping to have a resolution before the 1.3.1 release, but am
having trouble finding the right people to talk to...

The work-around is to publish as a @gmail.com user. I don't have an
apps account so I haven't been able to directly debug this.

On Thu, Apr 4, 2013 at 4:38 AM, jhi...@ecoenergyfinance.org wrote:

Hello,

I'm trying to export the submissions of a form from ODK Aggregate
1.3.0 (hosted on AppSpot) to Google Fusion Tables. I receive the following
error when I click "Publish" and choose to upload existing data and stream
new data to Fusion Tables:

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

I've followed the instructions on the ODK website for setting up
OAuth2 authentication.

The same issue occurs if I try and upload existing data only.

Looking at the "Published Data" tab, I see a bunch of entries for the
Fusion Tables exports, with the status as "ESTABLISHED". If I click on the
link, I get the following message: "Sorry, jhi...@ecoenergyfinance.orgdoes not have the permissions to view the requested table."

Has anyone seen this before, or have any tips on diagnosing what the
underlying issue is?

Thanks!

--

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.

To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/mhYHrzdodCw/unsubscribe?hl=en
.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/mhYHrzdodCw/unsubscribe?hl=en
.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Jeremy Higgs
Director of Operations
EcoEnergyFinance - “everyone deserves energy”

m: +92 322 267 3973
w: http://www.ecoenergyfinance.org/