Not able to see the submissions anymore.

[GoogleCodeExporter]

Hi,

I am not sure what caused this, but now I have a problem with the ODK aggregate 
server. I am getting: " Error: Unexpected error: no matching index found.. " 
when trying to see the submission for all forms. Note that this worked, but 
suddenly something it's broken. Also, now I can't export to CSV or delete any 
xform definition.

You can test it on http://ovidiuodk.appspot.com
This is version: v1.0 ALPHA FIVE.

Do you know if there is a way to fix this. It would be preferred to not lose 
any data already submitted.

Thanks,
Ovidiu

Original issue reported on code.google.com by ovidiu.l...@gmail.com on 29 Mar 2011 at 6:58

[GoogleCodeExporter]

Below is a detailed error from google app engine.

Uncaught exception from servlet
com.google.appengine.api.datastore.DatastoreNeedIndexException: no matching 
index found..      <datastore-index 
kind="opendatakit._persistent_result_file_bin" ancestor="false" source="manual">
        <property name="_PARENT_AURI" direction="asc"/>
        <property name="_ORDINAL_NUMBER" direction="asc"/>
    </datastore-index>
at 
com.google.appengine.api.datastore.DatastoreApiHelper.translateError(DatastoreAp
iHelper.java:42)
    at com.google.appengine.api.datastore.DatastoreApiHelper$1.c
....

Original comment by ovidiu.l...@gmail.com on 29 Mar 2011 at 7:24

[GoogleCodeExporter]

Original comment by wbrune...@gmail.com on 29 Mar 2011 at 10:53

• Added labels: Aggregate

[GoogleCodeExporter]

Sometime over the weekend, there must have been a change in how AppEngine 
processed queries; this was working fine last week.

The fix is now available in the Alpha 6 build, which has a different database 
structure than Alpha 5, so you cannot just deploy Alpha 6 and access your data. 
 If you need to get data out of your Alpha 5 instance, you will need to build 
Alpha 5 from source and apply the fix to 
/src/org/opendatakit/common/persistence/gae/QueryImpl.java

The fix is a changing of a flag from false to true: 
http://code.google.com/p/opendatakit/source/diff?spec=svn.aggregate.61189afa9644
cfc6635ded905a58ba58c68c0dd6&repo=aggregate&r=61189afa9644cfc6635ded905a58ba58c6
8c0dd6&format=side&path=/src/org/opendatakit/common/persistence/engine/gae/Query
Impl.java

If you are OK with losing data, you should move to Alpha 6.  This requires 
either a new appspot instance, or you will need to manually delete all the data 
tables in your Alpha 5 or earlier appspot instance (way too time consuming...).

For Alpha 6, there is a zip for manually configuring a war file that can be 
used to construct the war that you would deploy with command line tools to 
appspot.  That is available here: 
http://code.google.com/p/opendatakit/downloads/detail?name=ODKAggregate%20v1.0%2
0alpha%206%2B%2B%20war-manual-config.zip and the instructions for the 
configuration are here: 
http://code.google.com/p/opendatakit/wiki/AggregatePostgresqlInstall
(updated with info on configuring and deploying on AppEngine).

Original comment by mitchellsundt@gmail.com on 30 Mar 2011 at 12:02

[GoogleCodeExporter]

I applied the fix to ../persistence/gae/QueryImpl.java and updated the alpha 5 
aggregate instance. Now it's working as expected.

Thanks for your quick reply.

Original comment by ovidiu.l...@gmail.com on 30 Mar 2011 at 11:48

[GoogleCodeExporter]

Original comment by wbrune...@gmail.com on 7 Jun 2011 at 11:45

• Changed state: Fixed