search cancel

Teradata connection: [Error 1000] [SQLState 08S01] Login failure

book

Article ID: 243308

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Downloaded and installed the latest TDM Portal version (with corresponding FDM version).

Upgrade the FDM, use below link to download
https://ftp.broadcom.com/user/downloads/priv/cbtmaint/zahab01/TDM/FDM/FastDataMasker-4.10.18.0.zip
https://ftp.broadcom.com/user/downloads/priv/cbtmaint/zahab01/TDM/FDM/FastDataMasker-4.10.18.0.tar.gz

 
Upgrade Portal , use below link to download
 https://ftp.broadcom.com/user/downloads/priv/cbtmaint/zahab01/TDM/TDMPortal/TDMWeb-4.10.32.0.zip

However, the tool fails to connect to Teradata with any type of login mechanisms:

Here are the connection Parameters:

Profile Name: DWTest3
Description: ....

DBMS: Teradata

Server*  <Our Server URL>                                Port: 

Use a Specific Database: (Tried with both the options viz. Use Named database or Do not specify database

User Name*   <my userID                                     Password*    <My Password for LDAP/Non-LDAP both mechanisms>

Additional connection properties: <Tried with LOGMECH=LDAP and LOGMECH=TD2 and also without anything... it fails.

The server replies with the below message:

Failed to connect.

Failed to obtain JDBC Connection; [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1000] [SQLState 08S01] Login failure for Connection to DWTEST3.CORP.ABC.COM Fri Jun 03 15:22:37 CDT 2022 socket orig=DWTEST3.CORP.ABC.COM cid=5e7404ff sess=0 java.net.UnknownHostException: DWTEST3.CORP.ABC.COM at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324) at java.net.InetAddress.getAllByName0(InetAddress.java:1277) at java.net.InetAddress.getAllByName(InetAddress.java:1193) at java.net.InetAddress.getAllByName(InetAddress.java:1127) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.doLookup(TDNetworkIOIF.java:223) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.getAddresses(TDNetworkIOIF.java:261) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:381) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:156) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:142) at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO(GenericTeradataConnection.java:143) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:100) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:211) 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) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:171) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:236) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:162) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:155) at

Cause

Using wrong JDBC driver.

Environment

Release : 4.10.32.0

Component : TDM Web Portal

Database: Teradata 16.20

Resolution

Using Teradata JDBC driver, TeraJDBC__indep_indep.17.10.00.27.zip, resolved the issue.

This JDBC driver can be downloaded from:

https://downloads.teradata.com/

You must create a Teradata account to get access to the driver.