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

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

Reporting Service 2000 Error: ...is not accessible in this context because it is Private.

I am coding for Reporting Services 2000 (the one under the code tab) and these following codes. It generated an error:...There is an error on line 31 of custom code: [BC30390] 'Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.CustomCodeProxyBase.a' is not accessible in this context because it is 'Private'.

So.. I changed the declaration of the variables. From Dim, I changed it Public Dim but after changing, this error occurred:...There is an error on line 5 of custom code: [BC30247] 'Public' is not valid on a local variable declaration.

Please help.. Thanks! Here's my code..

Public Shared Function GetChargeWgt(housenoas string, chrgwtas Decimal)
Public Dim MyConnObjas ADODB.Connection
Public Dim myRecSetas ADODB.Recordset
Public Dim SQLas string
Public Dim cwas Decimal
 MyConnObj.Open _
 ("Provider = sqloledb;" & _
 "Data Source=<datasource here>;" & _
 "Initial Catalog=<database name here>;" & _
 "User ID=<uname>;" & _
 "Password=<pword>;")
 SQL = "SELECT a.house_no, "
 SQL = SQL + "CASEWHEN a.book_type_id ='AE'OR a.book_type_id ='AI'THEN (SELECTCAST(a.charge_valueAS DECIMAL(10,2))) "
 SQL = SQL + "WHEN a.book_type_id ='SE'OR a.book_type_id ='SI'THEN (SELECTCAST(a.gross_valueAS DECIMAL(10,2))) "
 SQL = SQL + "END AS chargeweight "
 SQL = SQL + "FROM OPR_BKPARMS_TR a "
 SQL = SQL + "WHEREa.house_no ='" + houseno + "'"
 myRecSet.Open(SQL, MyConnObj)
 cw = myRecSet.Fields(a.house_no)
return cw
End Function

I saw one post which said that I should try using Protected.. I did followed it but it still had the same error..

>_<

|||

Hi,

So.. I changed the declaration of the variables. From Dim, I changed it Public Dim but after changing, this error occurred: ...There is an error on line 5 of custom code: [BC30247] 'Public' is not valid on a local variable declaration.

From your description, it seems that the system can't access the data table object a. Since you have declared the private connection and recordset. So please try to make sure if the data table is accessible first, also, try to declare your variable in your class level instead of in a shared method.

Thanks.

|||

Oh.. I'll try it out.. Thanks