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

Question

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.

NielsGerrits · Answer

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.

JoshuaBixby · Answer

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.