While loading data from DB2 to Teradata through TPT script using ODBC operator i am getting following error.
Teradata Parallel Transporter Version 13.10.00.02
Job log: /opt/teradata/client/13.10/tbuild/logs/a039217-17.out
Job id is a039217-17, running on dseax0011
Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/a039217LVCP
This is a restart job; it restarts at step MAIN_STEP.
TPT_INFRA: TPT02192: Error: Cannot load shared library
dlopen error: 0509-022 Cannot load module /opt/teradata/client/13.10/tbuild/lib/libodbcop.so.
0509-150 Dependent module libodbc.a(odbc.so) could not be loaded.
0509-022 Cannot load module libodbc.a(odbc.so).
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /opt/teradata/client/13.10/tbuild/lib/libodbcop.so.
0509-150 Dependent module /opt/teradata/client/13.10/tbuild/lib/libodbcop.so could not be loaded.
TPT_INFRA: TPT02109: Cannot open shared library libodbcop.so, status = Open Error
TPT_INFRA: TPT02240: Error: Cannot create operator object, status = Operator Error
TPT_INFRA: TPT02103: Executor unable to set up its table object
Teradata Parallel Transporter SQL Inserter Operator Version 13.10.00.02
SQL_INSERT: private log specified: target_privatelog
SQL_INSERT: connecting sessions
SQL_INSERT: TPT10507: CLI Error 244: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway.
SQL_INSERT: Total Rows Sent To RDBMS: 0
SQL_INSERT: Total Rows Applied: 0
SQL_INSERT: Total processor time used = '0.022761 Second(s)'
SQL_INSERT: Start : Tue Nov 29 23:52:02 2011
SQL_INSERT: End : Tue Nov 29 23:52:02 2011
Job step MAIN_STEP terminated (status 8)
Job a039217 terminated (status 8)
Please help me.
I am also facing the same issue....
I am trying to extract from a table & then load that to a given table.
Hereby is the script:-
TPT errors are so convulated and at times throws off. For me it seems like there is some installation issues. Can SQLA or TD Administrator be connected from this server?