You are sharing layers from a cloud data warehouse as a map image layer or a read-only web feature layer to a federated server that is not the hosting server. Layers from cloud data warehouses must be published to the hosting server if your ArcGIS Enterprise portal version is 11.4 or earlier. Publishing to a federated server is supported if the version is 11.5 or later.
Solution
Share the web layer to the hosting server. On the General tab, under Location, click the Server and Folder drop-down menu and select the hosting server.
Additional information
When publishing data from a cloud data warehouse as a map image layer or read-only web feature layer to a hosting server, you can optionally create a snapshot of the data. Snapshots are stored in the relational data store on the hosting server. To learn more, see Configure a map image layer or Configure a web feature layer.
For more information, see Create a query layer for data in a cloud data warehouse and Analyze your GIS resource.