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

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.
ScriptCRMAddmore.txt
waltforbesSenior IT SpecialistAsked:
Who is Participating?
 
Chinmay PatelConnect With a Mentor Enterprise ArchitectCommented:
Hi waltforbes,

http://blogs.msdn.com/b/crminthefield/archive/2012/03/16/how-to-increase-the-50-record-page-limit-on-odata-retrieve-responses-for-dynamics-crm-2011.aspx

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.

Regards,
Chinmay.
0
 
waltforbesSenior IT SpecialistAuthor Commented:
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.
0
 
Chinmay PatelEnterprise ArchitectCommented:
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.

Regards,
Chinmay.
0
 
waltforbesSenior IT SpecialistAuthor Commented:
Hi Chinmay,

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

Regards,
Walt
0
 
Chinmay PatelEnterprise ArchitectCommented:
Glad I could help. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.