Unable to delete Forms ODK Aggregate

OK everything has been working fine until I had some problems with a
new form I created. I get the following errors when I click the View
Submissions:
Uncaught exception from servlet
java.lang.ClassCastException: com.google.appengine.api.datastore.Key
cannot be cast to java.util.List
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:
118)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
150)
at
org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
125)
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:
124)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
150)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
164)
at
org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
125)
at org.odk.aggregate.submission.Submission.(Submission.java:63)
at
org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java:
254)
at
org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java:
66)
at
org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java:
112)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)
at
com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java:
97)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
35)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:
43)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
418)
at
com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
249)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:923)
at
com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
76)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:
135)
at com.google.apphosting.runtime.JavaRuntime
$RequestRunnable.run(JavaRuntime.java:391)
at com.google.apphosting.runtime.ThreadGroupPool
$PoolEntry.run(ThreadGroupPool.java:160)
at java.lang.Thread.run(Thread.java:679)

I think the way I was grouping in build to collect multi photos was
creating the issue. I just want to delete the forms that are in the
Form Manager. It appears to let me delete them gives no error but
they still remain. Any help would be great.

Thanks

The delete takes a while to complete because it runs several
background tasks. It should succeed in about 5 minutes though.

If it doesn't resolve, please file an issue on ODK's google code site
with the form in question attached, the version number of the software
you are using and submissions that are giving you problems. You can
attach files directly to the issue.

Waylon

··· On Thu, Sep 22, 2011 at 11:32 AM, Andrew Faust wrote: > OK everything has been working fine until I had some problems with a > new form I created. I get the following errors when I click the View > Submissions: > Uncaught exception from servlet > java.lang.ClassCastException: com.google.appengine.api.datastore.Key > cannot be cast to java.util.List > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > 118) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > 124) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 164) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at org.odk.aggregate.submission.Submission.(Submission.java:63) > at > org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java: > 254) > at > org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java: > 66) > at > org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java: > 112) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > 511) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1166) > at > com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java: > 97) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java: > 35) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java: > 43) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > 388) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > 216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > 182) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > 765) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > 418) > at > com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java: > 249) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > 152) > at org.mortbay.jetty.Server.handle(Server.java:326) > at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > 542) > at org.mortbay.jetty.HttpConnection > $RequestHandler.headerComplete(HttpConnection.java:923) > at > com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java: > 76) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java: > 135) > at com.google.apphosting.runtime.JavaRuntime > $RequestRunnable.run(JavaRuntime.java:391) > at com.google.apphosting.runtime.ThreadGroupPool > $PoolEntry.run(ThreadGroupPool.java:160) > at java.lang.Thread.run(Thread.java:679) > > I think the way I was grouping in build to collect multi photos was > creating the issue. I just want to delete the forms that are in the > Form Manager. It appears to let me delete them gives no error but > they still remain. Any help would be great. > > Thanks > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >

Thanks I will try the Google App Engine site....the form never deleted
even after days an many tries.

··· On Sep 22, 1:32 pm, Andrew Faust wrote: > OK everything has been working fine until I had some problems with a > new form I created. I get the following errors when I click the View > Submissions: > Uncaught exception from servlet > java.lang.ClassCastException: com.google.appengine.api.datastore.Key > cannot be cast to java.util.List > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(R epeatSubmissionType.java: > 118) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(Submissi onSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(R epeatSubmissionType.java: > 124) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(Submissi onSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(Submissi onSet.java: > 164) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at org.odk.aggregate.submission.Submission.(Submission.java:63) > at > org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable .java: > 254) > at > org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTa ble(SubmissionHtmlTable.java: > 66) > at > org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServl et.java: > 112) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > 511) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1166) > at > com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlo bUploadFilter.java: > 97) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionF ilter.java: > 35) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(Trans actionCleanupFilter.java: > 43) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > 388) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > 216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > 182) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > 765) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > 418) > at > com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionH andlerMap.java: > 249) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > 152) > at org.mortbay.jetty.Server.handle(Server.java:326) > at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > 542) > at org.mortbay.jetty.HttpConnection > $RequestHandler.headerComplete(HttpConnection.java:923) > at > com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequ estParser.java: > 76) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceReques t(JettyServletEngineAdapter.java: > 135) > at com.google.apphosting.runtime.JavaRuntime > $RequestRunnable.run(JavaRuntime.java:391) > at com.google.apphosting.runtime.ThreadGroupPool > $PoolEntry.run(ThreadGroupPool.java:160) > at java.lang.Thread.run(Thread.java:679) > > I think the way I was grouping in build to collect multi photos was > creating the issue. I just want to delete the forms that are in the > Form Manager. It appears to let me delete them gives no error but > they still remain. Any help would be great. > > Thanks

Of course. I'm PostgreSQL 9.4.4.

··· On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote: > OK everything has been working fine until I had some problems with a > new form I created. I get the following errors when I click the View > Submissions: > Uncaught exception from servlet > java.lang.ClassCastException: com.google.appengine.api.datastore.Key > cannot be cast to java.util.List > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > 118) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > 124) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 150) > at > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > 164) > at > org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > 125) > at org.odk.aggregate.submission.Submission.(Submission.java:63) > at > org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java: > 254) > at > org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java: > 66) > at > org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java: > 112) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > 511) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1166) > at > com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java: > 97) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java: > 35) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java: > 43) > at org.mortbay.jetty.servlet.ServletHandler > $CachedChain.doFilter(ServletHandler.java:1157) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > 388) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > 216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > 182) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > 765) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > 418) > at > com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java: > 249) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > 152) > at org.mortbay.jetty.Server.handle(Server.java:326) > at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > 542) > at org.mortbay.jetty.HttpConnection > $RequestHandler.headerComplete(HttpConnection.java:923) > at > com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java: > 76) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > at > com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java: > 135) > at com.google.apphosting.runtime.JavaRuntime > $RequestRunnable.run(JavaRuntime.java:391) > at com.google.apphosting.runtime.ThreadGroupPool > $PoolEntry.run(ThreadGroupPool.java:160) > at java.lang.Thread.run(Thread.java:679) > > I think the way I was grouping in build to collect multi photos was > creating the issue. I just want to delete the forms that are in the > Form Manager. It appears to let me delete them gives no error but > they still remain. Any help would be great. > > Thanks

Also be sure that you are running the latest ODK Aggregate 0.9.x code.

Mitch

··· On Thu, Sep 22, 2011 at 12:56 PM, W. Brunette wrote:

The delete takes a while to complete because it runs several
background tasks. It should succeed in about 5 minutes though.

If it doesn't resolve, please file an issue on ODK's google code site
with the form in question attached, the version number of the software
you are using and submissions that are giving you problems. You can
attach files directly to the issue.

Waylon

On Thu, Sep 22, 2011 at 11:32 AM, Andrew Faust afaust@ncwrpc.org wrote:

OK everything has been working fine until I had some problems with a
new form I created. I get the following errors when I click the View
Submissions:
Uncaught exception from servlet
java.lang.ClassCastException: com.google.appengine.api.datastore.Key
cannot be cast to java.util.List
at

org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:

  1. at

org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:

  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  2. at

org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:

  1. at

org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:

  1. at

org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:

  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  2. at
    org.odk.aggregate.submission.Submission.(Submission.java:63)
    at

org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java:

  1. at

org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java:

  1. at

org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java:

  1. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at
    org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
  2. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1166)
    at

com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java:

  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at

com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:

  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at

com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:

  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
  2. at
    org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
  3. at
    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
  4. at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
  5. at
    org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
  6. at

com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:

  1. at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
  2. at org.mortbay.jetty.Server.handle(Server.java:326)
    at
    org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
  3. at org.mortbay.jetty.HttpConnection
    $RequestHandler.headerComplete(HttpConnection.java:923)
    at

com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:

  1. at
    org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    at

com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:

  1. at com.google.apphosting.runtime.JavaRuntime
    $RequestRunnable.run(JavaRuntime.java:391)
    at com.google.apphosting.runtime.ThreadGroupPool
    $PoolEntry.run(ThreadGroupPool.java:160)
    at java.lang.Thread.run(Thread.java:679)

I think the way I was grouping in build to collect multi photos was
creating the issue. I just want to delete the forms that are in the
Form Manager. It appears to let me delete them gives no error but
they still remain. Any help would be great.

Thanks

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

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

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

Same problem here.

Do you need to keep any of the form data in the database? If not, one
easy thing you could do is wipe the PostgreSQL DB and start over.

Yaw

··· -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.

On Mon, Oct 5, 2015 at 10:31 PM, geotheory1@gmail.com wrote:

On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote:

OK everything has been working fine until I had some problems with a
new form I created. I get the following errors when I click the View
Submissions:
Uncaught exception from servlet
java.lang.ClassCastException: com.google.appengine.api.datastore.Key
cannot be cast to java.util.List
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:
118)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
150)
at
org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
125)
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java:
124)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
150)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
164)
at
org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
125)
at org.odk.aggregate.submission.Submission.(Submission.java:63)
at
org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java:
254)
at
org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java:
66)
at
org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java:
112)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
511)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1166)
at
com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java:
97)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
35)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:
43)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1157)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
388)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
418)
at
com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
249)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
at org.mortbay.jetty.HttpConnection
$RequestHandler.headerComplete(HttpConnection.java:923)
at
com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
76)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java:
135)
at com.google.apphosting.runtime.JavaRuntime
$RequestRunnable.run(JavaRuntime.java:391)
at com.google.apphosting.runtime.ThreadGroupPool
$PoolEntry.run(ThreadGroupPool.java:160)
at java.lang.Thread.run(Thread.java:679)

I think the way I was grouping in build to collect multi photos was
creating the issue. I just want to delete the forms that are in the
Form Manager. It appears to let me delete them gives no error but
they still remain. Any help would be great.

Thanks

Of course. I'm PostgreSQL 9.4.4.

--

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/d/optout.

Need more details on your problem before anyone can help. What version
are you using? On what platform? What exactly are the steps you are
taking? What happens when you take those steps? Any error messages?

Yaw

··· -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.

On Sun, Oct 4, 2015 at 11:41 PM, geotheory1@gmail.com wrote:

Same problem here.

--

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/d/optout.

Had the same issue and took me a while before figuring it out how. My
aggregate is hosted on Google app-engine. I had a huge form with multiple
looped grouped which I believe was causing the issue too. It couldn't fully
be deleted and got similar error after deleting the form and try to view
submissions/ form-list just to find it there. At the same time pushed my
back-end instances- hours resource usage quite high, hence ended up been
billed for more than usual for back-end instances usage on the App engine.
I had to increase the server size; both the Back-end and front-end;
Back-end changed its size from B2((256MB) to B4(512MB) - which seemed to be
exceeded before the form couldfully deleted) to as well as the front-end,
changed the class from B2(256MB) to B4 (512) (to match my back-end instance
size), then re-upload the aggregate.

For more details on how to change the size of the App Engine server, follow
instructions below
https://opendatakit.org/use/aggregate/#Changing_Server_Size

··· On Tuesday, October 6, 2015 at 5:36:45 AM UTC+3, Yaw Anokwa wrote: > > Do you need to keep any of the form data in the database? If not, one > easy thing you could do is wipe the PostgreSQL DB and start over. > > Yaw > -- > Need ODK consultants? https://nafundi.com provides form design, server > setup, in-field training, and software development for ODK. > > On Mon, Oct 5, 2015 at 10:31 PM, <geoth...@gmail.com > wrote: > > On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote: > >> OK everything has been working fine until I had some problems with a > >> new form I created. I get the following errors when I click the View > >> Submissions: > >> Uncaught exception from servlet > >> java.lang.ClassCastException: com.google.appengine.api.datastore.Key > >> cannot be cast to java.util.List > >> at > >> > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > > >> 118) > >> at > >> > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > > >> 150) > >> at > >> org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > >> 125) > >> at > >> > org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: > > >> 124) > >> at > >> > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > > >> 150) > >> at > >> > org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: > > >> 164) > >> at > >> org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: > >> 125) > >> at > org.odk.aggregate.submission.Submission.(Submission.java:63) > >> at > >> > org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java: > > >> 254) > >> at > >> > org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java: > > >> 66) > >> at > >> > org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java: > > >> 112) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > >> at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: > >> 511) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1166) > >> at > >> > com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java: > > >> 97) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> > com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java: > > >> 35) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> > com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java: > > >> 43) > >> at org.mortbay.jetty.servlet.ServletHandler > >> $CachedChain.doFilter(ServletHandler.java:1157) > >> at > >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: > >> 388) > >> at > >> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: > >> 216) > >> at > >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: > >> 182) > >> at > >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: > >> 765) > >> at > org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: > >> 418) > >> at > >> > com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java: > > >> 249) > >> at > >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: > >> 152) > >> at org.mortbay.jetty.Server.handle(Server.java:326) > >> at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: > >> 542) > >> at org.mortbay.jetty.HttpConnection > >> $RequestHandler.headerComplete(HttpConnection.java:923) > >> at > >> > com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java: > > >> 76) > >> at > org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) > >> at > >> > com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java: > > >> 135) > >> at com.google.apphosting.runtime.JavaRuntime > >> $RequestRunnable.run(JavaRuntime.java:391) > >> at com.google.apphosting.runtime.ThreadGroupPool > >> $PoolEntry.run(ThreadGroupPool.java:160) > >> at java.lang.Thread.run(Thread.java:679) > >> > >> I think the way I was grouping in build to collect multi photos was > >> creating the issue. I just want to delete the forms that are in the > >> Form Manager. It appears to let me delete them gives no error but > >> they still remain. Any help would be great. > >> > >> Thanks > > > > > > Of course. I'm PostgreSQL 9.4.4. > > > > -- > > -- > > 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/d/optout. >

Need more details on your problem before anyone can help. What version
are you using? On what platform? What exactly are the steps you are
taking? What happens when you take those steps? Any error messages?

Yaw

Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.

Same problem here.

--

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/d/optout.

I'm using Ubilinux on an Intel Edison - that's based on Wheezy 7.9. ODKAggregate 1.4.7 for Mac (Yosemite).

I've tried deleting everything in tomcat6/webapps, re-copying across ODKAggregate.war and restarting tomcat, but the forms are still there.

··· On Monday, 5 October 2015 01:45:03 UTC+1, Yaw Anokwa wrote: > On Sun, Oct 4, 2015 at 11:41 PM, wrote:

Google AppEngine has no "drop table" construct. Deleting a form requires
that each submission be individually retrieved and deleted. This occurs in
the background instance, which is why your background $$s went up. It
proceeds in chunks of 50 submissions. If your form is so large that 50
submissions cannot be held in memory at the same time, or if you have other
publishers or export-to-csv actions occuring in the background instance,
then you will need to increase your server memory.

While the delete is occurring, the UI suppresses the appearance of the form
that was marked as deleted. But that suppression is only enforced for a
limited period of time (largely in case the background delete gets into a
bad state -- so that you know the form is still in the system).

··· On Sat, Mar 4, 2017 at 11:21 PM, charles gatama wrote:

Had the same issue and took me a while before figuring it out how. My
aggregate is hosted on Google app-engine. I had a huge form with multiple
looped grouped which I believe was causing the issue too. It couldn't fully
be deleted and got similar error after deleting the form and try to view
submissions/ form-list just to find it there. At the same time pushed my
back-end instances- hours resource usage quite high, hence ended up been
billed for more than usual for back-end instances usage on the App engine.
I had to increase the server size; both the Back-end and front-end;
Back-end changed its size from B2((256MB) to B4(512MB) - which seemed to be
exceeded before the form couldfully deleted) to as well as the front-end,
changed the class from B2(256MB) to B4 (512) (to match my back-end instance
size), then re-upload the aggregate.

For more details on how to change the size of the App Engine server,
follow instructions below
https://opendatakit.org/use/aggregate/#Changing_Server_Size

On Tuesday, October 6, 2015 at 5:36:45 AM UTC+3, Yaw Anokwa wrote:

Do you need to keep any of the form data in the database? If not, one
easy thing you could do is wipe the PostgreSQL DB and start over.

Yaw

Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.

On Mon, Oct 5, 2015 at 10:31 PM, geoth...@gmail.com wrote:

On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote:

OK everything has been working fine until I had some problems with a
new form I created. I get the following errors when I click the View
Submissions:
Uncaught exception from servlet
java.lang.ClassCastException: com.google.appengine.api.datastore.Key
cannot be cast to java.util.List
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getVa
lueFromEntity(RepeatSubmissionType.java:
118)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:

  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  2. at
    org.odk.aggregate.submission.type.RepeatSubmissionType.getVa
    lueFromEntity(RepeatSubmissionType.java:
  3. at
    org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
  1. at
    org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  2. at org.odk.aggregate.submission.Submission.(Submission.java:63)
  at

org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java:

  1. at
    org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubm
    issionResultsTable(SubmissionHtmlTable.java:
  2. at
    org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java:
  1. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1166)
    at
    com.google.apphosting.utils.servlet.ParseBlobUploadFilter.do
    Filter(ParseBlobUploadFilter.java:
  2. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    com.google.apphosting.utils.servlet.TransactionCleanupFilter
    .doFilter(TransactionCleanupFilter.java:
  2. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
  3. at
    org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
  1. at
    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
  2. at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
  3. at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
  1. at
    com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
  1. at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
  2. at org.mortbay.jetty.Server.handle(Server.java:326)
    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
  1. at org.mortbay.jetty.HttpConnection
    $RequestHandler.headerComplete(HttpConnection.java:923)
    at
    com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
  1. at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
  at

com.google.apphosting.runtime.jetty.JettyServletEngineAdapte
r.serviceRequest(JettyServletEngineAdapter.java:
135)
at com.google.apphosting.runtime.JavaRuntime
$RequestRunnable.run(JavaRuntime.java:391)
at com.google.apphosting.runtime.ThreadGroupPool
$PoolEntry.run(ThreadGroupPool.java:160)
at java.lang.Thread.run(Thread.java:679)

I think the way I was grouping in build to collect multi photos was
creating the issue. I just want to delete the forms that are in the
Form Manager. It appears to let me delete them gives no error but
they still remain. Any help would be great.

Thanks

Of course. I'm PostgreSQL 9.4.4.

--

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/d/optout.

--

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/d/optout.

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

The forms are in the MySQL/PostgreSQL database that backs ODK, not in the WAR.

Yaw

··· -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.

On Mon, Oct 5, 2015 at 10:07 PM, geotheory1@gmail.com wrote:

On Monday, 5 October 2015 01:45:03 UTC+1, Yaw Anokwa wrote:

Need more details on your problem before anyone can help. What version
are you using? On what platform? What exactly are the steps you are
taking? What happens when you take those steps? Any error messages?

Yaw

Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.

On Sun, Oct 4, 2015 at 11:41 PM, geotheory1@gmail.com wrote:

Same problem here.

--

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/d/optout.

I'm using Ubilinux on an Intel Edison - that's based on Wheezy 7.9. ODKAggregate 1.4.7 for Mac (Yosemite).

I've tried deleting everything in tomcat6/webapps, re-copying across ODKAggregate.war and restarting tomcat, but the forms are still there.

--

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/d/optout.

Hi Mitch
Thanks. Whats the equivalence of Drop Table statement in the AppEngine
datastore to delete a specified table(s) from my db, its defined indexes,
and removes any privileges or synonyms that reference that table in Query
by SQL of the ApEngine Datastore. I managed to delete one of my forms that
was persistence after increasing the server memory, but one with quite a
number of looped groups still doesn't get dropped.....

··· On Monday, March 6, 2017 at 9:07:35 PM UTC+3, Mitch Sundt wrote: > > Google AppEngine has no "drop table" construct. Deleting a form requires > that each submission be individually retrieved and deleted. This occurs in > the background instance, which is why your background $$s went up. It > proceeds in chunks of 50 submissions. If your form is so large that 50 > submissions cannot be held in memory at the same time, or if you have other > publishers or export-to-csv actions occuring in the background instance, > then you will need to increase your server memory. > > While the delete is occurring, the UI suppresses the appearance of the > form that was marked as deleted. But that suppression is only enforced for > a limited period of time (largely in case the background delete gets into a > bad state -- so that you know the form is still in the system). > > > On Sat, Mar 4, 2017 at 11:21 PM, charles gatama <c.ga...@gmail.com > wrote: > >> Had the same issue and took me a while before figuring it out how. My >> aggregate is hosted on Google app-engine. I had a huge form with multiple >> looped grouped which I believe was causing the issue too. It couldn't fully >> be deleted and got similar error after deleting the form and try to view >> submissions/ form-list just to find it there. At the same time pushed my >> back-end instances- hours resource usage quite high, hence ended up been >> billed for more than usual for back-end instances usage on the App engine. >> I had to increase the server size; both the Back-end and front-end; >> Back-end changed its size from B2((256MB) to B4(512MB) - which seemed to be >> exceeded before the form couldfully deleted) to as well as the front-end, >> changed the class from B2(256MB) to B4 (512) (to match my back-end instance >> size), then re-upload the aggregate. >> >> For more details on how to change the size of the App Engine server, >> follow instructions below >> https://opendatakit.org/use/aggregate/#Changing_Server_Size >> >> On Tuesday, October 6, 2015 at 5:36:45 AM UTC+3, Yaw Anokwa wrote: >>> >>> Do you need to keep any of the form data in the database? If not, one >>> easy thing you could do is wipe the PostgreSQL DB and start over. >>> >>> Yaw >>> -- >>> Need ODK consultants? https://nafundi.com provides form design, server >>> setup, in-field training, and software development for ODK. >>> >>> On Mon, Oct 5, 2015 at 10:31 PM, wrote: >>> > On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote: >>> >> OK everything has been working fine until I had some problems with a >>> >> new form I created. I get the following errors when I click the View >>> >> Submissions: >>> >> Uncaught exception from servlet >>> >> java.lang.ClassCastException: com.google.appengine.api.datastore.Key >>> >> cannot be cast to java.util.List >>> >> at >>> >> >>> org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: >>> >>> >> 118) >>> >> at >>> >> >>> org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: >>> >>> >> 150) >>> >> at >>> >> org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: >>> >> 125) >>> >> at >>> >> >>> org.odk.aggregate.submission.type.RepeatSubmissionType.getValueFromEntity(RepeatSubmissionType.java: >>> >>> >> 124) >>> >> at >>> >> >>> org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: >>> >>> >> 150) >>> >> at >>> >> >>> org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java: >>> >>> >> 164) >>> >> at >>> >> org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java: >>> >> 125) >>> >> at >>> org.odk.aggregate.submission.Submission.(Submission.java:63) >>> >> at >>> >> >>> org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java: >>> >>> >> 254) >>> >> at >>> >> >>> org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubmissionResultsTable(SubmissionHtmlTable.java: >>> >>> >> 66) >>> >> at >>> >> >>> org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java: >>> >>> >> 112) >>> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >>> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >>> >> at >>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java: >>> >> 511) >>> >> at org.mortbay.jetty.servlet.ServletHandler >>> >> $CachedChain.doFilter(ServletHandler.java:1166) >>> >> at >>> >> com.google.apphosting.utils.servlet.ParseBlobUploadFilter.doFilter(ParseBlobUploadFilter.java: >>> >>> >> 97) >>> >> at org.mortbay.jetty.servlet.ServletHandler >>> >> $CachedChain.doFilter(ServletHandler.java:1157) >>> >> at >>> >> >>> com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java: >>> >>> >> 35) >>> >> at org.mortbay.jetty.servlet.ServletHandler >>> >> $CachedChain.doFilter(ServletHandler.java:1157) >>> >> at >>> >> com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java: >>> >>> >> 43) >>> >> at org.mortbay.jetty.servlet.ServletHandler >>> >> $CachedChain.doFilter(ServletHandler.java:1157) >>> >> at >>> >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: >>> >> 388) >>> >> at >>> >> >>> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java: >>> >> 216) >>> >> at >>> >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java: >>> >> 182) >>> >> at >>> >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java: >>> >> 765) >>> >> at >>> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java: >>> >> 418) >>> >> at >>> >> >>> com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java: >>> >>> >> 249) >>> >> at >>> >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java: >>> >> 152) >>> >> at org.mortbay.jetty.Server.handle(Server.java:326) >>> >> at >>> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java: >>> >> 542) >>> >> at org.mortbay.jetty.HttpConnection >>> >> $RequestHandler.headerComplete(HttpConnection.java:923) >>> >> at >>> >> >>> com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java: >>> >>> >> 76) >>> >> at >>> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >>> >> at >>> >> >>> com.google.apphosting.runtime.jetty.JettyServletEngineAdapter.serviceRequest(JettyServletEngineAdapter.java: >>> >>> >> 135) >>> >> at com.google.apphosting.runtime.JavaRuntime >>> >> $RequestRunnable.run(JavaRuntime.java:391) >>> >> at com.google.apphosting.runtime.ThreadGroupPool >>> >> $PoolEntry.run(ThreadGroupPool.java:160) >>> >> at java.lang.Thread.run(Thread.java:679) >>> >> >>> >> I think the way I was grouping in build to collect multi photos was >>> >> creating the issue. I just want to delete the forms that are in the >>> >> Form Manager. It appears to let me delete them gives no error but >>> >> they still remain. Any help would be great. >>> >> >>> >> Thanks >>> > >>> > >>> > Of course. I'm PostgreSQL 9.4.4. >>> > >>> > -- >>> > -- >>> > 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/d/optout. >>> >> -- >> -- >> 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/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

There really is no viable solution other than to keep clicking "Delete
Form" whenever the form re-appears in the list.

··· On Wed, Mar 8, 2017 at 10:26 PM, charles gatama wrote:

Hi Mitch
Thanks. Whats the equivalence of Drop Table statement in the AppEngine
datastore to delete a specified table(s) from my db, its defined indexes,
and removes any privileges or synonyms that reference that table in Query
by SQL of the ApEngine Datastore. I managed to delete one of my forms that
was persistence after increasing the server memory, but one with quite a
number of looped groups still doesn't get dropped.....

On Monday, March 6, 2017 at 9:07:35 PM UTC+3, Mitch Sundt wrote:

Google AppEngine has no "drop table" construct. Deleting a form requires
that each submission be individually retrieved and deleted. This occurs in
the background instance, which is why your background $$s went up. It
proceeds in chunks of 50 submissions. If your form is so large that 50
submissions cannot be held in memory at the same time, or if you have other
publishers or export-to-csv actions occuring in the background instance,
then you will need to increase your server memory.

While the delete is occurring, the UI suppresses the appearance of the
form that was marked as deleted. But that suppression is only enforced for
a limited period of time (largely in case the background delete gets into a
bad state -- so that you know the form is still in the system).

On Sat, Mar 4, 2017 at 11:21 PM, charles gatama c.ga...@gmail.com wrote:

Had the same issue and took me a while before figuring it out how. My
aggregate is hosted on Google app-engine. I had a huge form with multiple
looped grouped which I believe was causing the issue too. It couldn't fully
be deleted and got similar error after deleting the form and try to view
submissions/ form-list just to find it there. At the same time pushed my
back-end instances- hours resource usage quite high, hence ended up been
billed for more than usual for back-end instances usage on the App engine.
I had to increase the server size; both the Back-end and front-end;
Back-end changed its size from B2((256MB) to B4(512MB) - which seemed to be
exceeded before the form couldfully deleted) to as well as the front-end,
changed the class from B2(256MB) to B4 (512) (to match my back-end instance
size), then re-upload the aggregate.

For more details on how to change the size of the App Engine server,
follow instructions below
https://opendatakit.org/use/aggregate/#Changing_Server_Size

On Tuesday, October 6, 2015 at 5:36:45 AM UTC+3, Yaw Anokwa wrote:

Do you need to keep any of the form data in the database? If not, one
easy thing you could do is wipe the PostgreSQL DB and start over.

Yaw

Need ODK consultants? https://nafundi.com provides form design, server
setup, in-field training, and software development for ODK.

On Mon, Oct 5, 2015 at 10:31 PM, geoth...@gmail.com wrote:

On Thursday, 22 September 2011 19:32:28 UTC+1, Andrew Faust wrote:

OK everything has been working fine until I had some problems with a
new form I created. I get the following errors when I click the
View
Submissions:
Uncaught exception from servlet
java.lang.ClassCastException: com.google.appengine.api.datastore.Key

cannot be cast to java.util.List
at
org.odk.aggregate.submission.type.RepeatSubmissionType.getVa
lueFromEntity(RepeatSubmissionType.java:
118)
at
org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:

  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  1. at
    org.odk.aggregate.submission.type.RepeatSubmissionType.getVa
    lueFromEntity(RepeatSubmissionType.java:
  2. at
    org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
  1. at
    org.odk.aggregate.submission.SubmissionSet.restoreSubmissionFields(SubmissionSet.java:
  1. at
    org.odk.aggregate.submission.SubmissionSet.(SubmissionSet.java:
  1. at org.odk.aggregate.submission.S
    ubmission.(Submission.java:63)
    at
    org.odk.aggregate.table.SubmissionTable.generateResultTable(SubmissionTable.java:
  1. at
    org.odk.aggregate.table.SubmissionHtmlTable.generateHtmlSubm
    issionResultsTable(SubmissionHtmlTable.java:
  2. at
    org.odk.aggregate.servlet.FormSubmissionsServlet.doGet(FormSubmissionsServlet.java:
  1. at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  at org.mortbay.jetty.servlet.Serv

letHolder.handle(ServletHolder.java:

  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1166)
    at
    com.google.apphosting.utils.servlet.ParseBlobUploadFilter.do
    Filter(ParseBlobUploadFilter.java:
  2. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    com.google.apphosting.runtime.jetty.SaveSessionFilter.doFilter(SaveSessionFilter.java:
  1. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    com.google.apphosting.utils.servlet.TransactionCleanupFilter
    .doFilter(TransactionCleanupFilter.java:
  2. at org.mortbay.jetty.servlet.ServletHandler
    $CachedChain.doFilter(ServletHandler.java:1157)
    at
    org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
  1. at
    org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
  1. at
    org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
  1. at
    org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
  1. at org.mortbay.jetty.webapp.WebAp
    pContext.handle(WebAppContext.java:
  2. at
    com.google.apphosting.runtime.jetty.AppVersionHandlerMap.handle(AppVersionHandlerMap.java:
  1. at
    org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
  1. at org.mortbay.jetty.Server.handle(Server.java:326)
    at org.mortbay.jetty.HttpConnecti
    on.handleRequest(HttpConnection.java:
  2. at org.mortbay.jetty.HttpConnection
    $RequestHandler.headerComplete(HttpConnection.java:923)
    at
    com.google.apphosting.runtime.jetty.RpcRequestParser.parseAvailable(RpcRequestParser.java:
  1. at org.mortbay.jetty.HttpConnecti
    on.handle(HttpConnection.java:404)
    at
    com.google.apphosting.runtime.jetty.JettyServletEngineAdapte
    r.serviceRequest(JettyServletEngineAdapter.java:
  2. at com.google.apphosting.runtime.JavaRuntime
    $RequestRunnable.run(JavaRuntime.java:391)
    at com.google.apphosting.runtime.ThreadGroupPool
    $PoolEntry.run(ThreadGroupPool.java:160)
    at java.lang.Thread.run(Thread.java:679)

I think the way I was grouping in build to collect multi photos was
creating the issue. I just want to delete the forms that are in the
Form Manager. It appears to let me delete them gives no error but
they still remain. Any help would be great.

Thanks

Of course. I'm PostgreSQL 9.4.4.

--

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/d/optout.

--

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/d/optout.

--
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/d/optout.

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

Hi All

I am facing the same issue. I have deleted a form and even after 2 days I can still see/download its data.

I am using Aggregate VM downloaded from http://nafundi.com/products/

I am using ODK-Aggregate-VM-1.4.11.0-disk1.vmdk (Ubunut 12.04).

thanks

Hi All
Although, I am using a version which is more than 2 years old but till the time I upgrade, I have to fix issues to make it work. Like form deletion some times does not work.

Now, if I want to delete a from by using drop table on database, from which other tables do I need to delete relevant records. I have notices _form_data_model needs relevant records to be delete.

Can any one please tell me the list of tables from where I need to delete records to properly delete a form using queries.

thanks

Muhammad