Forms showing up even after deleting

Hi there,

Hate to post it but I cannot get rid of the forms that I uploaded in the
ODK aggregate. Though it seems that the forms have been deleted from the
aggregate, they showed up after some time (after re-logging in about 30
minutes). I tried twice to delete and upload the newer version of forms but
failed. Is it the appengine configuration problem? Here's the error from
app engine:
URI Count % Errorslast 24 hrs
/gae/formDeleteTaskhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Fgae%2FformDeleteTask"+status%3A4\d\d&severity_level_override=1&view=Search
220100%
/formUploadhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2FformUpload"+status%3A4\d\d&severity_level_override=1&view=Search
1746%
/_ah/starthttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2F_ah%2Fstart"+status%3A4\d\d&severity_level_override=1&view=Search
11100%
/gae/csvGeneratorTaskhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Fgae%2FcsvGeneratorTask"+status%3A4\d\d&severity_level_override=1&view=Search
8100%
/formListhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2FformList"+status%3A4\d\d&severity_level_override=1&view=Search
11.4%
/favicon.icohttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Ffavicon.ico"+status%3A4\d\d&severity_level_override=1&view=Search
[image: help]https://developers.google.com/appengine/kb/general#erroruris
1100%
/https://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2F"+status%3A4\d\d&severity_level_override=1&view=Search
117%

Invite me as a Developer onto your instance.
http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting
The form-deletion task ( /gae/formDeleteTask ) seems to be in an error
state, preventing the form from being completely removed from the system.

Deleting a form can take a while to complete. It involves deleting every
submission for the form, and then removing the form definition.

Mitch

··· On Mon, Feb 17, 2014 at 2:16 AM, csisa bihar wrote:

Hi there,

Hate to post it but I cannot get rid of the forms that I uploaded in the
ODK aggregate. Though it seems that the forms have been deleted from the
aggregate, they showed up after some time (after re-logging in about 30
minutes). I tried twice to delete and upload the newer version of forms but
failed. Is it the appengine configuration problem? Here's the error from
app engine:
URI Count % Errorslast 24 hrs
/gae/formDeleteTaskhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Fgae%2FformDeleteTask"+status%3A4\d\d&severity_level_override=1&view=Search
220100%
/formUploadhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2FformUpload"+status%3A4\d\d&severity_level_override=1&view=Search
1746%
/_ah/starthttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2F_ah%2Fstart"+status%3A4\d\d&severity_level_override=1&view=Search
11100%
/gae/csvGeneratorTaskhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Fgae%2FcsvGeneratorTask"+status%3A4\d\d&severity_level_override=1&view=Search
8100%
/formListhttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2FformList"+status%3A4\d\d&severity_level_override=1&view=Search
11.4%
/favicon.icohttps://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2Ffavicon.ico"+status%3A4\d\d&severity_level_override=1&view=Search
[image: help]https://developers.google.com/appengine/kb/general#erroruris
1100%
/https://appengine.google.com/logs?version_id=1.373788188587830176&app_id=s~csisaindia&filter_type=labels&filter=path%3A"%2F"+status%3A4\d\d&severity_level_override=1&view=Search
117%

--

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

Hi Mitch,

By following the instructions from
http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting, I
deleted the two (FALSE) files from opendatakit._form_info_submission_association
of Data Store Viewer.

Will that work?

Thanks,
Ashok

You are invited ! Mitch !! Thanks a lot.

Ashok

··· On Tuesday, February 18, 2014 11:29:38 AM UTC+5:45, Mitch Sundt wrote: > > Invite me as a Developer onto your instance. > http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting > The form-deletion task ( /gae/formDeleteTask ) seems to be in an error > state, preventing the form from being completely removed from the system. > > Deleting a form can take a while to complete. It involves deleting every > submission for the form, and then removing the form definition. > > Mitch > > > > On Mon, Feb 17, 2014 at 2:16 AM, csisa bihar <csisa...@gmail.com wrote: > >> Hi there, >> >> Hate to post it but I cannot get rid of the forms that I uploaded in the >> ODK aggregate. Though it seems that the forms have been deleted from the >> aggregate, they showed up after some time (after re-logging in about 30 >> minutes). I tried twice to delete and upload the newer version of forms but >> failed. Is it the appengine configuration problem? Here's the error from >> app engine: >> URI Count % Errorslast 24 hrs >> /gae/formDeleteTask >> 220 100% >> /formUpload >> 17 46% >> /_ah/start >> 11 100% >> /gae/csvGeneratorTask >> 8 100% >> /formList >> 1 1.4% >> /favicon.ico >> [image: help] >> 1 100% >> / >> 1 17% >> >> -- >> -- >> 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 >

Not for deleting forms that already have data stored. I deleted all the
form data on your system.

You should be back in operation.

··· On Mon, Feb 17, 2014 at 10:38 PM, csisa bihar wrote:

Hi Mitch,

By following the instructions from
http://code.google.com/p/opendatakit/wiki/AppEngineTroubleshooting, I
deleted the two (FALSE) files from opendatakit._form_info_submission_association
of Data Store Viewer.

Will that work?

Thanks,
Ashok

--

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

@csisa_bihar @Mitch_S

How did you fix this? I'm having a similar issue, with a deleted from Aggregate showing up on my devices.
GoogleAppEngine shows errors for /gae/formDeleteTask.

@Vanubhav What version of ODK Aggregate are you running? Have you tried the steps outlined in this post?

Running 1.4.13. I have not tried the steps in that post but I intend to do so ASAP. However, I think I've deleted my local Aggregate install, so I'm wondering how to access the folder now.

Also, will this lead to a loss in data? We currently have 3 active forms and I cant risk a drop or change in this for even a single day'.

It's a safe operation, but safe operations can fail and so it's always a good idea to assume you will lose data and plan accordingly.

  1. Try the process on a test server (go from B2 to B4, then back to B2) so you understand it.
  2. Perform a backup (ODK Briefcase is great for this) of your production forms and put it somewhere safe (ideally on another machine in another part of the world).
  3. Ask your data collectors to stop submitting data for 24 hours, disable submissions in the Aggregate UI, then do the upgrade.

If you can't do a backup or give yourself 24 hours, then I'd wait until you can. And note that B4 servers will cost more than B2 servers so you might want to go back down to B2 at some point in the future.

Alternatively, you try to delete submissions in smaller groups (e.g., pick a date range, delete those, pick another date range, etc), then delete the form after all the submissions are gone.

Thanks! I used your last para's advice and it worked after a few days.

1 Like