# App engine application problem

**URL:** <https://forum.getodk.org/t/app-engine-application-problem/14582>\
**Category:** Support\
**Tags:** odk-aggregate\
**Created:** [August 16, 2018, 8:02am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582 "2018-08-16T08:02:02Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 16, 2018, 8:02am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/1 "2018-08-16T08:02:02Z")

</div>

When i log in to the aggregator and click to export data in CSV file, it fails and bring an error of appengine application problem, yet previously i used to export the data succesfully but right now it is not allowing me to do exports.  
what could be the problem and how can i have it fixed?

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [August 16, 2018, 2:24pm UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/2 "2018-08-16T14:24:07Z")

</div>

Your post does not contain enough information for us to answer your question. In general, the best way to get help is to fill out the questions in the pre-filled template that you get when you create a support post. So, with that in mind, can you answer these questions?

1. What ODK version are you using?
2. What you have you tried to fix the problem?
3. Anything else we should know or have? If you have a test form or screenshots of the error or logs, please attach.

---

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 17, 2018, 9:08am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/3 "2018-08-17T09:08:54Z")

</div>

![Capture](https://getodk.b-cdn.net/uploads/default/original/2X/6/6b42f9b9260ef07b81a821cd55e10a3b3df26f4d.jpeg) for the last four days whenever i log into my ODK aggregator to export data as a CSV file, in three minutes the page shows AppEngine application problem.  
Previously when data collection had just started i used to do exports but now i cannot export anything because of the appengine problem which comes in three minutes time before the export is finished.

I tried using Briefcase v1.112 but it was not exporting all the data, later i upgraded to v1.11.3 but it is still not exporting all the data.  
Data collection started on 25 July but when i export using Briefcase minus selecting dates it starts from 26 July to 4th August yet even yesterday 16th August data was submitted.

When i used to export directly through aggregator i could get all the data but now i have the appengine application problem.

How can i have this fixed to export all the data? or do away with the 3 minutes time outs for the appengine application problem?

 ![brief](https://getodk.b-cdn.net/uploads/default/original/2X/b/ba7960049e7782b9057ff8348790201e8ec7c681.jpeg) this picture shows briefcase exports less forms than i submitted.

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [August 17, 2018, 9:56am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/4 "2018-08-17T09:56:12Z")

</div>

Hi, @ian! I'm sorry you're experiencing issues with Aggregate and Briefcase.

I'd like to propose you do some things that will help us understand the problem:

- Could you tell which version of Aggregate you're running? You can get that information in the Site Admin tab \> Preferences sub tab
- In the error screen you have attached there's a link and instructions to verify that there isn't any problem regarding quotas and billing accounts. Could you check that, please?
- Could you check if there are incomplete submissions in the Form Management tab \> Submission Admin sub tab? The missing submissions could be incomplete submissions that Briefcase won't export.

---

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 17, 2018, 10:32am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/5 "2018-08-17T10:32:38Z")

</div>

Currently am blocked by the app engine problem i cannot access the site admin page and other information on the aggregate, however my download shows am having ODK Aggregate V1.5.0.

When i check the link on the error screen the google cloud platform status shows **Cloud SQL v1 instances are unavailable**

 ![status](https://getodk.b-cdn.net/uploads/default/original/2X/d/df4cc7cca1b2422fbcc43ed1e009d3b3d489f59b.jpeg)

I cannot check for the incomplete submissions because of the Appengine application problem.

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [August 17, 2018, 11:00am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/6 "2018-08-17T11:00:25Z")

</div>

Thanks for the info, @ian.

I don't see how the error you've seen on the dashboard would make your Aggregate instance fail. Could you give [ggalmazor@gmail.com](mailto:ggalmazor@gmail.com) permissions to access your Google Cloud project? I would need to check the logs to get more info.

Could you also send to the same email some credentials to access your Aggregate server?

---

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 17, 2018, 11:17am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/7 "2018-08-17T11:17:52Z")

</div>

> [@ggalmazor](#):
>
> permissions to access your Google Cloud project

i have finished giving you permission

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [August 17, 2018, 12:54pm UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/8 "2018-08-17T12:54:56Z")

</div>

Hi, @ian!

I've been able to check your logs and you're getting the following error:

```auto
2018-08-17 14:44:24.771 CEST
/Aggregate.html com.google.apphosting.api.ApiProxy$OverQuotaException: The API call datastore_v3.RunQuery() required more quota than is available.

```

Quotas are reset every day, so you could wait until tomorrow to resume exporting your forms. You can also link a billing account to avoid having this problem in the future.

---

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 17, 2018, 6:09pm UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/9 "2018-08-17T18:09:02Z")

</div>

When it resets it gives me like 3minutes and locks again..

What leads to the quota limit and if am to pay what are the charges?

---

<div class="post-metadata">

**Author:** ![ian](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ian/32/4215_2.png) [@ian](https://forum.getodk.org/u/ian)\
**Post date:** [August 20, 2018, 6:25am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/10 "2018-08-20T06:25:10Z")

</div>

> [@ggalmazor](#):
>
> billing account

can you help me with the billing costs estimates please?

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [August 20, 2018, 6:47am UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/11 "2018-08-20T06:47:42Z")

</div>

Hi, @ian!

I don't have access to your Google Cloud project to see which Aggregate process is using up all your quota.

I wouldn't know how to help you estimate costs. because I haven't ever used Aggregate on the field.This is a topic [often discussed here in the forums](https://forum.getodk.org/search?q=appengine%20cost). Maybe you can find info there, or ask other users with more experience than me 🙂

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [August 20, 2018, 3:57pm UTC](https://forum.getodk.org/t/app-engine-application-problem/14582/12 "2018-08-20T15:57:13Z")

</div>

[https://docs.opendatakit.org/aggregate-deployment-planning/#minimizing-app-engine-fees](https://docs.opendatakit.org/aggregate-deployment-planning/#minimizing-app-engine-fees) has a good write up on app engine fees. Most campaigns will be free or a few dollars a month.

The problem you are running into sounds like something is misconfigured. My recommendation is to enable billing, set a very low daily limit so you can see what, if anything, you can adjust.
