Select to view content in your preferred language

Broken links between feature layer and related table

136
2
11-12-2024 11:58 AM
CamKenny2
Occasional Contributor

I have a survey that I published where there were a bunch of records collected over the summer of 2024.

The survey contains repeats.  I am collecting a GPS point for the main site and then within the repeat I am collecting a GPS point at each transect location.

To make things a little more complex, each GPS point in the repeat has another repeat where I collect text based attributes.

Everything was working very well for us and we collected a lot of successful data, but for some reason or another after I was working on the data in ArcGIS Pro, the tables that are "related" are not showing up the feature dataset description or in the data view.  If I go into Pro or even the Survey123 tab and look at the data, the tables are still there, but they are just not related any longer.

I republished the survey from connect but that didn't seem to fix the problem.

I am hoping I can salvage this as a lot of work went into the creation of the Survey as well as the data collection.

0 Kudos
2 Replies
ZacharySutherby
Esri Regular Contributor

Hey @CamKenny2

Do you happen to know a general timeline when this behavior started, additionally is your data in ArcGIS Online, ArcGIS Enterprise, or an Enterprise Geodatabase? The reason is because ArcGIS Online updated very recently so there may be some impact from that. 

Feel free to reach out to Esri Technical Support for help with this workflow but the best way to check what's going on with the layer relationships is to navigate to the Admin REST endpoint for the feature service. This would look something like https://services.arcgis.com/ABC123.../arcgis/rest/admin/services/service_<survey>/FeatureServer. 

Viewing the JSON of that page there will be a `relationships` property in the JSON for each layer.

It would be best to verify all expected relationships are present for their respective layer.

If not the feature service definition will need to be updated to add the relationships 

 

Thank you,
Zach
0 Kudos
CamKenny2
Occasional Contributor

It happened yesterday (November 12th).  It is within ArcGIS Online and the survey was published there and was working this summer.

Yesterday, I was working with the feature layer in ArcGIS Pro and was changing/updating the data and I noticed it wasn't updating the data in ArcGIS Online.  So rather than checking if there were unsaved edits, I performed a "Overwrite web layer" and that's when I noticed in the hosted feature layer item description that the tables were no longer listed within the description.  But....for some reason, the two tables are still somewhere is ArcGIS Online and when I view the data is Survey123 through ArcGIS Online, everything works as it is should and all the records are properly related.

I know it was a rookie move to overwrite the web layer and realize my stupidity now, but just wondering if I can fix it.

I tried republishing the survey in Survey123 Connect hoping that would fix things, but it didn't help.  I even tried adding a new survey in Survey123 and it works - as in the data is all there, it just doesn't show the two tables in the feature layer's description and I can't seem to find them as standalone tables in ArcGIS Online.

0 Kudos