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