OBIEE Configuration : [113][State: 08001] [Teradata][Unix system error] 113 Socket error

Connectivity
Enthusiast

OBIEE Configuration : [113][State: 08001] [Teradata][Unix system error] 113 Socket error

Connection open failed:

[113][State: 08001] [Teradata][Unix system error]  113 Socket error - The Teradata server can't currently be reached over this network

Connection open failed

If you get this error, try to ping the database IP and check port (1025). If the database and port  connection is open this error will be gone.

To test database connection, use the following comand (For Obiee data source connectivity from Linux machine)

[biuser@linuxdev setup]$ nqcmd -d TeradataTestDS -u usr1 -p pwd1 -s myquery.sql > myresults.out

2 REPLIES
Teradata Employee

Re: OBIEE Configuration : [113][State: 08001] [Teradata][Unix system error] 113 Socket error

Teradata ODBC driver pkg. installs a connectivity test tool.  By default, it can be found in, 

TTU 14.10

32-bit : /opt/teradata/client/14.10/odbc_32/bin/tdxodbc -h

64-bit : /opt/teradata/client/14.10/odbc_64/bin/tdxodbc -h

Re: OBIEE Configuration : [113][State: 08001] [Teradata][Unix system error] 113 Socket error

Hi, I also got the same issue in my environment while testign the odbc connection for TD thru nqcmd and tdxodbc.

Then i chnage the IP address instead of HOSTNAME and tested the connection again and it got successfully connected.

DBCName = <MENTION IP ADDRESS>


[X_TD_CONN]

Driver = /opt/teradata/client/14.10/odbc_64/lib/tdata.so

Description = NCR 3600 running Teradata V2R5.2

DBCName = <MENTION IP ADDRESS>

LastUser = 

Username = 

Password = 

Database = 

DefaultDatabase = CFDW2_xxxx

MaxRespSize = 1048576

LoginTimeout=100000000