all groups > sql server reporting services > august 2005 >
You're in the sql server reporting services group:
Web Service render Timeout
sql server reporting services:
Take a look at rsreportserver.config in the reportserver directory. -- Wayne Snyder MCDBA, SQL Server MVP Mariner, Charlotte, NC (Please respond only to the newsgroup.) I support the Professional Association for SQL Server ( PASS) and it's community of SQL Professionals. [quoted text, click to view] "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... > I'm using the Web service library's ReportingService.Render function to > export a report to PDF format. > > After 90-100 seconds of processing, the call to Render throws an exception > saying that "The operation has timed-out", but the ReportServer keeps on > grinding at the report. The report is eventually finished succesfully, as > I > can see in the RS Execution Log that it ends with a status of 'rfSuccess'. > Data time is under a second, Process time is almost 7 seconds, and render > time is about 150 seconds. Nothing's timing out on the server side. > > How do I extend the timeout for the Render call so that my application > sticks around long enough to get the report from RS?
I'm using the Web service library's ReportingService.Render function to export a report to PDF format. After 90-100 seconds of processing, the call to Render throws an exception saying that "The operation has timed-out", but the ReportServer keeps on grinding at the report. The report is eventually finished succesfully, as I can see in the RS Execution Log that it ends with a status of 'rfSuccess'. Data time is under a second, Process time is almost 7 seconds, and render time is about 150 seconds. Nothing's timing out on the server side. How do I extend the timeout for the Render call so that my application
I've been through there and played with plenty of values, but never found anything that would help with the timeout in my Render call. I did find a fix to the problem though - not sure if it's the best way to do it: I modified my Reference.cs file for the SOAP Web Reference to the Report Server to force the Timeout property to 300000. I figure that'll give my app 5 minutes before the Render call times out. [quoted text, click to view] "Wayne Snyder" wrote: > Take a look at rsreportserver.config in the reportserver directory. > > -- > Wayne Snyder MCDBA, SQL Server MVP > Mariner, Charlotte, NC > (Please respond only to the newsgroup.) > > I support the Professional Association for SQL Server ( PASS) and it's > community of SQL Professionals. > "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... > > I'm using the Web service library's ReportingService.Render function to > > export a report to PDF format. > > > > After 90-100 seconds of processing, the call to Render throws an exception > > saying that "The operation has timed-out", but the ReportServer keeps on > > grinding at the report. The report is eventually finished succesfully, as > > I > > can see in the RS Execution Log that it ends with a status of 'rfSuccess'. > > Data time is under a second, Process time is almost 7 seconds, and render > > time is about 150 seconds. Nothing's timing out on the server side. > > > > How do I extend the timeout for the Render call so that my application
I'm having the same problem - one of my reports takes about 3 min to execute. I tried everything - web server(s) timeouts, report server configs, report settings, machine.config changes, aspx page Server.ScriptTimeout - everything - still getting "The operation has timed-out." error after about 2 min of execution. 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 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) What exactly did you do to force the Timeout property to 300000? I cannot find an exact place to set that value. Thanks. [quoted text, click to view] "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message news:58373C3A-40E6-44D5-B41C-53E865AA7E57@microsoft.com... > I've been through there and played with plenty of values, but never found > anything that would help with the timeout in my Render call. > > I did find a fix to the problem though - not sure if it's the best way to > do > it: > I modified my Reference.cs file for the SOAP Web Reference to the Report > Server to force the Timeout property to 300000. I figure that'll give my > app > 5 minutes before the Render call times out. > > "Wayne Snyder" wrote: > >> Take a look at rsreportserver.config in the reportserver directory. >> >> -- >> Wayne Snyder MCDBA, SQL Server MVP >> Mariner, Charlotte, NC >> (Please respond only to the newsgroup.) >> >> I support the Professional Association for SQL Server ( PASS) and it's >> community of SQL Professionals. >> "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message >> news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... >> > I'm using the Web service library's ReportingService.Render function to >> > export a report to PDF format. >> > >> > After 90-100 seconds of processing, the call to Render throws an >> > exception >> > saying that "The operation has timed-out", but the ReportServer keeps >> > on >> > grinding at the report. The report is eventually finished succesfully, >> > as >> > I >> > can see in the RS Execution Log that it ends with a status of >> > 'rfSuccess'. >> > Data time is under a second, Process time is almost 7 seconds, and >> > render >> > time is about 150 seconds. Nothing's timing out on the server side. >> > >> > How do I extend the timeout for the Render call so that my application >> > sticks around long enough to get the report from RS?
never mind. I found it - in the constructor of the ReportingService place this.Timeout=........ works finally. Thanks. [quoted text, click to view] "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message news:ODN80FooFHA.904@TK2MSFTNGP10.phx.gbl... > I'm having the same problem - one of my reports takes about 3 min to > execute. > I tried everything - web server(s) timeouts, report server configs, > report settings, machine.config changes, aspx page Server.ScriptTimeout - > everything - still getting "The operation has timed-out." error after > about 2 min of execution. > > 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 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) > > What exactly did you do to force the Timeout property to 300000? > I cannot find an exact place to set that value. > Thanks. > > "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > news:58373C3A-40E6-44D5-B41C-53E865AA7E57@microsoft.com... >> I've been through there and played with plenty of values, but never found >> anything that would help with the timeout in my Render call. >> >> I did find a fix to the problem though - not sure if it's the best way to >> do >> it: >> I modified my Reference.cs file for the SOAP Web Reference to the Report >> Server to force the Timeout property to 300000. I figure that'll give my >> app >> 5 minutes before the Render call times out. >> >> "Wayne Snyder" wrote: >> >>> Take a look at rsreportserver.config in the reportserver directory. >>> >>> -- >>> Wayne Snyder MCDBA, SQL Server MVP >>> Mariner, Charlotte, NC >>> (Please respond only to the newsgroup.) >>> >>> I support the Professional Association for SQL Server ( PASS) and it's >>> community of SQL Professionals. >>> "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message >>> news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... >>> > I'm using the Web service library's ReportingService.Render function >>> > to >>> > export a report to PDF format. >>> > >>> > After 90-100 seconds of processing, the call to Render throws an >>> > exception >>> > saying that "The operation has timed-out", but the ReportServer keeps >>> > on >>> > grinding at the report. The report is eventually finished >>> > succesfully, as >>> > I >>> > can see in the RS Execution Log that it ends with a status of >>> > 'rfSuccess'. >>> > Data time is under a second, Process time is almost 7 seconds, and >>> > render >>> > time is about 150 seconds. Nothing's timing out on the server side. >>> > >>> > How do I extend the timeout for the Render call so that my application >>> > sticks around long enough to get the report from RS? > >
Hi Oleg, is this a permanent solution. dont you face this problem of Timeout again? Please let me know if i can use this solution for my reports where it takes more time to render. Thanks Bava [quoted text, click to view] "Oleg Yevteyev" wrote: > never mind. > I found it - in the constructor of the ReportingService place > this.Timeout=........ > works finally. > Thanks. > > "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message > news:ODN80FooFHA.904@TK2MSFTNGP10.phx.gbl... > > I'm having the same problem - one of my reports takes about 3 min to > > execute. > > I tried everything - web server(s) timeouts, report server configs, > > report settings, machine.config changes, aspx page Server.ScriptTimeout - > > everything - still getting "The operation has timed-out." error after > > about 2 min of execution. > > > > 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 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) > > > > What exactly did you do to force the Timeout property to 300000? > > I cannot find an exact place to set that value. > > Thanks. > > > > "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > > news:58373C3A-40E6-44D5-B41C-53E865AA7E57@microsoft.com... > >> I've been through there and played with plenty of values, but never found > >> anything that would help with the timeout in my Render call. > >> > >> I did find a fix to the problem though - not sure if it's the best way to > >> do > >> it: > >> I modified my Reference.cs file for the SOAP Web Reference to the Report > >> Server to force the Timeout property to 300000. I figure that'll give my > >> app > >> 5 minutes before the Render call times out. > >> > >> "Wayne Snyder" wrote: > >> > >>> Take a look at rsreportserver.config in the reportserver directory. > >>> > >>> -- > >>> Wayne Snyder MCDBA, SQL Server MVP > >>> Mariner, Charlotte, NC > >>> (Please respond only to the newsgroup.) > >>> > >>> I support the Professional Association for SQL Server ( PASS) and it's > >>> community of SQL Professionals. > >>> "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > >>> news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... > >>> > I'm using the Web service library's ReportingService.Render function > >>> > to > >>> > export a report to PDF format. > >>> > > >>> > After 90-100 seconds of processing, the call to Render throws an > >>> > exception > >>> > saying that "The operation has timed-out", but the ReportServer keeps > >>> > on > >>> > grinding at the report. The report is eventually finished > >>> > succesfully, as > >>> > I > >>> > can see in the RS Execution Log that it ends with a status of > >>> > 'rfSuccess'. > >>> > Data time is under a second, Process time is almost 7 seconds, and > >>> > render > >>> > time is about 150 seconds. Nothing's timing out on the server side. > >>> > > >>> > How do I extend the timeout for the Render call so that my application > >>> > sticks around long enough to get the report from RS? > > > > > >
Oleg, good morning! What is the name of the config file did up go into to update the timeout value? Thank you in advance for your assistance. [quoted text, click to view] "Oleg Yevteyev" wrote: > never mind. > I found it - in the constructor of the ReportingService place > this.Timeout=........ > works finally. > Thanks. > > "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message > news:ODN80FooFHA.904@TK2MSFTNGP10.phx.gbl... > > I'm having the same problem - one of my reports takes about 3 min to > > execute. > > I tried everything - web server(s) timeouts, report server configs, > > report settings, machine.config changes, aspx page Server.ScriptTimeout - > > everything - still getting "The operation has timed-out." error after > > about 2 min of execution. > > > > 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 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) > > > > What exactly did you do to force the Timeout property to 300000? > > I cannot find an exact place to set that value. > > Thanks. > > > > "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > > news:58373C3A-40E6-44D5-B41C-53E865AA7E57@microsoft.com... > >> I've been through there and played with plenty of values, but never found > >> anything that would help with the timeout in my Render call. > >> > >> I did find a fix to the problem though - not sure if it's the best way to > >> do > >> it: > >> I modified my Reference.cs file for the SOAP Web Reference to the Report > >> Server to force the Timeout property to 300000. I figure that'll give my > >> app > >> 5 minutes before the Render call times out. > >> > >> "Wayne Snyder" wrote: > >> > >>> Take a look at rsreportserver.config in the reportserver directory. > >>> > >>> -- > >>> Wayne Snyder MCDBA, SQL Server MVP > >>> Mariner, Charlotte, NC > >>> (Please respond only to the newsgroup.) > >>> > >>> I support the Professional Association for SQL Server ( PASS) and it's > >>> community of SQL Professionals. > >>> "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message > >>> news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... > >>> > I'm using the Web service library's ReportingService.Render function > >>> > to > >>> > export a report to PDF format. > >>> > > >>> > After 90-100 seconds of processing, the call to Render throws an > >>> > exception > >>> > saying that "The operation has timed-out", but the ReportServer keeps > >>> > on > >>> > grinding at the report. The report is eventually finished > >>> > succesfully, as > >>> > I > >>> > can see in the RS Execution Log that it ends with a status of > >>> > 'rfSuccess'. > >>> > Data time is under a second, Process time is almost 7 seconds, and > >>> > render > >>> > time is about 150 seconds. Nothing's timing out on the server side. > >>> > > >>> > How do I extend the timeout for the Render call so that my application > >>> > sticks around long enough to get the report from RS? > > > > > >
It is not in config file. Open your Reporing service's web service reference file and in constractor add: "this.Timeout=......." Works for web service access method. Hope, this helps. [quoted text, click to view] "Terry" <Terry@discussions.microsoft.com> wrote in message news:F23236CC-7A1E-4906-977C-D06B0029B0F6@microsoft.com... > Oleg, good morning! > > What is the name of the config file did up go into to update the timeout > value? > > Thank you in advance for your assistance. > > "Oleg Yevteyev" wrote: > >> never mind. >> I found it - in the constructor of the ReportingService place >> this.Timeout=........ >> works finally. >> Thanks. >> >> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message >> news:ODN80FooFHA.904@TK2MSFTNGP10.phx.gbl... >> > I'm having the same problem - one of my reports takes about 3 min to >> > execute. >> > I tried everything - web server(s) timeouts, report server configs, >> > report settings, machine.config changes, aspx page >> > Server.ScriptTimeout - >> > everything - still getting "The operation has timed-out." error after >> > about 2 min of execution. >> > >> > 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 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) >> > >> > What exactly did you do to force the Timeout property to 300000? >> > I cannot find an exact place to set that value. >> > Thanks. >> > >> > "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message >> > news:58373C3A-40E6-44D5-B41C-53E865AA7E57@microsoft.com... >> >> I've been through there and played with plenty of values, but never >> >> found >> >> anything that would help with the timeout in my Render call. >> >> >> >> I did find a fix to the problem though - not sure if it's the best way >> >> to >> >> do >> >> it: >> >> I modified my Reference.cs file for the SOAP Web Reference to the >> >> Report >> >> Server to force the Timeout property to 300000. I figure that'll give >> >> my >> >> app >> >> 5 minutes before the Render call times out. >> >> >> >> "Wayne Snyder" wrote: >> >> >> >>> Take a look at rsreportserver.config in the reportserver directory. >> >>> >> >>> -- >> >>> Wayne Snyder MCDBA, SQL Server MVP >> >>> Mariner, Charlotte, NC >> >>> (Please respond only to the newsgroup.) >> >>> >> >>> I support the Professional Association for SQL Server ( PASS) and >> >>> it's >> >>> community of SQL Professionals. >> >>> "Ben Shaffer" <BenShaffer@discussions.microsoft.com> wrote in message >> >>> news:A26B272B-BA01-4E9E-8ECB-F6AD572E82C5@microsoft.com... >> >>> > I'm using the Web service library's ReportingService.Render >> >>> > function >> >>> > to >> >>> > export a report to PDF format. >> >>> > >> >>> > After 90-100 seconds of processing, the call to Render throws an >> >>> > exception >> >>> > saying that "The operation has timed-out", but the ReportServer >> >>> > keeps >> >>> > on >> >>> > grinding at the report. The report is eventually finished >> >>> > succesfully, as >> >>> > I >> >>> > can see in the RS Execution Log that it ends with a status of >> >>> > 'rfSuccess'. >> >>> > Data time is under a second, Process time is almost 7 seconds, and >> >>> > render >> >>> > time is about 150 seconds. Nothing's timing out on the server >> >>> > side. >> >>> > >> >>> > How do I extend the timeout for the Render call so that my >> >>> > application >> >>> > sticks around long enough to get the report from RS? >> > >> > >> >> >>
I'm having the same problem - one of my reports takes about 1hr to complete, it was working fine before. Just recently it was started getting this error. I tried everything - web server(s) timeouts, report server configs, report settings, machine.config changes, aspx page Server.ScriptTimeout - everything - still getting "The operation has timed-out." error after about 1-2 min of execution. Error: The operation has timed-out. 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) Pls suggest me if any one have the solution.
Don't see what you're looking for? Try a search.
|
|
|