Our users are getting the following CLI error while trying to connect to any Teradata database after the Teradata client got updated to 16.10 over the weekend. Could someone please help me resolve this ?
ERROR: CLI error trying to establish connection: 523 586
Thanks everyone for your valuable responses!
Apparently the issue was because the Teradata Client 16.10 upgrade modified the following symbolic links under /usr/lib64
Below is the summary that I documented for this
Issue: The below CLI error occurs while connecting to a database
ERROR: CLI error trying to establish connection: 523 586
ERROR: CLI error trying to establish connection: 523 80
Root Cause:
The Teradata client 16.10 upgrade modified the symbolic links under /usr/lib64 that were essential for any odbc connections
Resolution Steps:
Before:
/usr/lib64/libodbcinst.so -> /p01/app/ncr/teradata/client/16.10/lib64/libodbcinst.so
/usr/lib64/libodbc.so -> /p01/app/ncr/teradata/client/16.10/lib64/libodbc.so
After:
/usr/lib64/libodbcinst.so -> libodbcinst.so.2.0.0
/usr/lib64/libodbc.so -> libodbc.so.2.0.0
Preventive measure:
Set the parameter ShareLibs=no in ttu_install.cfg file for the affected servers so that the symbolic links defined in the path /usr/lib64 are not modified.
Hi @SangaviS
Installing a new TTU (Teradata Tools and Utilities) means the Teradata environment variables will need to be updated. I have no way of knowing your current SAS configuration, but you may need to update !SASROOT/bin/sasenv_local or your personal environment variables. This doc may be of assistance.
This document can help you with configuring SAS on UNIX/Linux.
http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf
Best wishes,
Jeff
Thanks everyone for your valuable responses!
Apparently the issue was because the Teradata Client 16.10 upgrade modified the following symbolic links under /usr/lib64
Below is the summary that I documented for this
Issue: The below CLI error occurs while connecting to a database
ERROR: CLI error trying to establish connection: 523 586
ERROR: CLI error trying to establish connection: 523 80
Root Cause:
The Teradata client 16.10 upgrade modified the symbolic links under /usr/lib64 that were essential for any odbc connections
Resolution Steps:
Before:
/usr/lib64/libodbcinst.so -> /p01/app/ncr/teradata/client/16.10/lib64/libodbcinst.so
/usr/lib64/libodbc.so -> /p01/app/ncr/teradata/client/16.10/lib64/libodbc.so
After:
/usr/lib64/libodbcinst.so -> libodbcinst.so.2.0.0
/usr/lib64/libodbc.so -> libodbc.so.2.0.0
Preventive measure:
Set the parameter ShareLibs=no in ttu_install.cfg file for the affected servers so that the symbolic links defined in the path /usr/lib64 are not modified.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.