Could you share what workflow you for following for publishing the map service?
What is the version of your ArcGIS Server?
Is it a stand-alone Server or the Server is federated with Portal for ArcGIS (ArcGIS Enterprise)?
Have you registered the underlying geodatabase/ folder with Server?
Check Publish a Map Service from ArcGIS Pro for more details.
I have 4 layers 1xpoint, 1xline and 2x polygon which both reference the same data source
ArcGIS Server: 10.81 federated
Yes we have a registered geodatabase that I am publishing from. But have also just noticed that I am also getting this error from a hosted feature class that I published recently.
Getting this error in dev tools: Error querying server for feature count in MapTextProvider: Error: Failed to execute query.
We're still trying different things to resolve it so I'll post again if we work it out otherwise we might need to log a ticket with support.
You cannot publish a map service to a federated server using ArcGIS Pro.
Instead, check if you can share them as web layers (individually) or as webmap to your ArcGIS Enterprise. Sharing Web Layers
Sorry, maybe I called it the wrong thing. It is creating a service. I use Share > web layer > overwrite web layer
The same process worked with no problems on production where we still have 2.7 installed. I will log an ESRI request as we have to get to the bottom of this issue to make sure it doesn't occur on production.
We just uninstalled 2.8, reinstalled 2.7 on the server then we had to get the version of the arpx from production (that had never been opened in 2.8) we published that (using the process above) and everything is back again.