ODK Aggregate cannot export records beyond 10GB of Data & sql query form data with alot of fields

I need help on the following topics 1. Attempts to export data to csv using
ODK aggregate on MySQL/Tomcat is bringing up the "Failure - will retry
later". Does this error have to do with any settings on MySQL Server, or
how can avoid get the ODK aggregate t export the Data. 2. When a form
contains a large number of records, ODK aggragate create 2 core tables to
accomodate all fields. How can I query data combining these two core tables?

Hi Francis,

Look at your Tomcat and MySQL logs. What do they say? You might be
running out of memory, but looking at the logs is the only way to
figure that out. Another thing to try is to use ODK Briefcase to
download and export the data to CSV that way.

explains the DB structure. Querying two tables is a pretty common task
in SQL. Perhaps start looking at JOIN and UNION commands.

Yaw

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

On Mon, Oct 12, 2015 at 9:13 PM, Francis Muwowo muwowo.francis@gmail.com wrote:

I need help on the following topics 1. Attempts to export data to csv using
ODK aggregate on MySQL/Tomcat is bringing up the "Failure - will retry
later". Does this error have to do with any settings on MySQL Server, or how
can avoid get the ODK aggregate t export the Data. 2. When a form contains a
large number of records, ODK aggragate create 2 core tables to accomodate
all fields. How can I query data combining these two core tables?

--

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.