Error with SSRS as a Web Service

  • I am using the Reports as a web service for Reporting Service

    I am getting the following error on the Render menthod of ReportingService class

    System.Web.Services.Protocols.SoapException was unhandled by user code

    Message="System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.ReportProcessing.ParameterInfoCollection.ToUrl(NameValueCollection coll) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds)"

    Source="ReportSampleForWebService"

    Actor="http://gshah755/ReportServer/ReportService.asmx"

    Lang=""

    Node="http://gshah755/ReportServer/ReportService.asmx"

    Role=""

    StackTrace:

    at ReportSampleForWebService._Default.Page_Load(Object sender, EventArgs e) in E:\Gunjan\PracticeProjects\ReportSampleForWebService\ReportSampleForWebService\Default.aspx.cs:line 110

    at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

    at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

    at System.Web.UI.Control.OnLoad(EventArgs e)

    at System.Web.UI.Control.LoadRecursive()

    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Thanks.

    Gunjan.

  • Hi Gunjan,

    Can you elaborate this issue....so that it would be easier to understand...exactly when you are receiving this error message...

    Thanks,

    Niraj

  • Hi Niraj,

    My report is drill down report. This error comes at the rs.Render(........) method of the reporting web service.

    Thanks.

    Gunjan.

  • Hi Gunjan,

    Well..."http://gshah755/ReportServer/ReportService.asmx"....did you try using "localhost" in-place of gshah755 [which I guess is your system..:)]..Just try adding Web Reference for "http://localhost/reportserver/reportservice2005.asmx".....in your application..

    I hope...it will work....

    Regds,

    Niraj

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply