topic Re: Increase max records returned in SharePoint? in ArcGIS for SharePoint Questions

Increase max records returned in SharePoint?

RickThiel — Mon, 25 Jul 2011 16:32:06 GMT

Hello,

By default, it appears that there is a maximum of 1000 records returned in the SharePoint mapping web part. Is there any way to increase that amount? I would assume it can be done in the DefaultConfiguration.xml but I cannot find any examples for how to do it.

Thanks, --Rick

Re: Increase max records returned in SharePoint?

RahulMetangale — Tue, 26 Jul 2011 14:11:46 GMT

This limit is impose by ArcGIS Server. This value can be increased from ArcGIS Server Manager - Manage Services -Edit the Service in question -Parameters, and increase the value for "Maximum Number of records returned by Server" to desired value.

-Rahul

Re: Increase max records returned in SharePoint?

RickThiel — Tue, 26 Jul 2011 16:11:51 GMT

Thanks Rahul. I discovered the same thing late in the day yesterday. We increased the max records in the Parameters section of Server Manager. That fixed one problem, but it opened our eyes to another problem.

It appears that when a user has the "filter-by-extent" enabled, SharePoint only grabs the entire recordset at the initial extent. It appears that it never goes back to refresh that data set. Here is the reason I came to that conclusion:
[INDENT]When the user initially sees the Sharepoint map it is zoomed out to include Iowa and Wisconsin. It should also pull in about 9,000 points on the map from our map service. But, because our service only had a limit of 1,000 records, we were only seeing 1,000 records in the details grid below.
One would expect that if you zoomed into an area the size of a county, SharePoint should hit the service again and pull in a new recordset of points. But it doesn't. If you zoom into the county level, it only shows you a subset of the points it initially grabbed at the entire Wisconsin/Iowa extent. If your points were not included in the initial 1,000 points it pulled in, you will not seet them on the map.[/INDENT]
We have played a little bit with the polling buttons on the ribbon, but they never seem like they are enabled. Can you tell me if this is normal behavior? Is this a bug?

Re: Increase max records returned in SharePoint?

JeffPope — Tue, 18 Oct 2011 15:14:46 GMT

Thanks Rahul. I discovered the same thing late in the day yesterday. We increased the max records in the Parameters section of Server Manager. That fixed one problem, but it opened our eyes to another problem.

It appears that when a user has the "filter-by-extent" enabled, SharePoint only grabs the entire recordset at the initial extent. It appears that it never goes back to refresh that data set. Here is the reason I came to that conclusion:
[INDENT]When the user initially sees the Sharepoint map it is zoomed out to include Iowa and Wisconsin. It should also pull in about 9,000 points on the map from our map service. But, because our service only had a limit of 1,000 records, we were only seeing 1,000 records in the details grid below.
One would expect that if you zoomed into an area the size of a county, SharePoint should hit the service again and pull in a new recordset of points. But it doesn't. If you zoom into the county level, it only shows you a subset of the points it initially grabbed at the entire Wisconsin/Iowa extent. If your points were not included in the initial 1,000 points it pulled in, you will not seet them on the map.[/INDENT]
We have played a little bit with the polling buttons on the ribbon, but they never seem like they are enabled. Can you tell me if this is normal behavior? Is this a bug?

Ever get an answer to this? I have the same issue with Mobile services. I get the initial extent 1000 rows, but it never re-polls when changing views.

Re: Increase max records returned in SharePoint?

RickThiel — Tue, 18 Oct 2011 18:22:43 GMT

Hi Jeff,

No, I never got this issue resolved. I contacted support and she could not provide an acceptable solution for us. I asked her to put this on the bug list for future releases of ESRI web part for SharePoint.

-_Rick