Troubleshooting
Problem
IBM Data Replication fails to log in / access Teradata database that uses JDBC connections with log in failure "SSLMODE=PREFER cannot use Teradata port 1025 connection because the database has HTTPS connections enabled, but a connection cannot be made on HTTPS port 443"
Symptom
IDR instance fails to start or instance fails to be created and following error is seen in instance logs.
Error: [Teradata JDBC Driver] [TeraJDBC 17.10.00.20] [Error 1000] [SQLState 08S01]
Login failure for Connection to myserver.mydomain.com Thu Aug 19 23:37:16 EDT 2021 socket orig=myserver.mydomain.com cid=xxxxxxx sess=0 java.io.IOException:
SSLMODE=PREFER cannot use Teradata port 1025 connection because the database has HTTPS connections enabled, but a connection cannot be made on HTTPS port 443.
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.isUsableSocket(TDNetworkIOIF.java:1509)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:613)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:184)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createIO(TDNetworkIOIF.java:175)
at com.teradata.jdbc.jdbc.GenericTeradataConnection.<init>(GenericTeradataConnection.java:294)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:186)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:36)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:181)
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"ARM Category":[{"code":"a8m0z000000cwskAAA","label":"Teradata"},{"code":"a8m0z000000cwb9AAA","label":"Troubleshooting-\u003ETroubleshooting data replication"},{"code":"a8m0z000000cwbTAAQ","label":"Troubleshooting-\u003ETroubleshooting network and connectivity issues"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.4.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
03 September 2021
UID
ibm16485893