nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Display Name and Field Name of Related tables

DEI

Hello,

I downloaded a FGDB which includes a point layer and 6 related inspection tables from AGOL. In Pro added new names to an existing domain, deleted a field from the feature class that was supposed to be of Data Type Date but was incorrectly created as Text, recreated the field with Data Type Date, tried both overwriting and re-publishing to AGOL and each time the related table Display Names and Field Names show up blank in the Data tab.

I cannot select anything below the Display and Field Names in order to edit the names. Layers show up fine in Field Maps and Field crews can add data but I cannot re-create Arcade expressions because FeatureSetByRelationshipName( ... ) is blank.

Does anyone know how to resolve this?

Find more posts tagged with

Content Management

Mapping

Arcade

Accepted answers

All comments

DEI

Some additional info. I found that the forward and backward labels within the relationship class properties are blank in Pro. Not sure if this is part of the issue but this is what the dialog should look like according to online documentation:

And this is what mine looks like (no “Forward Path Label” or “Backward Path Label” option to edit):

Strahanjen

Did you ever resolve this? I'm having the same issue and would love some advice on how to fix it.

DEI

Nothing yet.

However, because Display and Field Names remain blank, I've been able to work around the issue by using FeatureSetByRelationshipName($feature,""). Not ideal but it works in most of my cases.

Strahanjen

Thanks, I determined that the only way to solve this issue is to delete the relationship classes in Pro and then create them again. After doing that, I overwrote the existing feature service in ArcGIS Online.

MJBiazar

Hi @DEI ,

When creating a relationship class, you can specify the Forward/Backward Path Label. These labels are carried over to the hosted feature layer. This label is what FeatureSetByRelationshipName( ... ) uses to reference a relationship in a feature service.

If you export your feature layer as a file geodatabase from ArcGIS Online, the Forward/Backward Path Labels are dropped, so when the layer is published back to ArcGIS Online, the relationships in the hosted feature won't have the labels initially specified when the relationship class was created.

A defect (#BUG-000149669) has been logged against this behavior. In the meantime, it seems that in the meantime, the workaround is to recreate the relationship class in Pro and reassign the Forward/Backward Path Labels.

Best,

mikaël

I still have the problem.

I downloaded a GDB from AGOL, created a new GDB, used feature class to feature class tool to convert 3 features classes from the old to the new GDB, then created 2 new relationship classes, zipped the GDB, uploaded to AGOL and the display name online is the relationship class name.

Python commands (with "layer1", "layer2" and "layer3" being used as tests for display name and "RelTerrainsActifs" and "RelTerrainsPlaces" as relationship names):

arcpy.management.CreateRelationshipClass("terrains", "actifs", "RelTerrainsActifs", "SIMPLE", "layer2", "layer1", "NONE", "ONE_TO_MANY", "NONE", "terrain_no", "terrain_no")

arcpy.management.CreateRelationshipClass("terrains", "places", "RelTerrainsPlaces", "SIMPLE", "layer3", "layer1", "NONE", "ONE_TO_MANY", "NONE", "terrain_no", "terrain_no")

ArcGIS Pro result (in French but you can see the relation names "layer2" and "layer3":

Online result showing relationship names and not display name:

If instead I publish directly from ArcGIS Pro with "share as web layer", then I do get the display name, but the relationship name is also the display name (which I guess is ok?):

When publishing directly from ArcGIS Pro, a Service definition is also created on AGOL with the same name as the newly created hosted feature layer (while when zipping the GDB and uploading it manually, there is no service definition. Could this be the cause?

AnthonyJonesRSK

Hi MJ,

Just wondering if there is any progress on this bug?

Thanks

Anthony

elpinguino

Same here.

BRENNEJM

Just looked up that bug (#BUG-000149669) and the status is "Under Consideration". I don't know how this isn't a higher priority for Esri. The bug literally breaks the database on download and recreating the relationship classes isn't a viable workaround when I have 140 relationships in my GDB. My workflow involves periodic exporting of the FGDB, adding new feature classes or tables and new relationship classes, and then overwriting the existing hosted feature layer. I realize these new layers can be added using the REST API and "Add to Definition", but this workflow would be a much easier/safer option for us.

Caitlin_Todd_LCOR

I hope others share their experiences with ESRI on this. Because of this bug my organization can't use ESRI Solutions. Because downloading as a FGDB to modify the feature layers to fit our needs and then overwriting the online layer breaks the relationship classes. In the meantime we can try to publish as a new layer then painstakingly reconfigure all the maps & apps within the Solution. But that rather defeats the entire purpose of a Solution.

Strahanjen

We switched to using ArcGIS Enterprise, so this has no longer been an issue for us, but back when needed to modify a feature service hosted in AGOL, we had two solutions for this issue:

1. Download the FGDB, delete all of the relationship classes and recreate them before overwriting the online layer.

2. Use the Add To Definition operation in the rest API to add fields, tables and new relationships classes.

https://developers.arcgis.com/rest/services-reference/online/add-to-definition-feature-layer-.htm

There are also remove from definition and update definition operations:

https://developers.arcgis.com/rest/services-reference/online/delete-from-definition-feature-layer-.htm

https://developers.arcgis.com/rest/services-reference/online/update-definition-feature-layer-.htm

Hope this helps!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.