Hi all -- I've been AWOL from the community for a while as year end work piled on accompanied with some personal items to attend to. I'm in a bit of a bind at the moment on a project I'm working on in Ethiopia. I appreciate any support which cant be lent -- I understand we are entering the holidays.
What is the problem? Please be detailed.
When trying to pull data from Aggregate using briefcase we experience a 'failed' after the same instance each time.
When trying to view/access data directly from aggregate we get the following error, but the uuid is different each time.
Error: Problem persisting data or accessing data ([RepeatSubmissionType.getValueFromEntity] SQL: SELECT * FROM opendatakit.PRIME_IE_HOUSEHOLD_V2_M6_M6R1 WHERE _PARENT_AURI = uuid:bd43de82-5fa7-4798-b19a-21a5c6d08fbd ORDER BY _PARENT_AURI exception: This request (c9344201b4e87ec9) started at 2017/12/20 21:12:23.531 UTC and was still executing at 2017/12/20 21:13:23.311 UTC.)
What ODK tool and version are you using? And on what device and operating system version?
We are running the survey on the most up-to-data collect, and using aggregate V1.4.9.
What steps can we take to reproduce the problem?
I can provide developer access to replicate this on the server to an ODK team member.
What you have you tried to fix the problem?
For uuids which we had already downloaded, but were showing up as an error, I deleteded them directly from aggregate using the 'filter' option under the 'submissions' tab. This did not work.
I found the following resource on github --> https://github.com/opendatakit/opendatakit/wiki/Aggregate-AppEngine-Troubleshooting which seems to highlight the issue, but when following the instructions I can not seem to locate the specific 'Kinds' which are noted under the repairing the form definition table.
Anything else we should know or have? If you have a test form or screenshots or logs, attach here.
The form is very large with a number of repeat groups and nested groups. Equally internet is very poor with teams often dropping and regaining connectivity while submitting forms.