Updating/Uploading RPL causes error
I have a frustrating problem. When I use Report Manager to attempt to update and/or upload and RPL it is only successful about 10% of the time. Most of the time I get the following error (with on more info):
The underlying connection was closed: An unexpected error occurred on a receive.
I can not seem to find a pattern to it. Searching these forums turns up a few threads talking about making the default web site timeout value larger. However, it's set at 120 seconds, and when it works it takes less than 3 seconds to update or
upload the RPL (they aren't that big).
I need help just getting started...where do I start looking to find out why it fails 90% of the time? I can't seem to find anything in logs that I'm looking at. However, I'm new to Reporting Services, so I don't really know what to look at to
start trouble-shooting.
thanks
April 11th, 2011 3:19pm
Hi Ken.Kennedy,
It seen when the client had sent the request in its entirety and got a TCP ACK-FIN or RST from server to close the connection, without a response from server. We can follow these
steps to increase the request size to resolve the issue:
1. Add the following registry key with the following value:
Key: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters
Value: DWORD "MaxRequestBytes" set it to a value of 5242880 (5MB). (This number is alterable).
2. Stop the SRS Windows Service.
3. From a cmd prompt run "net stop http" then "net start http".
4. Try and upload your report.
Further information on this setting can be found in this article:
http://support.microsoft.com/kb/820129
The same thread please see:
http://stackoverflow.com/questions/2238494/cant-deploy-or-upload-large-ssrs-2008-report-from-vs-or-ie
Please feel free to ask, if you have any more questions.
Thanks,
Challen Fu
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2011 1:26am
Thank you Challen. That solved my issue.
I've googled for several days, and never came across that stackoverflow thread (surprising).
April 18th, 2011 11:18am