topic Query on mapservice returns no results when resultRecordCount parameter is added. in ArcGIS Enterprise Questions

Query on mapservice returns no results when resultRecordCount parameter is added.

NielsGerrits — Fri, 27 Sep 2024 11:51:24 GMT

I have a mapservice which is queried by VertiGIS Studio Web which returns no results. When I reproduce the query the service returns a result when I leave the parameter resultRecordCount empty.

Other mapservices work fine with the resultRecordCount parameter. I published a different service from the same source but this did not solve the problem.

The source is a 2D point featureclass in SDE. What could cause this and how to solve it?

Thanks for looking.

Re: Query on mapservice returns no results when resultRecordCount parameter is added.

JoshuaBixby — Fri, 27 Sep 2024 13:49:12 GMT

Cross posted at query - ArcGIS REST API returns no results when resultRecordCount parameter is added - GIS SE.

As a comment to that question asks, are you sure the service supports pagination, which is a requirement for this option.

Re: Query on mapservice returns no results when resultRecordCount parameter is added.

NielsGerrits — Tue, 01 Oct 2024 09:51:21 GMT

I tried to overwrite and recreate the service, recalculate and rebuild the spatial index, but this did not help. Ended up with recreating the featureclass in sde and migrating the data to the new featureclass. This was not the route I wanted to follow but it did solve the issue.