I have built a Windows Service that connects to Sql Server 2000 Reporting
Services via its Web Service interface for the purpose of generating reports.
Intermittently, calls made to the Web Service result in WebExceptions
indicating that the underlying connection was closed. We are running the
application on a box running W2k3 (no SP) and .NET 1.1 SP1.
I have seen a number of postings where people are having problems that
appear similar to mine:
http://www.dotnet247.com/247referenc...39/196568.aspx
http://p2p.wrox.com/topic.asp?TOPIC_ID=4858
http://weblogs.asp.net/jan/archive/2.../28/63771.aspx
Many people seem to have been able to set KeepAlive to false as a work
around. This, however, will not work for me as Reporting Services uses
Integrated Security which requires KeepAlive.
Below is an example of one of the execeptions:
Type:System.Net .WebException
Message:The underlying connection was closed: An unexpected error occurred
on a send.
Source:System.W eb.Services
Stack Trace: at
System.Web.Serv ices.Protocols. WebClientProtoc ol.GetWebRespon se(WebRequest
request)
at
System.Web.Serv ices.Protocols. HttpWebClientPr otocol.GetWebRe sponse(WebReque st
request)
at System.Web.Serv ices.Protocols. SoapHttpClientP rotocol.Invoke( String
methodName, Object[] parameters)
at NAMB.ReportingS ervices.Reporti ngService.Rende r(String Report, String
Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
DataSourceCrede ntials[] Credentials, String ShowHideToggle, String& Encoding,
String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) in C:\DataCentral\ Windows
Services.etp\Re portProcessingS ervice\Web
References\Repo rtingServices\R eference.cs:lin e 653
at
NAMB.DataCentra l.WindowsServic es.ReportGenera tionThread.Rend erReport(Report
report, ReportRequestPa rameterArrayLis t parameters) in C:\DataCentral\ Windows
Services.etp\Re portProcessingS ervice\ReportGe nerationThread. cs:line 183
at
NAMB.DataCentra l.WindowsServic es.ReportGenera tionThread.Gene rateReport(Obje ct
stateInfo) in C:\DataCentral\ Windows
Services.etp\Re portProcessingS ervice\ReportGe nerationThread. cs:line 58
Target Site:System.Net .WebResponse GetWebResponse( System.Net.WebR equest)