Thursday, 12 June 2014

General Issues user may face while configuring Teradata Connector in IBM InformationServer & Resolutions



Issue # 1:
Teradata_Connector_1: Error loading connector library libcctera12.so. libtelapi.so: wrong ELF class: ELFCLASS32 (CC_LoadedConnector::loadLibrary, file CC_ConnectorFactory.cpp, line 1,525)

Probable Reason :

Normally this issue may arise due to Configuration issues/ improper Library files.

Resolution:

If Teradata client version 13.10 is being used on RH Linux64 bit server, then We should have below path
/opt/teradata/client/13.10/tbuild/lib64 also included in LD_LIBRARY_PATH


In case of 32-bit server, please assign this path /opt/teradata/client/13.10/tbuild/lib to LD_LIBRARY_PATH
 


Issue # 2:

Teradata_Connector_3,0: RDBMS code 21012: Could Not Find Message Catalog opermsgs.cat  SQL statement: INSERT INTO TDCC_TMSM_BLK(c1,c2) VALUES(:c1,:c2) (CC_TeraParallelTransporter::initiate, file CC_TeraParallelTransporter.cpp, line 1297)

Probable Reason:
This issue / error will appear in DS director when   environment variable LANG  &  NLSPATH  is not set.

Resolution:  
Please set  environment variables
       LANG=en_US
       NLSPATH=/opt/teradata/client/13.10/tbuild/msg/%N



Issue # 3:

The file "errmsg.cat" cannot be opened.

Add below env variables to resolve issue.

    COPLIB=/opt/teradata/client/13.10/lib64
    COPERR=/opt/teradata/client/13.10/lib64


Disclaimer: “The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.”