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
