SSRS Export to Excel is popular in our office but has been failing a lot recently- at the beginning of the year there were a few occurances a month until June, then they steadily increased until now it is nearly every time (44% of the events happened this month.) Few software changes (just MS and virus def updates) No configuration changes until troubleshooting this issue began. Policy changes on both server and clients is possible as that is controled by contractors and we are not notified of changes. Upon exploring I discovered export to tiff and web archive also fail, but csv, PDF, and xml seems to work most of the time. Some of the reports failing have not had any design changes in months. Reports are not particularly large- 2 to 4 tables with under 200 rows each. No more than 6 pages and then mostly because of page breaks between tables. no more than 5 levels of drill down- most have fewer than that. The failure happens very fast- about 4 seconds. If the data is filtered down to very small sets so that the export process can complete inside those 4 seconds then it succeeds. I have seem many questions on lots of forums with similar issues with SSRS but no solutions that worked for me. All the timeout values I know of (about 6?) are set to between 120 and 3600 seconds. None of my reports should take more than a minute (usually more like 20 seconds.) A longstanding issue that might be related is that I have not been able to render longish running reports through ReportManager for nearly a year. Fast reports yes- longer than a few seconds, no. Since I mostly deliver reports through reportserver URLs anyway, I didn't put in sustained effort to find a successful solution, but now we must have export to excel. Troubleshooting Steps (abbreviated) Checked all timout values in IIS Checked web.config, RSWebApplication.config, and rsreportserverconfig files for timeout and other likely values Created new application pools and switched to them Checked Reporting Services Configuration and rechecked default switch to force reset on settings Opened security on windows and reportservices temp folders Checked report services DBs to insure Network Service and iUser accounts had read/write rights Checked Excel limitations Lots of other things! Enviroment: Windows Server 2003 Service Pack 2 SQL Server 2005 - 9.00.3050.00 Enterprise Edition SQL, Analysis Services, and Report Services all on 1 box (but few users at any given time) SSRS in Native mode Dundas add ins installed- all the bells and whistles IIS 6 Anonymous Access set on Reports and ReportServer applications ASP.Net 2.0.50727 AVG not installed, but Symantic client is (Avg is culpret in some similar posts.) Most clients use IE- versions range from 6 to 8 1. Browser: Cannot find server or DNS Error Internet Explorer 2. Application log error a. Source: ASP.NET 2.0.50727.0 b. EventID: 1309 c. Event code: 3005 d. Event message: An unhandled exception has occurred e. Application domain: /LM/W3SVC/1/root/ReportServer-1-129296848712062635 f. Trust level: RosettaSrv g. Application Virtual Path: /ReportServer h. Process name: w3wp.exe i. Account name: NT AUTHORITY\NETWORK SERVICE j. Exception type: HttpException k. Exception message: The remote host closed the connection. The error code is 0x80072746. 3. SQLDumper_Errorlog.log a. ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514) 4. SQLDmpr0167.log a. w3wp!library!9!9/23/2010-14:10:49:: Unhandled exception was caught: System.Web.HttpException: The remote host closed the connection. The error code is 0x80072746. b. at System.Web.Hosting.ISAPIWorkerRequestInProcForIIS6. c. w3wp!library!9!9/23/2010-14:10:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; d. Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Web.HttpException: The remote host closed the connection. The error code is 0x80072746. 5. ReportServerService a. No errors 6. ReportServerWebApp a. No errors The only error I could find on the ReportManager failure is the one that displays in the browser when the report fails to render: The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Any help would be greatly appreciated. Terri G

Aren't Microsoft Engineers supposed to answer within 2 days? I am an MSDN subscriber and could really use the help. Thanks Terri G

Is it an issue with network connection? connection between client - app & repor server. Can you try setting report server address with IP other than dns name. IS it possible for you test reports from the same machine as reportserver. Bipin. P | ERNST & YOUNG SSC

After days of working on this issue with no resolution, it suddently started working again. A contractor handles our network infrastructure and server os configuration- I took a peek at the system log and it looks like a NIC card was reset or something night before last (NIC Agent: Connectivity has been restored for the NIC) and the application log offered an event with the text: Re-bind listening socket after System IP Address change. I'm glad it's working now but how frustrating! Everything looked like an application issue. I am still getting occassional asp.net warnings in the ap log: Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Event code: 3005 Event message: An unhandled exception has occurred. Application information: Application domain: /LM/W3SVC/1/root/ReportServer-1-129306891640807640 Trust level: RosettaSrv Application Virtual Path: /ReportServer Application Path:Process information: Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: ReportServerException Exception message: Execution 'lbaly345dnzta0yrkt0utd55' cannot be found (rsExecutionNotFound) Is impersonating: True Stack trace: at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) at Microsoft.Reporting.WebForms.ReportDataOperation..ctor() at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType) at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)