I have been using ODK for sometime now but recently when i tried to export a csv, the following error is generated on the web interface:
Failure - abandoned all retry attempts
When i check the logs in catalina.out, i see the following error:
Jun 13, 2014 12:33:38 PM org.opendatakit.aggregate.task.CsvWorkerImpl failureRecovery
SEVERE: Exception caught: java.lang.IllegalStateException: Expected exactly one match in phantom reconstruction! for HHQ-ugr1-v18
java.lang.IllegalStateException: Expected exactly one match in phantom reconstruction!
at org.opendatakit.aggregate.submission.SubmissionSet.recursivelyGetEntities(SubmissionSet.java:314)
at org.opendatakit.aggregate.submission.SubmissionSet.(SubmissionSet.java:283)
at org.opendatakit.aggregate.submission.Submission.(Submission.java:75)
at org.opendatakit.aggregate.query.submission.QueryByUIFilterGroup.getResultSubmissions(QueryByUIFilterGroup.java:214)
at org.opendatakit.aggregate.task.CsvWorkerImpl.generateCsv(CsvWorkerImpl.java:107)
at org.opendatakit.aggregate.task.tomcat.CsvGeneratorImpl$CsvRunner.run(CsvGeneratorImpl.java:46)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
i also tried to export the data using briefcase but it fails. this error is generated for only one particular form(i have 4 forms).
is there any other way apart from these two methods that i can use to manually export a csv file from the database?
any help will be appreciated.
thanks
What version of Aggregate are you using? And on what platform (App
Engine? Tomcat?)
Yaw
···
--
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Fri, Jun 13, 2014 at 3:06 AM, emutesasira@gmail.com wrote:
I have been using ODK for sometime now but recently when i tried to export a csv, the following error is generated on the web interface:
Failure - abandoned all retry attempts
When i check the logs in catalina.out, i see the following error:
Jun 13, 2014 12:33:38 PM org.opendatakit.aggregate.task.CsvWorkerImpl failureRecovery
SEVERE: Exception caught: java.lang.IllegalStateException: Expected exactly one match in phantom reconstruction! for HHQ-ugr1-v18
java.lang.IllegalStateException: Expected exactly one match in phantom reconstruction!
at org.opendatakit.aggregate.submission.SubmissionSet.recursivelyGetEntities(SubmissionSet.java:314)
at org.opendatakit.aggregate.submission.SubmissionSet.(SubmissionSet.java:283)
at org.opendatakit.aggregate.submission.Submission.(Submission.java:75)
at org.opendatakit.aggregate.query.submission.QueryByUIFilterGroup.getResultSubmissions(QueryByUIFilterGroup.java:214)
at org.opendatakit.aggregate.task.CsvWorkerImpl.generateCsv(CsvWorkerImpl.java:107)
at org.opendatakit.aggregate.task.tomcat.CsvGeneratorImpl$CsvRunner.run(CsvGeneratorImpl.java:46)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
i also tried to export the data using briefcase but it fails. this error is generated for only one particular form(i have 4 forms).
is there any other way apart from these two methods that i can use to manually export a csv file from the database?
any help will be appreciated.
thanks
--
You received this message because you are subscribed to the Google Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
This indicates that there is a submission instance for this form that had
an unusual failure when it was uploaded to ODK Aggregate.
To 'unstick' aggregate when it is working with this form, you will need to
manually correct / adjust this submission instance.
First, ensure that your MySQL database is backed up.
Then upgrade to ODK Aggregate v1.4.3 if you are not already running it.
Upgrade steps are specified in
http://code.google.com/p/opendatakit/wiki/AggregateReleaseNotes
Once you have upgraded, install the following 1.4.3 build with a more
detailed error message from here:
https://drive.google.com/folderview?id=0B7g-kLY9PNUDYUZCbVlZaWZ0aGs&usp=sharing
This will log an error message with the SELECT statement that is not
producing exactly one row.
The _TOP_LEVEL_AURI is the instance ID of the submission that is damaged.
The easiest solution is to delete this submission entirely.
The more complex solution is to look at the _CREATION_DATE timestamps for
the two records returned by this SELECT statement and delete the earlier
one.
You may need to do this repeatedly, as your form was split across multiple
tables, and the corruption is likely in several of these tables.
Having the database backup is important, since if you improperly delete
something, you will need to restore back to it and start over.
Mitch
···
On Fri, Jun 13, 2014 at 7:02 AM, Yaw Anokwa wrote:
What version of Aggregate are you using? And on what platform (App
Engine? Tomcat?)
Yaw
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Fri, Jun 13, 2014 at 3:06 AM, emutesasira@gmail.com wrote:
I have been using ODK for sometime now but recently when i tried to
export a csv, the following error is generated on the web interface:
Failure - abandoned all retry attempts
When i check the logs in catalina.out, i see the following error:
Jun 13, 2014 12:33:38 PM org.opendatakit.aggregate.task.CsvWorkerImpl
failureRecovery
SEVERE: Exception caught: java.lang.IllegalStateException: Expected
exactly one match in phantom reconstruction! for HHQ-ugr1-v18
java.lang.IllegalStateException: Expected exactly one match in phantom
reconstruction!
at
org.opendatakit.aggregate.submission.SubmissionSet.recursivelyGetEntities(SubmissionSet.java:314)
at
org.opendatakit.aggregate.submission.SubmissionSet.(SubmissionSet.java:283)
at
org.opendatakit.aggregate.submission.Submission.(Submission.java:75)
at
org.opendatakit.aggregate.query.submission.QueryByUIFilterGroup.getResultSubmissions(QueryByUIFilterGroup.java:214)
at
org.opendatakit.aggregate.task.CsvWorkerImpl.generateCsv(CsvWorkerImpl.java:107)
at
org.opendatakit.aggregate.task.tomcat.CsvGeneratorImpl$CsvRunner.run(CsvGeneratorImpl.java:46)
at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
i also tried to export the data using briefcase but it fails. this error
is generated for only one particular form(i have 4 forms).
is there any other way apart from these two methods that i can use to
manually export a csv file from the database?
any help will be appreciated.
thanks
--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com