ODBC clients tries to connect o ADS and fails
Article ID: KB0082860
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | ALL VERSIONS |
Description
ODBC clients tries to connect to ADS and fails. The following message is seen in cs_server.log:
Remote /172.31.77.109:3959 has prematurely closed the connection. Last received message is: handshake 1 1.[dbchannel-1908515]
Remote /172.31.77.109:3959 has prematurely closed the connection. Last received message is: handshake 1 1.[dbchannel-1908515]
Issue/Introduction
ODBC clients tries to connect o ADS and fails
Resolution
dbchannel is the name of the ADS Java thread that handles database connections between an incoming client and an outgoing data source connection.
The error you're getting appears because the TCP connection was established and then terminated by something in the middle after it was established. This is usually caused by firewalls set to filter at the application layer of the TCP protocol. These firewalls inspect the actual payload of IP packets and try to determine if the traffic is of a type that is allowed.
So you may have port 9401 open, but is the Firewall filtering based on application type? If so the handshake will succeed (Because the handshake isn't ODBC specific) and then as soon as actual ODBC commands start flowing the firewall will see that and say "ODBC is not allowed, I'm terminating this connection."
The error you're getting appears because the TCP connection was established and then terminated by something in the middle after it was established. This is usually caused by firewalls set to filter at the application layer of the TCP protocol. These firewalls inspect the actual payload of IP packets and try to determine if the traffic is of a type that is allowed.
So you may have port 9401 open, but is the Firewall filtering based on application type? If so the handshake will succeed (Because the handshake isn't ODBC specific) and then as soon as actual ODBC commands start flowing the firewall will see that and say "ODBC is not allowed, I'm terminating this connection."
Feedback
Yes
No
Powered by
