Click here to Skip to main content
15,887,585 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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.
XML
<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.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900