all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Web Service render Timeout



Re: Web Service render Timeout Wayne Snyder
8/15/2005 12:00:00 AM
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]

Web Service render Timeout Ben Shaffer
8/15/2005 11:10:04 AM
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
Re: Web Service render Timeout Ben Shaffer
8/15/2005 12:06:08 PM
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]
Re: Web Service render Timeout Oleg Yevteyev
8/16/2005 9:42:12 AM
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]

Re: Web Service render Timeout Oleg Yevteyev
8/16/2005 9:56:36 AM
never mind.
I found it - in the constructor of the ReportingService place
this.Timeout=........
works finally.
Thanks.

[quoted text, click to view]

Re: Web Service render Timeout Bava Mani
9/21/2005 9:36:09 AM
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]
Re: Web Service render Timeout Terry
12/8/2005 7:02:03 AM
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]
Re: Web Service render Timeout Oleg Yevteyev
12/22/2005 2:56:54 PM
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]

Re:Web Service render Timeout bala
10/22/2007 12:56:47 PM
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.
AddThis Social Bookmark Button