topic Re: Relationship classes in Map Service in Publishing and Managing Services Questions

Relationship classes in Map Service

KellyKnapp35 — Wed, 05 Jan 2022 20:31:18 GMT

A year ago, I published a map with 6 layers related to a non-spatial table from ArcMap to a hosted server. Data is in a SDE geodatabase with relationship classes.

A year later, I imported that map into ArcGIS Pro and made some updates. I accidentally deleted a Relationship Class, so I had to recreate them all. I published to our AGOL Feature/Map Services Server (not hosted).

Now when I query the map in my web app, the related layers are displayed in a different order that makes no sense for this data. It looks like something happened to them when I published.

I tried to delete the Relationship Classes, recreate them in the order I want and republish. I still get the relationships in a random order. I want them to be in sequential order by layer 0, 1, 2, 3, 4, 5... I can't figure out why they would've changed from one publishing to the next.

Is this due to publishing one to a hosted server vs. AGOL server? Is there a way to publish them in sequential order? Or force the related layers to be displayed in a different order?

Any suggestions would be appreciated!

Re: Relationship classes in Map Service

TanuHoque — Thu, 06 Jan 2022 00:37:11 GMT

@KellyKnapp35

- If you talking about the 'relationship IDs' (that is what we are seeing on the left side of '--' in your screenshots), then unfortunately we don't have any option at this point to support this. We do have plan to do that. Here is the bug id - ENH-000127465. Please contact Esri support and add your use case in that.

Just curious, are these new ids causing any problem while you are using your service in a webmap/app?

- But if you are talking about 'layer IDs' (that is showing up on the right side of '--' in your screenshots), you can fix them. Here is the doc that shows you how to.
https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/assign-layer-ids.htm#ESRI_SECTION1_11B19A48477F49FDBD61038AE0B851B2

Re: Relationship classes in Map Service

KellyKnapp35 — Thu, 06 Jan 2022 18:55:20 GMT

Thank you @TanuHoque for your response! Unfortunately, I was talking about the relationship IDs.

Functionally there is no issue because I had to reconfigure my Query in my application to query the new Map Image.

My issue is with the Query Results list under Feature Actions. Now when “Show All Related Records” is selected, it is in this random order. I would like it to match the layer order in the map (which is also sub grouped by geometry type).

Is there no work around?

I tried: Delete all relationship classes, recreate them in the desired order, create new map, add layers and table and publish. That did not work.

I may try deleting the related table. Recreate it, relationships, new map, etc.. it might be the only way? 😞

Re: Relationship classes in Map Service

KellyKnapp35 — Thu, 06 Jan 2022 19:03:51 GMT

@TanuHoque One other related question. Is there any way to rename the layers in the "Show All Related Records" drop down list? or show an Alias Name? It appears whatever the layers are named when the Map Image is published is what is shown.

It would be nice to be able to edit the layers with a more descriptive name within the application.

Re: Relationship classes in Map Service

DaveThompson101 — Mon, 25 Apr 2022 21:41:30 GMT

I think I'm having the same issue as @KellyKnapp35, if I'm understanding the issue correctly...

Are we saying that the relationship IDs are randomly assigned?

For me, here is the issue I'm having...

Publish service with relationships
Build web map/app with smart editor widget
Republish service (layers stayed in same order)
Widget doesn't work...
1. looking into the widget, I see that the relationship IDs the widget is expecting are different than in the service.

Question - is it possible that when I republished the service the relationship IDs changed? And/Or - What determines the relationship ID?

Thank you!

Re: Relationship classes in Map Service

LanceKirby2 — Thu, 05 May 2022 19:14:15 GMT

Having these same issues. Just wanted to add another comment to grow this thread. It would be nice if there was a solution.

Re: Relationship classes in Map Service

MareikeKociok — Wed, 07 Dec 2022 15:17:59 GMT

Hey all,

I am having the same Issue in an even more advanced way. The relationship Id's change in a non detectable pattern (so far) even so the service is not republished. Just out of no where and the attached workflow does not work anymore afterwards, because:

the query related records tool does seem to follow the old order of the relationship id's (1,2,3,4) even though the order changed to 1,2,4,3 in the layer. A restart on the service does help to restore the order of the relationship class id's. But since this behaviour occurs on an regular basis this is no long term solution.

I also would be interested to know the answer to the question @DavidThompson101 asked.

@TanuHoque: Any ideas?

Re: Relationship classes in Map Service

MareikeKociok — Wed, 07 Dec 2022 15:19:17 GMT

Additonally the mentioned Enhancement has the status Implemented: https://support.esri.com/en/bugs/nimbus/RU5ILTAwMDEyNzQ2NQ==#

But i could not find any information about how this is implemented.

Re: Relationship classes in Map Service

LanceKirby2 — Wed, 07 Dec 2022 15:44:21 GMT

If you upgrade Pro to 3.0 or greater you can specify the Id of each layer in a service before publishing. They then wouldn’t change any time you re publish.

I know that doesn’t resolve your issue since you mention you haven’t republished, but I think it’s the answer to the bug you referenced and the answer to the original thread.

Re: Relationship classes in Map Service

MareikeKociok — Mon, 12 Dec 2022 12:32:26 GMT

Helle @LanceKirby2 ,

Thanks for your feedback. I tried it out and this actually does already work in ArcGIS Pro 2.9. Unfortunately, this id defines the table id, rather than the Relationship class Id.

In in my scenario the id of the relationship class (number on the left), does change and i would like to adjust the numbers. Anyone who knows how this can me made possible?

Thanks in advanced for your help.

Re: Relationship classes in Map Service

MatthewStull1 — Mon, 01 Dec 2025 22:26:43 GMT

I know this is an old thread but I'm having the same issue. We have an integration with another system and republishing the map service is changing the ID's of the relationship classes in the feature service and thus breaking that part of our integration. Anyway, it looks like this issue has been addressed with ArcGIS Server/Enterprise 11.3: Relationships (Feature Service) | ArcGIS REST APIs | Esri Developer I haven't tested this yet but we may be moving to this version soon.

Re: Relationship classes in Map Service

TanuHoque — Wed, 03 Dec 2025 02:02:31 GMT

Thanks@MatthewStull1 for adding your note here. You are right, this is fixed for both map service and feature service in 11.3.

Once you have both sides of a relates in your map in Pro, if you open the layer/table's Properties page and go to Relates tab, you will see an option to provide user defined ids for relationships.

Note: please note that we have an issue -- if you already have 'allow assignment of unique ids...' option checked at the map level, and you added the layers/tables; you might not see this option; You need to reset (or toggle it if you wanted to preserve your already assigned layer ids) that at the map level to see this text box to enter your desired id.

We apologies for this issue; we are hoping to fix this issue in a future release.

Thank you!