ODK Aggregate : Failure - will retry later

Support
1

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows me
error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then only
this error occur. Can any one please give some idea about how to resolved
from this error.

Thanks
Kanhu

2

Dear all, Alternatively i used ODK Briefcase to export my data to .csv
file. but which is giving two file rather than single file.
basically this is happen, when i used begin repeat type of questions in my
form.
when i export same form through ODK Aggregate's export option it gives only
one file.which is far better than ODK Briefcase export.

3

Hello Guys,

After lots of research finally i found a solution which is increasing the max_allowed_packet size in my mysql or postgreSQL databases containing the ODKAggregate Database and the failure retry later issue is resolved:

set global max_allowed_packet = 1073741824;

Bests

··· On Friday, January 31, 2014 at 4:33:50 PM UTC+4:30, Kanhu Bhol wrote: > Hello Friends, > > > On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later). > I notice when data size more than 100 row or data table is big then only this error occur. Can any one please give some idea about how to resolved from this error. > > > Thanks > Kanhu
4

Hello Guys,

Finally found the right solution which is increasing the max_allowed_packet size in MySQL or PostgreSQL database engines, and the Failure - will retry later issue will go away:

set global max_allowed_packet = 1073741824;

cheers,

··· On Friday, January 31, 2014 at 4:33:50 PM UTC+4:30, Kanhu Bhol wrote: > Hello Friends, > > > On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later). > I notice when data size more than 100 row or data table is big then only this error occur. Can any one please give some idea about how to resolved from this error. > > > Thanks > Kanhu
5

Hi guys,

I´m kind of new here, but I Already have this problem:

On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later).

I tried to go into the cloud shell and type:
set global max_allowed_packet = 1073741824;

nothing happend, I have the same problem, and as you can imaging it´s the worst moment to happend... I tried to take the csv file from ODK Briefcase by first pulling all the information, when pulling it at some point it says "FAILED" But I think it might be downloading everything so I can generate the CSV file, but instead of links to the media of my forms in the cloud it give me links to my local folder... a bummer... any help?

··· El viernes, 31 de enero de 2014, 13:03:50 (UTC+1), Kanhu Bhol escribió: > Hello Friends, > > > On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later). > I notice when data size more than 100 row or data table is big then only this error occur. Can any one please give some idea about how to resolved from this error. > > > Thanks > Kanhu
6

Hi Kanhu,

The export options you have are described at
http://opendatakit.org/use/aggregate/data-transfer/#Exporting. The
relevant portion is below...

"CSV files are a text only, tabular representation of the data.
Multimedia files are represented by including standard web links to
the files. Repeats are also represented with links to the underlying
data. Grouping information is not preserved. Metadata is only
preserved if a filter is created with the metadata.

To download CSV files of forms with repeats, consider using ODK
Briefcase instead of ODK Aggregate's export functionality. Instead of
repeats that are represented with links to the underlying data, ODK
Briefcase will export a set of CSV files, one for each repeating
group. ODK Briefcase will also export any multimedia as files (e.g.,
pictures will get exported as JPEGs). The only metadata that is
preserved is the submission date in the CSV is preserved, but the XML
files that ODK Briefcase downloads has all form metadata."

Basically, you should use ODK Briefcase because it gives you all the
CSV data in one go. Yes it exports multiple files, but that is because
multiple files are the best way to represent the repeat structure you
use.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Fri, Jan 31, 2014 at 4:21 AM, Kanhu Bhol kanhu.gs@gmail.com wrote:

Dear all, Alternatively i used ODK Briefcase to export my data to .csv file.
but which is giving two file rather than single file.
basically this is happen, when i used begin repeat type of questions in my
form.
when i export same form through ODK Aggregate's export option it gives only
one file.which is far better than ODK Briefcase export.

--

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/groups/opt_out.

7

This issue should have been addressed in ODK Aggregate v1.3.
It was introduced by moving to LONGBLOB in ODK Aggregate v1.2.

What version of ODK Aggregate are you using?

··· On Sun, Nov 8, 2015 at 12:04 AM, wrote:

On Friday, January 31, 2014 at 4:33:50 PM UTC+4:30, Kanhu Bhol wrote:

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then only
this error occur. Can any one please give some idea about how to resolved
from this error.

Thanks
Kanhu

Hello Guys,

Finally found the right solution which is increasing the
max_allowed_packet size in MySQL or PostgreSQL database engines, and the
Failure - will retry later issue will go away:

set global max_allowed_packet = 1073741824;

cheers,

--

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

8

Hello Guys,

After lots of research finally i found a solution which is increasing the max_allowed_packet size in my mysql or postgreSQL databases containing the ODKAggregate Database and the failure retry later issue is resolved:

set global max_allowed_packet = 1073741824;

Bests

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then only this error occur. Can any one please give some idea about how to resolved from this error.

Thanks
Kanhu

Good day,
Please assist with the steps. im stuck with this retry later error

··· On Monday, 9 November 2015 00:48:21 UTC+2, muri...@gmail.com wrote: > On Friday, January 31, 2014 at 4:33:50 PM UTC+4:30, Kanhu Bhol wrote:
9

Hi there,

If you are still having problems, please start a new thread describing
what you've tried so far.

Yaw

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

On Wed, Apr 13, 2016 at 10:20 AM, nuncaestardesillegaspronto@gmail.com wrote:

El viernes, 31 de enero de 2014, 13:03:50 (UTC+1), Kanhu Bhol escribió:

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then only this error occur. Can any one please give some idea about how to resolved from this error.

Thanks
Kanhu

Hi guys,

I´m kind of new here, but I Already have this problem:

On ODK Aggregate, when i want to export my data to .csv file,Its shows me error (Failure - will retry later).

I tried to go into the cloud shell and type:
set global max_allowed_packet = 1073741824;

nothing happend, I have the same problem, and as you can imaging it´s the worst moment to happend... I tried to take the csv file from ODK Briefcase by first pulling all the information, when pulling it at some point it says "FAILED" But I think it might be downloading everything so I can generate the CSV file, but instead of links to the media of my forms in the cloud it give me links to my local folder... a bummer... any help?

--

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.

10

Good day , has please help in resolving this issue.tried to set global max allowed packet but it doesn't change the value.
I need help ASAP please

11

Hi Yaw,

I just did. Thank you very much for your help.

Regards,

Pablo

··· On Tue, May 3, 2016 at 10:17 AM, Yaw Anokwa wrote:

Hi there,

If you are still having problems, please start a new thread describing
what you've tried so far.

Yaw

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

On Wed, Apr 13, 2016 at 10:20 AM, nuncaestardesillegaspronto@gmail.com wrote:

El viernes, 31 de enero de 2014, 13:03:50 (UTC+1), Kanhu Bhol escribió:

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then
only this error occur. Can any one please give some idea about how to
resolved from this error.

Thanks
Kanhu

Hi guys,

I´m kind of new here, but I Already have this problem:

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).

I tried to go into the cloud shell and type:
set global max_allowed_packet = 1073741824;

nothing happend, I have the same problem, and as you can imaging it´s
the worst moment to happend... I tried to take the csv file from ODK
Briefcase by first pulling all the information, when pulling it at some
point it says "FAILED" But I think it might be downloading everything so I
can generate the CSV file, but instead of links to the media of my forms in
the cloud it give me links to my local folder... a bummer... any help?

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

12

Hello,

Please have my Skype id below so we can better communicate:

muridmehr

··· On 6 Jan 2016 11:05 pm, wrote:

Good day , has please help in resolving this issue.tried to set global max
allowed packet but it doesn't change the value.
I need help ASAP please

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

13

Pablo Rodríguez, are you saying you found assistance ? if yes please let me
know or give me the link to the solution.

··· On Tue, May 3, 2016 at 2:22 PM, Pablo Rodríguez < nuncaestardesillegaspronto@gmail.com> wrote:

Hi Yaw,

I just did. Thank you very much for your help.

Regards,

Pablo

On Tue, May 3, 2016 at 10:17 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi there,

If you are still having problems, please start a new thread describing
what you've tried so far.

Yaw

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

On Wed, Apr 13, 2016 at 10:20 AM, nuncaestardesillegaspronto@gmail.com wrote:

El viernes, 31 de enero de 2014, 13:03:50 (UTC+1), Kanhu Bhol escribió:

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then
only this error occur. Can any one please give some idea about how to
resolved from this error.

Thanks
Kanhu

Hi guys,

I´m kind of new here, but I Already have this problem:

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).

I tried to go into the cloud shell and type:
set global max_allowed_packet = 1073741824;

nothing happend, I have the same problem, and as you can imaging it´s
the worst moment to happend... I tried to take the csv file from ODK
Briefcase by first pulling all the information, when pulling it at some
point it says "FAILED" But I think it might be downloading everything so I
can generate the CSV file, but instead of links to the media of my forms in
the cloud it give me links to my local folder... a bummer... any help?

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
" A warrior doesn't give up what he loves... he finds the love in what he
does."

14

Sort of, maybe it works for you, check here:
https://groups.google.com/forum/#!searchin/opendatakit/WILL$20RETRY$20LATER/opendatakit/hjMKcHkk1tc/D3h0h6pgBQAJ

Regards,

Pablo

··· On Wed, May 4, 2016 at 8:36 AM, Poloko Owen Rabai wrote:

Pablo Rodríguez, are you saying you found assistance ? if yes please let
me know or give me the link to the solution.

On Tue, May 3, 2016 at 2:22 PM, Pablo Rodríguez < nuncaestardesillegaspronto@gmail.com> wrote:

Hi Yaw,

I just did. Thank you very much for your help.

Regards,

Pablo

On Tue, May 3, 2016 at 10:17 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi there,

If you are still having problems, please start a new thread describing
what you've tried so far.

Yaw

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

On Wed, Apr 13, 2016 at 10:20 AM, nuncaestardesillegaspronto@gmail.com wrote:

El viernes, 31 de enero de 2014, 13:03:50 (UTC+1), Kanhu Bhol escribió:

Hello Friends,

On ODK Aggregate, when i want to export my data to .csv file,Its
shows me error (Failure - will retry later).
I notice when data size more than 100 row or data table is big then
only this error occur. Can any one please give some idea about how to
resolved from this error.

Thanks
Kanhu

Hi guys,

I´m kind of new here, but I Already have this problem:

On ODK Aggregate, when i want to export my data to .csv file,Its shows
me error (Failure - will retry later).

I tried to go into the cloud shell and type:
set global max_allowed_packet = 1073741824;

nothing happend, I have the same problem, and as you can imaging it´s
the worst moment to happend... I tried to take the csv file from ODK
Briefcase by first pulling all the information, when pulling it at some
point it says "FAILED" But I think it might be downloading everything so I
can generate the CSV file, but instead of links to the media of my forms in
the cloud it give me links to my local folder... a bummer... any help?

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
" A warrior doesn't give up what he loves... he finds the love in what he
does."

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/a5mHI-cshO0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.