TDV is unable to connect to a web-service data source using HTTPS SSL. How can I determine whether the network is the cause?
Article ID: KB0081959
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.0 and higher |
Description
TDV is unable to connect to a web-service data source using HTTPS SSL. How can I determine whether the network is the cause?
Issue/Introduction
TDV is unable to connect to a web-service data source using HTTPS SSL. How can I determine whether the network is the cause?
Resolution
To check, you can do the following:
(1) Reproduce the issue.
(2) Open cs_server.log with any text editor.
(3) Scroll to the end of the log to find the stack trace. For instance, if you reproduced the problem at 2018-05-12 17:11:35, there will be a trace in the log, time-stamped with "2018-05-12 17:11:35".
(4) Look at the last "Caused by" line in the stack trace. This is the Root Cause line. Does this line contain "java.net.ConnectException"? If it does, it means that the Root Cause is a network connectivity problem (java.net is the Java network api).
Below is a sample trace, followed by an explanation:
ERROR [jetty thread pool-16439] 2018-05-12 17:11:35.036 +0100 Util -
Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
at com.compositesw.common.CompositeRuntimeException.rethrow(CompositeRuntimeException.java:141)
at com.compositesw.cdms.ds.soap.SoapRequest.MyFirstSoapOperation(SoapRequest.java:78)
...
Caused by: com.compositesw.cdms.datasource.IafException: Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
at com.compositesw.cdms.ds.soap.SoapConnection.callSoap(SoapConnection.java:434)
at com.compositesw.cdms.ds.soap.SoapConnection.call(SoapConnection.java:154)
at com.compositesw.cdms.ds.soap.SoapRequest.MyFirstSoapOperation(SoapRequest.java:66)
...
Caused by: javax.xml.ws.WebServiceException: java.io.IOException: java.net.ConnectException: Connection refused: connect
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:276)
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.processRequest(HttpSoapTransportPipe.java:282)
...
Caused by: java.io.IOException: java.net.ConnectException: Connection refused: connect
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:271)
...
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source)
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
at com.compositesw.common.net.AuthSSLProtocolSocketFactory.createSocket(AuthSSLProtocolSocketFactory.java:423)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:238)
... 17 more
ERROR [jetty thread pool-16439] 2018-05-12 17:11:35.036 +0100 Util -
---------------------- SUMMARY --------------------
Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
Cause: java.io.IOException: java.net.ConnectException: Connection refused: connect
---------------------------------------------
Explanation
The stack trace shows three layers - Network, SSL, and SOAP. The request is failing at the Network layer.
(1) Reproduce the issue.
(2) Open cs_server.log with any text editor.
(3) Scroll to the end of the log to find the stack trace. For instance, if you reproduced the problem at 2018-05-12 17:11:35, there will be a trace in the log, time-stamped with "2018-05-12 17:11:35".
(4) Look at the last "Caused by" line in the stack trace. This is the Root Cause line. Does this line contain "java.net.ConnectException"? If it does, it means that the Root Cause is a network connectivity problem (java.net is the Java network api).
Below is a sample trace, followed by an explanation:
ERROR [jetty thread pool-16439] 2018-05-12 17:11:35.036 +0100 Util -
Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
at com.compositesw.common.CompositeRuntimeException.rethrow(CompositeRuntimeException.java:141)
at com.compositesw.cdms.ds.soap.SoapRequest.MyFirstSoapOperation(SoapRequest.java:78)
...
Caused by: com.compositesw.cdms.datasource.IafException: Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
at com.compositesw.cdms.ds.soap.SoapConnection.callSoap(SoapConnection.java:434)
at com.compositesw.cdms.ds.soap.SoapConnection.call(SoapConnection.java:154)
at com.compositesw.cdms.ds.soap.SoapRequest.MyFirstSoapOperation(SoapRequest.java:66)
...
Caused by: javax.xml.ws.WebServiceException: java.io.IOException: java.net.ConnectException: Connection refused: connect
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:276)
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.processRequest(HttpSoapTransportPipe.java:282)
...
Caused by: java.io.IOException: java.net.ConnectException: Connection refused: connect
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:271)
...
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source)
at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
at com.compositesw.common.net.AuthSSLProtocolSocketFactory.createSocket(AuthSSLProtocolSocketFactory.java:423)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:238)
... 17 more
ERROR [jetty thread pool-16439] 2018-05-12 17:11:35.036 +0100 Util -
---------------------- SUMMARY --------------------
Execution of SOAP operation "MyFirstSoapOperation" failed. [data-2915055]
Cause: java.io.IOException: java.net.ConnectException: Connection refused: connect
---------------------------------------------
Explanation
The stack trace shows three layers - Network, SSL, and SOAP. The request is failing at the Network layer.
Level 3 (Network Layer) Caused by: java.net.ConnectException: Connection refused: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.Socket.connect(Unknown Source) Level 2 (SSL Layer) at sun.security.ssl.SSLSocketImpl.connect(Unknown Source) at sun.security.ssl.SSLSocketImpl.<init>(Unknown Source) at sun.security.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source) at com.compositesw.common.net.AuthSSLProtocolSocketFactory.createSocket(AuthSSLProtocolSocketFactory.java:423) at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706) Level 1 (SOAP Layer) at com.compositesw.cdms.ds.soap.HttpSoapTransportPipe.process(HttpSoapTransportPipe.java:238)
Feedback
Yes
No
Powered by
