Hi,
I am getting some strange error while try to connect Teradata Connector stage, when i give the connection details and hit the test connection it gives me this message.
An exception occurred while trying to receive the response from the handler: An exception was received from the handler: error loading connector library libcctera.so 0509-022 connot load module
/ds8_ade/inforationServer......./libcctera.so
0509-150 Dependent Module libtelapi.so could not be loaded
0509-022 cannot load module libtelapi.so
0509-026 System error: A file or directory in the path name does not exist
0509-022 connot load module /ds8_ade/informationServer...../libcctera.so.
0509-150 Dependent module ....libcctera.so could not be loaded[/img]
Teradata Connector Stage Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Have you got the right Teradata client software installed? From memory there were several Teradata packages to install to get this working.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
Teradata Connector requires the Parallel Transporter
You need to install the Teradata Parallel Transporter which can be found on the Load-Unload vol. 2 CD.
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
No, libtelapi.so is the TPT API library. That library cannot be found either because you have not installed the TPT or its location is not in the LIBPATH/SHLIB_PATH/LD_LIBRARY_PATH. After installing the TPT, it will have placed environment variables such as TWBROOT and NLSPATH in /etc/profile and it will have modified the LIBPATH/SHLIB_PATH/LD_LIBRARY_PATH. Copy those environment variables into the dsenv, stop the ASBAgent and DataStage server, source the new dsenv, and restart the DataStage server and ASBAgent.
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am