[Last Call] Learn how to a build a cloud-first strategyRegister Now


CRM Dynamics 2011: Increasing Record Page Limit on OData Retrieve Responses

Posted on 2012-08-31
Medium Priority
Last Modified: 2012-09-05
Points of My Scenario:
1. I am admin of a Microsoft CRM Dynamics 2011 solution
2. The SQL Server 2008 R2 is used for the database - configured with transparent encryption (TPE)
3. CRM Dynamics 2011 and SQL Server 2008 R2 are on separate machines
4. The OS for both servers is Windows Server 2008 R2
5. I tried to increase the 50-record page limit on odata retrieve responses for CRM Dynamics 2011 using powershell instructions in attached text file (I got these instructions from the site here : Article  )
6. Only the last command fails ("Set-CrmAdvancedSetting -Entity $setting") with the following error: "Set-CrmAdvancedSetting: The underlying connection was closed: An unexpected error occurred on a send"
7. Everything worked in our test environment where Dynamics and SQL are installed on the same machine.

OBJECTIVE: To increase the 50-record page limit on odata retrieve responses for CRM Dynamics 2011.

REQUEST: Please provide advice on how to resolve this CRM issue using powershell or any other means to increase the 50-record page limit on odata retrieve responses for CRM Dynamics 2011.
Question by:waltforbes
  • 3
  • 2
LVL 27

Accepted Solution

Chinmay Patel earned 2000 total points
ID: 38356965
Hi waltforbes,


In the same article they have shown updated database entry, you can modify the entry manually i.e. open SQL Management Studio, navigate to MSCRM_Config database, open ServerSettingsProperties table and modify the columnname MaxResultsPerCollection and then do an IISReset.


Author Comment

ID: 38359453
Hi Chinmay_Patel,
Many thanks. I will verify on Monday (tomorrow) at the office. Then I will accept the solution once successful. My apologies that it couldn't be earlier.
LVL 27

Expert Comment

by:Chinmay Patel
ID: 38360263
Hi waltforbes,

I've been a memeber here for many years and I don't recollect that many had the decency to revert in case they are not able to close the question. I've questions open for months... so please... don't worry and take your time.


Author Closing Comment

ID: 38367922
Hi Chinmay,

your instructions yielded success! We are so happy! Many thanks, Chinmay.

LVL 27

Expert Comment

by:Chinmay Patel
ID: 38368917
Glad I could help. :)

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question