sql login permissions: batch

We have several business areas that want to run a scheduled batch job to
render reports in a pdf file to them. We seem to be hitting an issue with
reports that take longer than 15 minutes to render.
We get the error message, " The underlying connection was closed: Could not
establish secure channel for SSL/TLS" and "An existing connection was
forcibly closed by the remote host"
I have been able to render the reports from the report manager after I set
the default timeout setting to nothing and let the report churn for in some
cases 45 minutes. We have larger volumes of financial data.
Corporately we are looking at setting a timeout standard and having the
report builders create temp tables to report from for the longer running
reports, but more specifiically I am wondering what are all the possible
timeout setting that could be forcing the connection closed? Report
manager? IIS? and has anyone else dealt with this issue and if so how did
you address it?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
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: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| Subject: Long running reports
| Date: Tue, 31 May 2005 15:58:11 -0700
| Lines: 18
| Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.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:45040
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have several business areas that want to run a scheduled batch job to
| render reports in a pdf file to them. We seem to be hitting an issue with
| reports that take longer than 15 minutes to render.
|
| We get the error message, " The underlying connection was closed: Could
not
| establish secure channel for SSL/TLS" and "An existing connection was
| forcibly closed by the remote host"
|
| I have been able to render the reports from the report manager after I
set
| the default timeout setting to nothing and let the report churn for in
some
| cases 45 minutes. We have larger volumes of financial data.
|
| Corporately we are looking at setting a timeout standard and having the
| report builders create temp tables to report from for the longer running
| reports, but more specifiically I am wondering what are all the possible
| timeout setting that could be forcing the connection closed? Report
| manager? IIS? and has anyone else dealt with this issue and if so how
did
| you address it?
||||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(WebRequest
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
*----*
*******************************************************
"Peter Yang [MSFT]" wrote:
> 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
> 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: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | X-WBNR-Posting-Host: 64.73.98.126
> | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | Subject: Long running reports
> | Date: Tue, 31 May 2005 15:58:11 -0700
> | Lines: 18
> | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.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:45040
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We have several business areas that want to run a scheduled batch job to
> | render reports in a pdf file to them. We seem to be hitting an issue with
> | reports that take longer than 15 minutes to render.
> |
> | We get the error message, " The underlying connection was closed: Could
> not
> | establish secure channel for SSL/TLS" and "An existing connection was
> | forcibly closed by the remote host"
> |
> | I have been able to render the reports from the report manager after I
> set
> | the default timeout setting to nothing and let the report churn for in
> some
> | cases 45 minutes. We have larger volumes of financial data.
> |
> | Corporately we are looking at setting a timeout standard and having the
> | report builders create temp tables to report from for the longer running
> | reports, but more specifiically I am wondering what are all the possible
> | timeout setting that could be forcing the connection closed? Report
> | manager? IIS? and has anyone else dealt with this issue and if so how
> did
> | you address it?
> |
>|||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
|
*----
*
| *******************************************************
|
| "Peter Yang [MSFT]" wrote:
|
| > 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
| > 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: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| > | X-WBNR-Posting-Host: 64.73.98.126
| > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| > | Subject: Long running reports
| > | Date: Tue, 31 May 2005 15:58:11 -0700
| > | Lines: 18
| > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.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:45040
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We have several business areas that want to run a scheduled batch job
to
| > | render reports in a pdf file to them. We seem to be hitting an issue
with
| > | reports that take longer than 15 minutes to render.
| > |
| > | We get the error message, " The underlying connection was closed:
Could
| > not
| > | establish secure channel for SSL/TLS" and "An existing connection was
| > | forcibly closed by the remote host"
| > |
| > | I have been able to render the reports from the report manager after
I
| > set
| > | the default timeout setting to nothing and let the report churn for
in
| > some
| > | cases 45 minutes. We have larger volumes of financial data.
| > |
| > | Corporately we are looking at setting a timeout standard and having
the
| > | report builders create temp tables to report from for the longer
running
| > | reports, but more specifiically I am wondering what are all the
possible
| > | timeout setting that could be forcing the connection closed? Report
| > | manager? IIS? and has anyone else dealt with this issue and if so
how
| > did
| > | you address it?
| > |
| >
| >
||||Thanks Peter,
I will follow up with our VS. net product manager to find out what service
packs we have deployed.
"Peter Yang [MSFT]" wrote:
> 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
> |
> *----
> *
> | *******************************************************
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > 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
> | > 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: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | > | X-WBNR-Posting-Host: 64.73.98.126
> | > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | > | Subject: Long running reports
> | > | Date: Tue, 31 May 2005 15:58:11 -0700
> | > | Lines: 18
> | > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.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:45040
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We have several business areas that want to run a scheduled batch job
> to
> | > | render reports in a pdf file to them. We seem to be hitting an issue
> with
> | > | reports that take longer than 15 minutes to render.
> | > |
> | > | We get the error message, " The underlying connection was closed:
> Could
> | > not
> | > | establish secure channel for SSL/TLS" and "An existing connection was
> | > | forcibly closed by the remote host"
> | > |
> | > | I have been able to render the reports from the report manager after
> I
> | > set
> | > | the default timeout setting to nothing and let the report churn for
> in
> | > some
> | > | cases 45 minutes. We have larger volumes of financial data.
> | > |
> | > | Corporately we are looking at setting a timeout standard and having
> the
> | > | report builders create temp tables to report from for the longer
> running
> | > | reports, but more specifiically I am wondering what are all the
> possible
> | > | timeout setting that could be forcing the connection closed? Report
> | > | manager? IIS? and has anyone else dealt with this issue and if so
> how
> | > did
> | > | you address it?
> | > |
> | >
> | >
> |
>sql

Hi,
I wrote a batch import process that uses connection pooling, i.e. the
connections are never closed until the process is finished. I am writing
large chunks of data (byte[]) into the database, and I made absolutely
sure that my application does not hold any references to the byte[]
objects. However, the process increasingly consumes memory until an
OutOfMemoryError, and I tracked it down to the Microsoft JDBC driver
still holding references to the byte[] objects. The workaround is to
clear the pool "from time to time", closing its connections. When I do
that, the memory is properly reclaimed by the GC.
This "from time to time" involves some unsatisfying heuristics, though
(apart from the inconvenience of having to find the pool and access it).
If the driver is doing any caching on purpose, it should be documented
somewhere, and it should be configurable. My guess is that it's not on
purpose, though. I can't see much sense in holding on to written data
after a transaction is finished.
In case any driver developer should be interested, using a profiling
tool I found references from the following driver classes to a byte[]
object that should normally be reclaimed by the GC:
com.microsoft.jdbc.sqlserver.SQLServerPacketizingD ataConsumer and
com.microsoft.jdbc.sqlserver.tds.TDSConnection
Regards,
Jrg.
Joerg von Frantzius wrote:
> Hi,
> I wrote a batch import process that uses connection pooling, i.e. the

> connections are never closed until the process is finished. I am
writing
> large chunks of data (byte[]) into the database, and I made
absolutely
> sure that my application does not hold any references to the byte[]
> objects. However, the process increasingly consumes memory until an
> OutOfMemoryError, and I tracked it down to the Microsoft JDBC driver
> still holding references to the byte[] objects. The workaround is to
> clear the pool "from time to time", closing its connections. When I
do
> that, the memory is properly reclaimed by the GC.
> This "from time to time" involves some unsatisfying heuristics,
though
> (apart from the inconvenience of having to find the pool and access
it).
> If the driver is doing any caching on purpose, it should be
documented
> somewhere, and it should be configurable. My guess is that it's not
on
> purpose, though. I can't see much sense in holding on to written data

> after a transaction is finished.
> In case any driver developer should be interested, using a profiling
> tool I found references from the following driver classes to a byte[]

> object that should normally be reclaimed by the GC:
> com.microsoft.jdbc.sqlserver.SQLServerPacketizingD ataConsumer and
> com.microsoft.jdbc.sqlserver.tds.TDSConnection
The MS driver does indeed do a lot of unnecessary caching (such as
caching the whole ResultSet in direct mode), but I don't think this is
your problem here.
You are closing all JDBC resources (i.e. connections, statements and
result sets), aren't you? Even if SQLExceptions are thrown...
Alin,
The jTDS Project.
|||Alin Sinpalean schrieb:

>The MS driver does indeed do a lot of unnecessary caching (such as
>caching the whole ResultSet in direct mode), but I don't think this is
>your problem here.
>You are closing all JDBC resources (i.e. connections, statements and
>result sets), aren't you? Even if SQLExceptions are thrown...
>Alin,
>The jTDS Project.
>
When I close the connections, memory is reclaimed properly. What I
wanted to say is that memory is eaten up indefinitely as long as the
connection *remains open* and is used to repeatedly write large chunks
of data into the DB.
|||Joerg von Frantzius wrote:
> When I close the connections, memory is reclaimed properly. What I
> wanted to say is that memory is eaten up indefinitely as long as the
> connection *remains open* and is used to repeatedly write large
chunks
> of data into the DB.
I understand that. What I meant to say is "are you sure you are
explicitly closing ALL Statements and ResultSets when you're done with
them?". Leaving them open could and will cause the effects you now see.
Alin.
|||<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Alin Sinpalean schrieb:
<blockquote
cite="mid1109058703.898619.117040@.f14g2000cwb.goog legroups.com"
type="cite">
<pre wrap="">Joerg von Frantzius wrote:
</pre>
<blockquote type="cite">
<pre wrap="">When I close the connections, memory is reclaimed properly. What I
wanted to say is that memory is eaten up indefinitely as long as the
connection *remains open* and is used to repeatedly write large
</pre>
</blockquote>
<pre wrap="">
I understand that. What I meant to say is "are you sure you are
explicitly closing ALL Statements and ResultSets when you're done with
them?". Leaving them open could and will cause the effects you now see.
Alin.
</pre>
</blockquote>
Alright, now I got the point about the Statements and ResultSets,
sorry. To be honest, I can't be absolutely sure about that, because I'm
relying on a JDO implementation to take care of it.<br>
</body>
</html>
|||Joerg von Frantzius wrote:
> Alright, now I got the point about the Statements and ResultSets,
sorry.
> To be honest, I can't be absolutely sure about that, because I'm
relying
> on a JDO implementation to take care of it.
You could try jTDS (disclaimer: I'm a jTDS developer). I'm not saying
it will definitely make the problem disappear, but at least I will be
able to help more.
Alin.

Friday, March 30, 2012

Long running reports

Wednesday, March 28, 2012

Long running open connections badly leak memory

Wednesday, March 7, 2012

Login Time and Last Batch not displayed correctly

sql login permissions

Blog Archive

About Me