User receives error messages testing Teradata adapter: FOC1261 PHYSICAL INTERFACE NOT FOUND


Diagnostics

Product: Reporting Server
Release: 8206
Primary OS: Linux
Solution Date:

Symptom

(FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLDBC. MODULE NAME : ODBPD16 

(FOC1262) NATIVE ERROR MESSAGE(S) : 

(FOC1260) /ibi/srv82/home/bin/libodbpd16.so: cannot open shared object file: No such file or directory

(FOC1263) THE CURRENT ENVIRONMENT VARIABLES FOR SUFFIX SQLDBC ARE :

(FOC1260) ODBCINI : /usr/lib64/teradata/teradata/client/ODBC_64

(FOC1260) FASTLOAD_EXE : NOT SET

(FOC1260) MLOAD_EXE : NOT SET

(FOC1260) LD_LIBRARY_PATH : /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/jre/lib/amd64/server

(FOC1260)   /usr/lib/oracle/18.5/client64/lib

(FOC1260)   /ibi/srv82/home/bin

(FOC1260)   /ibi/srv82/wfs/share

(FOC1260)   /ibi/srv82/wfs/lib

(FOC1260)   /ibi/srv82/wfs/bin

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) 

(FOC1488) SQL INTERFACE HAS NOT BEEN INSTALLED OR COULD NOT BE INITIALIZED

(FOC1479) ERROR CONNECTING TO SQL DATABASE 



Test for SQLDBC failed due to data access error (RETCODE=      -1)

Problem

The user receives the error messages above while testing the Teradata adapter.

Solution

A review of the message shows the LD_LIBRARY_PATH environment variable does not specify the location of the Teradata driver files. Adding the location to the LD_LIBRARY_PATH resolved the issue.