Hello,

You may also want to check if you encounter the following known issue

884537 FIX: You may receive a "System.Net.WebException" error message when
you
http://support.microsoft.com/?id=884537

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.


=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Thread-Topic: Long running reports
| thread-index: AcVmykgAseOX2lghQwamF3cLJGlxpw==
| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@newsgroup.nospam>
| References: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@microsoft.com>
<xDIz1QoZFHA.3052@TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Long running reports
| Date: Wed, 1 Jun 2005 09:52:22 -0700
| Lines: 186
| Message-ID: <DB60FC6A-4119-4C9A-948C-BBE8500DA360@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45109
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| Some more information on the specific error and what we have tried. We
have
| bumped up the timeout settings for the report manager, the IIS settings
on
| the developers local maching and disabled keep alives. Are their any
more
| areas where we could be hitting a timeout parameter. While I wait for
your
| response I will discuss this further with our server team and SQL dba's
for
| their suggestions.
|
| here is the actual error log.
| ******************************************************
| I increased the Individual timeout for the report to 1800 seconds and the
| IIS settings on my local machine, but the report is still timing out.
|
| with KeepAlive enabled or disabled...
|
|
----------------------------------------------------------------------------
--
| *****Creating Report GainsChartReport_CM dan.rhoades@cunamutual.com
| Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
| Program Started at: 6/1/2005 11:16:35 AM
|
|
| ------- Exception Log Entry -------
| ENVIRONMENT INFORMATION:
| TimeStamp: 6/1/2005 11:32:23 AM
| MachineName: WWVXP525563
| AppDomainName: RenderReports.exe
| ThreadIdentity:
| WindowsIdentity: CMUTUAL\cc1854
|
| EXCEPTION INFORMATION:
| Exception Type: System.Net.WebException
| Status: SecureChannelFailure
| Message: The underlying connection was closed:
Could
| not establish secure channel for SSL/TLS.
| TargetSite: System.Net.WebResponse
| GetWebResponse(System.Net.WebRequest)
| Source: System.Web.Services
| Stack Trace:
| at
| System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
| request)
| at
|
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebReques
t
| request)
| at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| methodName, Object[] parameters)
| at RenderReports.ReportingServices.ReportingService.Render(String
Report,
| String Format, String HistoryID, String DeviceInfo, ParameterValue[]
| Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
| String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
| Warning[]& Warnings, String[]& StreamIds)
| at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
| intReportParameters)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
| at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
| at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.Net.Sockets.SocketException
| ErrorCode: 10054
| NativeErrorCode: 10054
| Message: An existing connection was forcibly closed
by
| the remote host
| TargetSite: Int32 EndReceive(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
|
| ADDITIONAL INFORMATION:
| Error Rendering Report: GainsChartReport_CM
|
| ------- Exception Entry End -------
| **
| **
| ** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
| ** Report GainsChartReport_CM failed after 15 minutes 47 seconds
| Program Ended at: 6/1/2005 11:32:25 AM
|
*---------------------------------------------------------------------------
*
| *******************************************************
|
[quoted text, click to view]
|
| > Hello,
| >
| > I think this issue is caused by IIS timeout settings:
| >
| > 1. Click "Start", and then click "Control Panel".
| >
| > 2. Double-click "Administrative Tools", and then double-click "Internet

| > Information Services Manager".
| >
| > 3. Expand "Web Sites", right-click "Default Web Site" , and then click
| > "Properties".
| >
| > 4. Click the "Web Site" tab.
| >
| > 5. In the "Connections" section, in the "Connection timeout" box,
increase
| > the seconds to a value that is sufficient for the length of the import.
| > Also, please disable Keep-Alives.
| >
| > 6. Click "OK".
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so

Thanks Peter,

I will follow up with our VS. net product manager to find out what service
packs we have deployed.



[quoted text, click to view]