Download Form Exports gets stuck / hangs

Lerner_Jonathan_A_Ph · February 15, 2016, 2:48pm

Hi -

I am trying to run a bulk export of all form data (33 forms) for the entire
length of the study to date (the period 2015-09-01 to 2016-02-11), but when
I try to do this, CommCare hangs at “Collecting Data.” I have repeatedly
let the query run for several hours, but nothing happens.

When I try to run the same export with a more limited time frame (past
month), I get varied results. I have tried running each of these exports
separately several times, with the same results each time.

Here is a list of date parameters and the resulting response:

2015-09-01 to 2015-09-30 (works)
2015-10-01 to 2015-10-31 (works)
2015-11-01 to 2015-11-30 (hangs / gets stuck)

···

- *2015-12-01 to 2015-12-31 (hangs / gets stuck) * - 2016-01-01 to 2016-01-31 (works) - 2016-02-01 to 2016-02-11 (works)

Has anybody run into this type of issue before, and if so, are there any
solutions that have resolved the problem?

Thanks!

Jonathan
KEYWORDS: bulk export, download form data, query, stuck, hangs, data
export, JAL

Biello_Katie · February 15, 2016, 2:57pm

I have tried as well and am having the same problem.

Thanks,
Katie

Katie B. Biello, PhD, MPH
Assistant Professor
Departments of Behavioral & Social Sciences and Epidemiology
Institute for Community Health Promotion
Brown University School of Public Health
Tel: 1 (401) 863-3082

Research Scientist
The Fenway Institute
Fenway Health
Tel: 1 (617) 927-6366

···

On Mon, Feb 15, 2016 at 9:48 AM, jalerner wrote:

Hi -

I am trying to run a bulk export of all form data (33 forms) for the
entire length of the study to date (the period 2015-09-01 to 2016-02-11),
but when I try to do this, CommCare hangs at “Collecting Data.” I have
repeatedly let the query run for several hours, but nothing happens.

When I try to run the same export with a more limited time frame (past
month), I get varied results. I have tried running each of these exports
separately several times, with the same results each time.

Here is a list of date parameters and the resulting response:

2015-09-01 to 2015-09-30 (works)

2015-10-01 to 2015-10-31 (works)

2015-11-01 to 2015-11-30 (hangs / gets stuck)

*2015-12-01 to 2015-12-31 (hangs / gets stuck) *

2016-01-01 to 2016-01-31 (works)

2016-02-01 to 2016-02-11 (works)

Has anybody run into this type of issue before, and if so, are there any
solutions that have resolved the problem?

Thanks!

Jonathan
KEYWORDS: bulk export, download form data, query, stuck, hangs, data
export, JAL

czue · February 16, 2016, 5:46am

Hello,

This sounds like a specific issue with your project space. If you report an
issue from the question mark in the header someone on our support team will
take a look and report back.

Cory

···

On Mon, Feb 15, 2016 at 4:57 PM, Biello, Katie wrote:

I have tried as well and am having the same problem.

Thanks,
Katie

Katie B. Biello, PhD, MPH
Assistant Professor
Departments of Behavioral & Social Sciences and Epidemiology
Institute for Community Health Promotion
Brown University School of Public Health
Tel: 1 (401) 863-3082

Research Scientist
The Fenway Institute
Fenway Health
Tel: 1 (617) 927-6366

On Mon, Feb 15, 2016 at 9:48 AM, jalerner jalerner@mgh.harvard.edu wrote:

Hi -

I am trying to run a bulk export of all form data (33 forms) for the
entire length of the study to date (the period 2015-09-01 to 2016-02-11),
but when I try to do this, CommCare hangs at “Collecting Data.” I have
repeatedly let the query run for several hours, but nothing happens.

When I try to run the same export with a more limited time frame (past
month), I get varied results. I have tried running each of these exports
separately several times, with the same results each time.

Here is a list of date parameters and the resulting response:

2015-09-01 to 2015-09-30 (works)

2015-10-01 to 2015-10-31 (works)

2015-11-01 to 2015-11-30 (hangs / gets stuck)

*2015-12-01 to 2015-12-31 (hangs / gets stuck) *

2016-01-01 to 2016-01-31 (works)

2016-02-01 to 2016-02-11 (works)

Has anybody run into this type of issue before, and if so, are there any
solutions that have resolved the problem?

Thanks!

Jonathan
KEYWORDS: bulk export, download form data, query, stuck, hangs, data
export, JAL

–
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Lerner_Jonathan_A_Ph · February 17, 2016, 4:29pm

Thanks, Cory. I have submitted the issue as you suggested.

Best,

Jonathan

···

From: Cory Zue <czue@dimagi.com> Date: Tuesday, February 16, 2016 at 12:46 AM To: "commcare-users@googlegroups.com" <commcare-users@googlegroups.com> Cc: "Jonathan Lerner, Ph.D." <JALERNER@mgh.harvard.edu>, Meryn Robinson <mrobinson@dimagi.com>, "Bedoya, C. Andres,Ph.D." <ABEDOYA@mgh.harvard.edu>, "Ehlinger, Peter P." <PEHLINGER@mgh.harvard.edu> Subject: Re: Download Form Exports gets stuck / hangs

Hello,

This sounds like a specific issue with your project space. If you report an issue from the question mark in the header someone on our support team will take a look and report back.

Cory

On Mon, Feb 15, 2016 at 4:57 PM, Biello, Katie <katie_biello@brown.edu mailto:katie_biello@brown.edu> wrote:
I have tried as well and am having the same problem.

Thanks,
Katie

Katie B. Biello, PhD, MPH
Assistant Professor
Departments of Behavioral & Social Sciences and Epidemiology
Institute for Community Health Promotion
Brown University School of Public Health
Tel: 1 (401) 863-3082tel:1%20(401)%20863-3082

Research Scientist
The Fenway Institute
Fenway Health
Tel: 1 (617) 927-6366tel:1%20(617)%20927-6366

On Mon, Feb 15, 2016 at 9:48 AM, jalerner <jalerner@mgh.harvard.edu mailto:jalerner@mgh.harvard.edu> wrote:
Hi -

I am trying to run a bulk export of all form data (33 forms) for the entire length of the study to date (the period 2015-09-01 to 2016-02-11), but when I try to do this, CommCare hangs at “Collecting Data.” I have repeatedly let the query run for several hours, but nothing happens.

When I try to run the same export with a more limited time frame (past month), I get varied results. I have tried running each of these exports separately several times, with the same results each time.

Here is a list of date parameters and the resulting response:

2015-09-01 to 2015-09-30 (works)
2015-10-01 to 2015-10-31 (works)
2015-11-01 to 2015-11-30 (hangs / gets stuck)
2015-12-01 to 2015-12-31 (hangs / gets stuck)
2016-01-01 to 2016-01-31 (works)
2016-02-01 to 2016-02-11 (works)

Has anybody run into this type of issue before, and if so, are there any solutions that have resolved the problem?

Thanks!

Jonathan
KEYWORDS: bulk export, download form data, query, stuck, hangs, data export, JAL

–
You received this message because you are subscribed to the Google Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.com mailto:commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.