Join Features Create Service error: Failed to create the service

[AbdullahMuthanna]

Hello,

I have two view databases with geometry. I completed everything from symbology to joins, and both SDEs are registered in ArcGIS Server Manager. However, when I tried to publish them as feature layers, I deselected "Enable Editing and Allow Editors to" in the Share a Web Layer configuration to prevent any issues, since they are view databases and cannot have these options enabled.

I encountered another problem: I cannot publish if I'm using two data sources, and since I’m pulling data from two SDEs, this is a significant issue. I thought, "Why not publish each data source separate ?" So, I created a new map, moved the second data source's layers into it, and published each one separately. Now both of them published without any issues.

Next, I decided to create a join in the Map Viewer. I went to Analysis, then Join Features, selected the two layers, and specified the matching fields. When I clicked "Run," it loaded for about five seconds, then returned the error message:
"Create Service error: Failed to create the service 'Hosted/Join_Features_to_Map2_FDT_Region.FeatureServer.'"

I don’t know what I should do now. Is there another solution I could use? If so, I need to ensure that it allows live synchronization, so every change in the database will reflect on the map in AGOL.

So at the end my goal is to achive a join between 2 layers from different data source so i can use it in AGOL

[MichaelVolz]

I believe the join (or relate) would only work if all data is in the same database.

[AbdullahMuthanna]

I don't think so because it is worked on ArcGIS Pro but it won't work on AGOL after sharing the both datasource

[AmandaRing]

If you are looking to ensure that the result updates dynamically as the source data updates, you need to create a Hosted Feature Layer View Join. This is not available in the Join Features tool in Map Viewer. Instead, there's a new way to create a hosted feature layer view from a join, located on the item details page of your target layer. You can check out the documentation here and this great blog post about the new method.

Keep in mind that both datasets must be hosted layers or tables and you must be the owner of both in order to perform the join.

Hope that helps!