Hi,
I am trying to comsume a WCF service in my SSRS report.
The service when executed in query designer executes successfully but when I try to execute the report, I get below error.
An existing connection was forcibly closed by the remote host
----------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
----------------------------
The underlying connection was closed: An unexpected error occurred on a receive.
----------------------------
Failed to execute web request for the specified URL. (rsXmlDataProviderError)
----------------------------
Query execution failed for dataset 'Get_PHPData'. (rsErrorExecutingCommand)
----------------------------
Looking at the error, it looks like more of a connection issue, but I am not sure what and where to check since I am totally new to this concept of consuming a service in SSRS.
Below is my query.
<Query>
<Method Name="GetPHDData" Namespace="http://tempuri.org/">
<Parameters>
<Parameter Name="TagNames"></Parameter>
<Parameter Name="StartTime"></Parameter>
<Parameter Name="EndTime"></Parameter>
<Parameter Name="SampleMethod"></Parameter>
<Parameter Name="SampleFrequency"></Parameter>
</Parameters>
</Method>
<SoapAction>
http://tempuri.org/ICHEVRONPHDAccess/GetPHDData
</SoapAction>
</Query>
This executes in query designer with no issue. I tried to change the tempuri to localhost there it gives me error.
An error occurred while executing the query.
Failed to execute web request for the specified URL.
Soap Fault:
The message with Action 'http://localhost/IPHPAccess/GetPHPData' cannot be processed at the receiver, due to a ContractFilter mismatch at the EndpointDispatcher.
Any help in this is highly appreciated.
Thanks.
What I have tried:
I checked the data source connection. It is ok. I can connect and call the service from query designer.