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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics