Error in configuring webservices transformer

[babbu9]

Hi
I am having a job that receives data from a flat file which is used to query and get information from a webservice. Here is the flow:

FF-> transformer->Webservice transformer -> XML input ->FF

I am getting the below error:

Web_Services_Transformer_7,0: Warning: Untitled2.Web_Services_Transformer_7: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>soapenv:Server.userException</faultcode>
<faultstring>java.net.ConnectException: Connection refused</faultstring>

The request works through SOAP UI and there is no issue obtaining data from the WSDL.

Please inform how to troubleshoot.

[qt_ky]

Sometimes "connection refused" could be caused by a firewall blocking traffic from your server whereas traffic from your soapUI client may not be blocked.

[eostic]

One of the best things you can do is to design a test Job using a Server Job, and then when running it, check the "trace" tab, and then check your ws transformer stage on the left and ALL FOUR boxes on the right. You will get a voluminous trace with 2 xml's in the middle....the SOAP going OUT and the SOAP coming in...that will tell you if it ever got "out" of your DS engine...

Ernie

[babbu9]

Enabling tracing in server job did not provide any additional detail. Here is the error message. How do we troubleshoot the issue?



Untitled1..Web_Services_Transformer_0: com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode xmlns="">Server.userException</faultcode>
<faultstring xmlns="">java.net.ConnectException: Connection refused</faultstring>
<detail xmlns="">
<stackTrace xmlns="http://xml.apache.org/axis/">java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:370)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:232)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:219)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:528)
at com.ibm.jsse2.SSLSocketImpl.connect(SSLSocketImpl.java:774)
at com.ibm.jsse2.SSLSocketImpl.<init>(SSLSocketImpl.java:578)
at com.ibm.jsse2.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:1)
at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:130)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:157)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:114)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:180)
at org.apache.axis.client.Call.invokeEngine(Call.java:2564)
at org.apache.axis.client.Call.invoke(Call.java:2553)
at org.apache.axis.client.Call.invoke(Call.java:1753)
at com.ascentialsoftware.wsclient.OperationCall.invoke(OperationCall.java:285)
at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1685)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1591)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1544)
at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:105)
at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544)
at com.ascentialsoftware.jds.StageFactory.runTransformer(StageFactory.java:361)
</stackTrace>
</detail>
</Fault>
at com.ascentialsoftware.wsclient.OperationCall.handleRemoteException(OperationCall.java:388)
at com.ascentialsoftware.wsclient.OperationCall.invoke(OperationCall.java:293)
at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1685)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1591)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1544)
at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:105)
at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544)
at com.ascentialsoftware.jds.StageFactory.runTransformer(StageFactory.java:361)