Monday, March 12, 2012

Reporting Service Web Service Timeout ERROR !!!

Hi,

I am trying to generate a report using the Reporting Service Web Services. The report is getting generated on a completely different server. The Stored procedure used for generating the report is taking about 5-6 hours, since the data and processing is huge.

After some time I get an Timeout error for the web services. The error is described below:

Exception : System.Net.WebException: 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)

at GetReport._01hw071633.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)

at GetReport.ReportProperties.renderReport(ArrayList objParam)

at JobServer.JobServerMain.RunReport(String reportName)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.\

Can any body suggest me an effecient technique for requesting the reports without timeouts.

Thanks for your help, in advance !

-Sandeep

The Error has been resolved. I set the web service timeout to infinity. :)

-Sandy

1 comment:

Unknown said...

Hi ,
Am trying to export the ssrs report to Excel.i have used the expression as "Ceiling(rownumber(nothing)/65000)".

Its working for some reports..but in group by reports i got an error like "system.outofmemoryexception" while export to excel.

Please let me know if you have any idea...

Post a Comment