SQL Server Reporting Services proxy timeout (ASP.NET)
Posted
by
Philip
on Stack Overflow
See other posts from Stack Overflow
or by Philip
Published on 2010-02-25T10:15:08Z
Indexed on
2010/12/25
14:54 UTC
Read the original article
Hit count: 454
Morning,
We are using SSRS (2005) and have a ASP.NET frontend using the SSRS WebControl.
I've boiled the problem down the time it takes for one particular report to be generated is greater than the timeout on the proxy server.
It looks like the way the SSRS web control tries to do things is by performing an HTTP request for the report, however the problem with this is the request can timeout potentially before the report has generated. Looking at the HTTP traffic the response is a 504 (gateway timeout).
Is there a way to increase the timeout or change SSRS WebControl to use more robust polling mechanism (which isn't dependant on the timeout of the HTTP request).
I could be wrong but I don't think ServerReport.Timeout property would resolve the issue we are seeing?
Any thoughts?
Philip
© Stack Overflow or respective owner
