Troubleshooting
Problem
When running a job that uses Teradata connector access method as Bulk, the following error occurs: Teradata_Connector_47,0: RDBMS code 293: PXOPL_Open: dlopen error: 0509-022 Cannot load module . 0509-026 System error: A file or directory in the path name does not exist.
Resolving The Problem
To resolve this error:
- Add the following Teradata environment variables into the dsenv file located under /DSEngine directory
> TWB_ROOT=/opt/teradata/client/13.10/tbuild;export TWB_ROOT
> NLSPATH=$TWB_ROOT/msg/%N; export NLSPATH
> TD_ICU_DATA=/opt/teradata/client/13.10/tdicu/lib64;export TD_ICU_DATA
> LIBPATH=$TWB_ROOT/lib64:$TD_ICU_DATA:/opt/teradata/client/13.10/lib64:$L IBPATH; export
LIBPATH
Note: LIBPATH is for AIX. Other platforms like Linux, HP-UX, and Solaris, use LD_LIBRARY_PATH instead.
Please be aware that Teradata might be installed in a different location. Please update the path accordingly. - Stop and restart the DataStage engine and ASB Node agent (this has to be done in order for the changes made to dsenv file to take effect)
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1.2.0;9.1;8.7;8.5;8.1;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21679630