WCF with SSRS query throwing 404 not found error
I have created a WCF service which I am trying to consume in SSRS report. In Visual Studio 2008, I created a Report Server Project and provided the Shared Data Source as XML which pointed to the web service. Now, I am trying to create a report and pass a XML query (<Query> </Query>) to the WCF service. However, I get the following error: "Failed to execute web request for the specified URL. Not Found: The remote server returned an error: (404) not found." The query I am using is: <Query> <Method Name="ImgRequestGUID" Namespace="http://localhost/2011/imageservice"> <Parameters> <Parameter Name="guid"></Parameter> </Parameters> </Method> <SoapAction> http://localhost/2011/imageservice/IGetImgLib/getImage </SoapAction> </Query> And I must point out that the WCF URL is working fine. The stack trace of the error is: =================================== An error occurred while executing the query. Failed to execute web request for the specified URL. Not Found: The remote server returned an error: (404) Not Found. (Microsoft SQL Server Report Designer) =================================== Failed to execute web request for the specified URL. Not Found: The remote server returned an error: (404) Not Found. (mscorlib) ------------------------------ Program Location: Server stack trace: at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteWebRequest(ICredentials credentials) at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.Execute() at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.<>c__DisplayClass1.<ExecuteReader>b__0() at Microsoft.ReportingServices.DataExtensions.XmlDP.WebRequestHelper.ExecuteServerCallAsNtUser(ServerCall serverCall, WindowsIdentity ntUser) at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.AsyncExecuteReader(IDbCommand command, CommandBehavior behaviour) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase) at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData) at Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.ExecuteReaderHandler.EndInvoke(IAsyncResult result) at Microsoft.ReportingServices.QueryDesigners.MultiThreadedQueryResultsHelper.<>c__DisplayClass1.<ExecuteActiveQueryCallback>b__0() at Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.EndExecuteReaderInUiThread(GetDataReaderHandler getDataReaderCallback) =================================== The remote server returned an error: (404) Not Found. Any help will be greatly appreciated!!
August 27th, 2011 4:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics