topic Re: Survey123 Export Not completing in ArcGIS Survey123 Questions

Survey123 Export Not completing

JamesHolland — Tue, 02 Mar 2021 05:09:03 GMT

Has anyone had Survey123 fail to export? I've been trying to export in every available format and the export wheel animation is all that occurs with no output.

Re: Survey123 Export Not completing

ZhifangWang — Tue, 02 Mar 2021 12:56:55 GMT

@JamesHolland ,

Can you please provide more details about the issue?

Did you export on the Data page of the Survey123 website or export on the feature service item page in ArcGIS Online?
Did you observe the issue before the latest February 2021 release?
Is your survey published from the Survey123 website or Survey123 Connect?
- If it is published from Survey123 Connect, would you mind sharing the XLSForm file with us?

Re: Survey123 Export Not completing

RobBlash — Tue, 02 Mar 2021 13:56:32 GMT

I'm experiencing the same issue, I cannot export to CSV from the Survey123 website. Also, I have nightly scripts that run and backup my Survey123 data to CSV which is also failing (previously ran fine in the early AM hours of March 1st, eastern time zone, and for >1 year prior). I have not yet tried other methods. I will try now and report back.

Edit:

The toolbar on the Survey123 site is no longer loading so I can't test any more exports via the S123 page. I just tried a CSV export directly from the hosted feature service and it failed (gave a long error message with code 504).

Edit2:

Trying an excel export directly from hosted feature service. The process seems to be hung, the export does not typically take this long (update - just threw the same 504 error)

@ZhifangWang FYI, looks like this may be a widespread issue. I'm going to submit a support ticket now.

Re: Survey123 Export Not completing

JamesHolland — Tue, 02 Mar 2021 22:00:16 GMT

Its been with the former not the latter. Yesterday was the first day it was observed. Published from connect.

The issue seems to have resolved itself so ill hold off on the sharing of the form.

Re: Survey123 Export Not completing

JamesHolland — Tue, 02 Mar 2021 22:00:50 GMT

Mine seems to have solved itself this morning though I doubt thats of any use.

Re: Survey123 Export Not completing

ZhifangWang — Wed, 03 Mar 2021 12:50:59 GMT

@JamesHolland @RobBlash ,

Thank you both for the update.

We also encountered 50X error a few times today when querying data to ArcGIS Online hosted feature services so it probably be a wider issue. It is helpful to raise a ticket to Esri Support Service.

Please let us know in case if you encounter such an issue consistently.

Re: Survey123 Export Not completing

RogerFarmer1 — Thu, 16 Sep 2021 01:07:45 GMT

I am also getting a failure to open the file error for Excel and CSV files.

It is an SDE service (not hosted) on Enterprise 10.8.1 with a survey created in Connect 3.12.

I tried attaching the files to this post but got a similar error!

"Excel cannot open the file 'S123_7c9ce029fb2d4d20a981b5bb4f9cdc0e_EXCEL.xlsx' because the file format or file extension is not valid. Verify that the file format or file has not been corrupted and that the file extension matches the format of the file."

Re: Survey123 Export Not completing

ZhifangWang — Thu, 16 Sep 2021 08:54:56 GMT

Hi @RogerFarmer1 ,

Survey123 website utilizes the /export operation in ArcGIS Online/ArcGIS Enterprise to export survey data. Would you mind trying to export the data from the item details page of the survey layer in ArcGIS Enterprise to see if the issue still occurs? This helps to locate if the issue resides in ArcGIS Enterprise or Survey123.

Re: Survey123 Export Not completing

JeffHyder — Wed, 19 Jan 2022 12:53:46 GMT

I am having this problem today will not export in any format. What is the solution?

Re: Survey123 Export Not completing

Abdullah_AlFazari — Thu, 24 Feb 2022 07:10:30 GMT

Hi Team,

I'm also experiencing the same issue, any thoughts?

Re: Survey123 Export Not completing

Abdullah_AlFazari — Thu, 24 Feb 2022 07:15:16 GMT

I just tried to export the data as CSV and it worked smothly. Good luck!

Re: Survey123 Export Not completing

Faris_RassoulliRizal_Wong — Fri, 21 Jul 2023 03:39:01 GMT

I noticed that my users (with Publisher role) who are members of Shared Update groups in my ArcGIS Enterprise (version 11.0) to which I've shared my survey to (via Survey123 website's Update Survey setting) would have this problem (export not completing ever).

When I checked my ArcGIS Server logs from Server Manager website, there a severe error logged: "Error executing tool. Export Service Job ID: j4d1d6ebeabeb46ec81b530b9d4199ba7 : ERROR 999999: Something unexpected caused the tool to fail." and "ERROR: Premission denied. Extract capability not enabled in service." (see attached image).

The last error message made me want to check the settings of the hosted feature layer view that was created automatically when I shared my survey to the shared update group in the first place (SurveyName_results). Sure enough, the view's "Allow others to export to different formats." has been enabled. So, what the h*ck is wrong then?

I didn't stop there. Next, I went to check the same setting in the hosted feature layer which was created when I published the survey - it is disabled. I would have expected it to be so because I've only allowed submitters to add new records ie. read access is disabled. Despite this setting, my users have no problem seeing the survey's data in the Data and Analyze tabs though.

One thing that surprised me is when I manually enabled the "Allow others to export to different formats." setting on the survey's hosted feature layer & then tried the exporting the survey's data again from the Survey123 website using one of my user's credentials (a member of the shared update group), it works! The problem with this is, it changes other settings on the layer such as the "What features can editors see?" from "Editors can't see any features, even those they add" to "Editors can see all features" - essentially allowing read access to the layer. I won't have this because my survey is a publicly shared survey (the data is provided by the public). I don't want the public to have access our data let alone modify existing data in the layer.

So, my question to ESRI / @ZhifangWang is, why does the Survey123 website use the survey's original hosted feature layer for data exporting when a user from a shared update group (not the survey owner or creator) performs the export instead of the SurveyName_results hosted feature layer view?

One peculiar thing, this problem does not happen to members of normal groups (non-shared update groups) when a survey's result is shared to them. Also, I noticed the problem existed when I was on ArcGIS Enterprise 10.8.2. So, maybe this problem has nothing to do with ArcGIS Enterprise (more to do with how the Syrvey123 website operates)?

If I don't get a solution here, I'm opening a support ticket with ESRI Tech Support.