All Forums Connectivity
Anish 8 posts Joined 11/09
18 Mar 2014
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

vhari 111 posts Joined 12/08
18 Mar 2014

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
 
 

sunil.007 1 post Joined 06/12
12 Jun 2014

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

You must sign in to leave a comment.