topic Re: Data not loading on Data tab in Survey123 online in ArcGIS Survey123 Questions

Data not loading on Data tab in Survey123 online

SaraMiller — Tue, 23 Mar 2021 09:53:29 GMT

Suddenly at the end of last week, the data view tab in survey123.arcgis.com stopped loading data and is showing the loading icon constantly. This is happening for a set of 10 different surveys, but not for a couple other surveys I created previously.

I can view the data in AGOL via Content > survey folder > feature layer > data so I know it's going through, but other users need to be able to view, edit, and export data from Survey123 online.

I cleared my Chrome browser cache and it hasn't resolved the issue.

Reviewing previous posts, I do not have any select_one fields with only one option in any of these surveys.

I've unshared the surveys & results with the testing permission group, deleted the stakeholder feature layer, and re-shared with the group to recreate the stakeholder feature layer, which seemed to fix it temporarily but now data is loading inconsistently again. It seems if I click around to different tabs (Overview, Collaborate, Data), sometimes the data eventually loads in the Data tab, but it never loads when going directly to the Data for a survey from My Surveys.

Attached: screenshot of Data tab hanging
Survey123 version 3.11.164
Survey123 Connect version 3.11.123

Re: Data not loading on Data tab in Survey123 online

IsmaelChivite — Tue, 23 Mar 2021 17:31:34 GMT

@SaraMiller Can you share a HAR file? https://www.medianova.com/en-blog/2019/07/15/a-step-by-step-guide-to-generating-a-har-file This would allow an easier diagnosis of the problem.

Re: Data not loading on Data tab in Survey123 online

SaraMiller — Tue, 23 Mar 2021 17:47:38 GMT

Hi Ismael,

Thanks for getting back to me. Is the attached file helpful?

Re: Data not loading on Data tab in Survey123 online

WerkgroepGIS — Tue, 30 Mar 2021 08:24:32 GMT

same problem over here

Re: Data not loading on Data tab in Survey123 online

IsmaelChivite — Wed, 31 Mar 2021 22:26:55 GMT

@ZhifangWangCould you please have a look? See HAR file above.

Re: Data not loading on Data tab in Survey123 online

ZhifangWang — Thu, 01 Apr 2021 08:19:09 GMT

Hi @SaraMiller ,

It turns out there is only one network request info in your attached .har file. To save all requests which helps our investigation, can you please:

In Chrome, open the developer tools, switch to the Network panel
Refresh the Data page
On any request in the Network panel, right click, “Save all as HAR with content". Please see the attached image.

In addition,

Can you please check if your survey is similar to the case "first question in the survey is a note question AND followed by a group or repeat AND all questions in the group or repeat"? This is a known bug, it can also be confirmed by trying the workaround mentioned in the bug description.
Can you please confirm the issue only occurs since the last week but never happens before? We had a small update to the Survey123 website yesterday but there is no update in the last week.

Thanks,

Zhifang

Re: Data not loading on Data tab in Survey123 online

SaraMiller — Thu, 01 Apr 2021 10:14:19 GMT

Thanks for getting back to me, ZhifangWang. I've tried to attached multiple HAR files from different surveys but they're all >45,000KB so the uploader won't accept them. Is there some other way I can get these to you?

Yes, all of these surveys are set to pages style using groups with a field-list appearance, and all of them start with an introduction section page(s) with note fields. So the first field for each app is a 'begin group' followed by 'note'.

To implement the bug solution, do I have to do both things listed, e.g., add a non-note question as well as use the URL to make the Data tab load? If I were to add a non-note field at the beginning, would it be before or after row 2 'begin group' or row 3 'note'? Would a hidden field be okay to use, and would it be okay to make this field null for fieldType, or does it need to appear in the feature table?

Yes, the issue only started a couple weeks ago, around the end of the w/c 15th March, but I'm not sure what exact date.

I have attached a copy of one of the survey forms.

Re: Data not loading on Data tab in Survey123 online

SaraMiller — Thu, 01 Apr 2021 10:25:08 GMT

survey form attached

Re: Data not loading on Data tab in Survey123 online

ZhifangWang — Thu, 01 Apr 2021 10:29:29 GMT

Hi @SaraMiller ,

Upload the .har file to a storge service e.g. OneDrive and share the URL with us or send/attach the XLSForm file can both help us to investigate. It seems that you forgot to attach the XLSForm file in your last reply.

If your case is the same as the known bug, either the alternate solution can confirm or fix the issue. I recommend you try with the URL one which is easier to test. If it is the case, the non-note question can be hidden so it will not affect end users.

Thanks,

Zhifang

Re: Data not loading on Data tab in Survey123 online

SaraMiller — Thu, 01 Apr 2021 10:43:30 GMT

Hi @ZhifangWang

Using the URL https://survey123.arcgis.com/surveys/<itemID>/analyze?filter=(0.objectid%20isGreaterThan%200) successfully loads the Analyze tab.

Using the URL https://survey123.arcgis.com/surveys/<itemID>/data?filter=(0.objectid%20isGreaterThan%200) successfully loads the Data tab.

The sample XLSForm is now attached.

Here is a OneDrive link to a Troubleshooting folder with HAR files in it, but I'm not sure our security settings will allow external access.

Sara

Re: Data not loading on Data tab in Survey123 online

ZhifangWang — Thu, 01 Apr 2021 11:27:29 GMT

Hi @SaraMiller ,

I can reproduce the issue by using the XLSForm file and confirm it is the same issue BUG-000138475 mentioned above.

We will fix the issue in the next 3.13 release (planned in June). Before the fix, please use either alternate solution instead.

Thanks again for your feedback.

Regards,

Zhifang

Re: Data not loading on Data tab in Survey123 online

SaraMiller — Thu, 01 Apr 2021 11:29:09 GMT

Thank you for your help, and for getting the bug fixed in the next release.

Kind regards,

Sara

Re: Data not loading on Data tab in Survey123 online

Todd — Fri, 02 Apr 2021 20:53:39 GMT

Same problem here. Cleared everything in Firefox. Opening Data tab and it still wants to append ?report=format:docx on the url. Cannot access anything functional using the Analyze or Data tabs.

SOLVED: moved my 'deviceid' field from the bottom to the top, after the 'begin group' record and before the 'note' record. Now I can see data in the 'Data' tab.

Re: Data not loading on Data tab in Survey123 online

OliviaHurd — Wed, 12 May 2021 21:53:39 GMT

Same issue here and have found no way to create a feature report from the data tab. I have not found a work around for this except downloading the whole excel spreadsheet of data from ArcGIS Online and sending single lines to the corresponding contractors for their reporting & billing needs.

Re: Data not loading on Data tab in Survey123 online

Ruth_JiatengXu — Mon, 17 May 2021 03:04:45 GMT

Hi @SaraMiller @OliviaHurd @Todd @WerkgroepGIS ,

The fix for this issue is already on production, the analyze and data pages should work fine now, could you please try again and let us know if there is any problem?

Thanks,

Ruth

Re: Data not loading on Data tab in Survey123 online

Marie-LouLabuschagne — Wed, 09 Jun 2021 19:01:08 GMT

Any update on when version 3.13 will be released?

Re: Data not loading on Data tab in Survey123 online

ZhifangWang — Tue, 15 Jun 2021 11:41:25 GMT

Hi @Marie-LouLabuschagne ,

The 3.13 release is currently planned in late July and is subject to change. The original BUG-000138475 in this thread is already fixed in an update to the Survey123 website in mid-May.

Do you still observe any issue that fails to load the Data page?

Re: Data not loading on Data tab in Survey123 online

DeniseTolness1 — Wed, 27 Jul 2022 16:22:27 GMT

I am using Survey Connect 3.15.165 and I can not access the data, overview or analysis tabs in Survey 123. I need the data tab to function so we can export reports. Older surveys published in connect3.9 work fine. I did a save as from an older survey to a new survey in 3.15.165 published and still it does not open in the web data tab. I've cleared my cache, I've tried going directly to the data tab via the url, there is no note filed at the begining it is a text question. I'm at a loss of what to do now. I even tried making a simple new survey and publishing that and still it does not work

Re: Data not loading on Data tab in Survey123 online

Ruth_JiatengXu — Thu, 28 Jul 2022 03:03:30 GMT

Hi @DeniseTolness1

Thank you for sharing your question here! Could you please answer a few questions, so that I can help you locate the cause of the issue?

When you save your old form to a new form, does the new form has any data attached to it? If there is no submission to the form, the overview, analyze, and data page will not be able to show. In this case, you will see the "The survey has no records yet. Please check again later" msg.

If this is not the case, could you please let me know:

1. Which method did you use to connect the new survey to the existing dataset? e.g. submission url

2. what is the behavior of the data, overview, and analyze pages? If there is any msg appearing on the page or the page cannot be loaded completely?

Thanks,

Ruth

Re: Data not loading on Data tab in Survey123 online

DeniseTolness1 — Thu, 28 Jul 2022 12:58:57 GMT

@Ruth_JiatengXu The new form has no data in it. But when accessing through the Survey123 web page the data, overview and analysis tabs don't ever come back with the standard "The survey has no records yet. Please check again later" msg. All you get is the thinking bars never any messages. I tried accessing through AGOL to the survey app as well as directly through the URL both had same results. I can go into AGOL and access the feature service there. I can go onto my tablet and submit a survey. The data is in the feature service but still even with data in the survey the data, overview and analysis tabs do not open, I sat on the data tab for an hour and just saw the thinking bars and had to close the app to get out of the window,

Our AGOL Administrator Guru guy changed something on the back end yesterday morning and now everything is working ok. As I understand it he added the https://blm-egis.maps.arcgis.com to a configuration to allow this site to send data out to other applications. So what was happening when the Survey123 app went to retrieve the data it was not getting the feature service information back and now it is. I'm not sure exactly what he did, he was fixing a different issue for someone else and it resulted in my survey123 app now working.

Thank you for responding so quickly for me but I think the issue got resolved