I have a Map Service of a large number of polygons (>100,000). When I create a Model Builder model to clip this map service using a buffered Area of Interest (Feature Set) I get an error "001406 : Query operation has exceeded the feature service transfer limit." -- even if the AOI is small and would only intersect a few polygons. I don't understand why I am getting this message for a MAP service (i.e. no FEATURE service is involved). The model still runs successfully on Desktop in spite of the error, but when I share it as a geoprocessing service it fails to run, I assume because of the error.
My objective is to share a geoprocessing service based on a model that clips a large polygon layer and exports the associated tabular results to an Excel file. Ultimate use is as a geoprocessing widget in WebApp Builder. Basic functions needed are shown in the attached screenshot of the model.