topic Re: Results View Contains Additional Tables compared to Main Feature Layer in ArcGIS Survey123 Questions

Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 14 Aug 2024 11:43:48 GMT

I have been troubleshooting an issue with the Survey123 website not loading a selected entry properly in the panel that pops up to show the details in the form view, it just spins endlessly. Through this we have noticed that the surveys that seem to have the issue all have an additional table in the results view.

Main Layer:

Results View:

Has anyone else encountered this? Any ideas what causes this?

I'm trying to figure out how this would have happened and I can't come up with anything unusual that I would have done, I simply share the results from the Collaborate tab on the Survey123 website, and it creates the results view automatically.

This explains why I had issues updating the view from the Settings tab in the item details for the view as well (the questions were all mismatched for the respective tables) though I feel that Survey123 publishing should do this automatically too.

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Wed, 21 Aug 2024 15:11:59 GMT

How did I miss this question?Just found it via your Idea.

I checked my View layers, and I don't see any additional layers/tables (Enterprise 11.3).

However, I create all my view layers from the Portal rather than the S123 Website. Not sure that would have any affect though. Maybe there was a hiccup in the communication between servers resulting in a duplicate layer?

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 21 Aug 2024 15:27:14 GMT

No idea, there were a few things I posted in the last little bit I was surprised not to get a notification from you on haha

All of my surveys are hosted in AGOL not Enterprise so it might make a difference, all are published via Connect, but the views would be created automatically when picking the sharing settings on the S123 website. I have no idea how it happened, or when honestly, which makes it harder to track down the exact cause. A hiccup is definitely possible, they're numbered differently though so it should have been able to tell what was there?

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Wed, 21 Aug 2024 15:42:24 GMT

Now I feel bad! I will have to scroll through the list again lol.

The numbering is basically an OID starting at 0 and is generated when an item is created. Given that, I would guess that the duplicate layer was created when the view was originally created. Otherwise, I'm not sure how they would be 0 and 1, respectively. If it happened later, I'd expect to see the original as 0 and the new one as 4.

We actually had an odd thing happen late last week with those ids. A layer was (I assume) republished by someone, and the layer Id changed from 0 to 1, breaking our Web Apps. Once I realized what happened, I had to jump through some hoops to restore widget functionality. Not quite the same issue you are seeing though.

Maybe just recreate the View an monitor for now?

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 21 Aug 2024 19:20:54 GMT

Haha no worries! I figured maybe you were on vacation or something lol.

That's a good point, it is odd that it is 0 and 1 like that, though I wonder if it's because it's the primary feature layer and then the rest are related tables, it would always be put as the higher number?

When I try the update view, it shows me the 4 expected tables, but the fields are like:

Mowing Work Orders (0) --> Mowing Work Orders (0)
assetRepeat (1) --> Mowing Work Orders (1)
employee_repeat (2) --> assetRepeat (2)
vehicle_repeat (3) --> employee_repeat (3)

So the fields don't line up, I have no idea what it will do if I try to proceed with updating the view, I'm worried to try when it's live data lol.

I figure it was a publishing error somewhere along the line, but in the Survey123 environment, I haven't seen anyone else complain about it though so.

I am planning on deleting and resharing the results views, I have done that on one of the surveys I have already and that's how I found it as a solution, I just wanted to try and find the cause as well.

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Wed, 21 Aug 2024 19:49:27 GMT

The good things about View layers is they don't actually contain any data. So even if it's live data, creating a new View in the Portal and have it exist adjacent to the current View shouldn't negatively affect anything. Then, when you confirm it's working properly, you can essentially swap layer IDs in apps.

I did something similar to this recently when I needed to make a big app update. Worked a lot smother than I was expecting!

I agree though. I hate not knowing the cause of something, even if the issue is "resolved".

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Thu, 22 Aug 2024 12:41:53 GMT

I don't know that it's quite as straightforward for AGOL Survey123 layers, I think I need to delete the existing before I create the new one because I don't have control over what the Survey123 website links like you would with Enterprise apps.

I have used this strategy in other cases though! I still feel like I have lots to learn about best practices around views, but they are certainly handy.

Yeah I hate it too, cause what if it happens again? This is why I wanted to bring it up to make sure Esri sees it and others can find the issue too if it happens to them.

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Thu, 22 Aug 2024 15:56:37 GMT

I just tried this delete and re-create method and somehow the new version of the view created simply by sharing the results in the Survey123 website also has the additional table... weird.

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Thu, 22 Aug 2024 16:05:09 GMT

Hmm. So maybe not a mistake then? I'm at a loss.

If you go to the "Schema" tab in Connect, I assume you see what you'd expect to see?

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Thu, 22 Aug 2024 16:21:52 GMT

Yeah I see the expected tables, only one of the core table, and the main hosted table has the expected results as well, it's only when the results view is created that it does this.

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Thu, 22 Aug 2024 16:31:19 GMT

If it did the same thing twice, I'm sure there is a super obvious reason... but I have no idea what that reason would be 😞

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Thu, 22 Aug 2024 18:41:07 GMT

I just tried it on two separate surveys and it recreated the error number of tables on both.

Yet when I tried this on one earlier in July it did not recreate the extra layer, and seems to have solved the loading issues on the Survey123 website form view.

The only differences that jump out immediately ar ethe two that remain glitched are hosted tables not layers and they would have ORIGINALLY been published in different versions of Survey123 Connect, but they have been republished in the same version since.

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Tue, 03 Sep 2024 18:15:11 GMT

In contacting Esri Support, after much digging, they have found it appears connected to BUG-000147659 for ArcGIS Online (esri.com)

The stakeholder or results view layer created from the ArcGIS Survey123 Collaborate tab generated a duplicate table in ArcGIS Online.

A published survey with a map question with the field type set to null, Survey123 Connect publishes a hosted table instead of a hosted layer. Then when you share the survey results, it creates a duplicate table in the results view layer.

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 04 Sep 2024 12:12:12 GMT

So I attempted to fix it by removing the null geopoint type question from my survey, republishing, deleting the results view, then re-sharing it.

This did not work, the new view continues to have extra tables. This seems to be purely because of the original created hosted table as opposed to a layer. It seems like the only solution is to publish a completely new survey (or potentially delete the hosted table and re-publishing to create it as a layer?)

I wonder, in AGOL, can you manually create the results view instead of having the collaboration settings on the Survey123 website create it?

EDIT: No you cannot manually create the view, the Survey123 website does not recognize it as the results view even when using the proper name. This leads to the odd situation of now having two items named the exact same thing in AGOL, which seems like an issue?

Re: Results View Contains Additional Tables compared to Main Feature Layer

abureaux — Wed, 04 Sep 2024 16:11:26 GMT

Glad you are starting to see some progress on this!

I'm sure the programs only look at itemId, so the technical answer is probably "not an issue". But still not something I'd be willing to trust. The human-level confusion alone I think justifies deleting one.

Seems like the simple solution is to recreate the survey from scratch after that geopoint change.

I feel like geopoints have been the culprit of a few AGO-specific issues recently.

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 04 Sep 2024 16:54:32 GMT

I swear I've had AGOL tell me before I can't create something because the name is already in use, but yeah I do suspect the itemID is what everything references.

Ah if only simple were so simple on a live survey being used regularly all day and tied into Power Automate and Power BI. But I have tried everything I can think of for a solution that isn't that, so I'll just have to find the right time to do it I guess.

Re: Results View Contains Additional Tables compared to Main Feature Layer

RobertAnderson3 — Wed, 11 Sep 2024 12:06:01 GMT

The issue seems to have gotten worse, now the Data page as a whole just doesn't load for these surveys lol

Survey123 Website Data Page No Longer Loading on S... - Esri Community