While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.

Database

While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.


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.


4 REPLIES
Fan

Re: While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.

Any update on how you resolved this error?

Enthusiast

Re: While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.

Hi all, 

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:-

DEFINE JOB EXPORT_TABLE_TO_FILE_AND_LOAD_TO_TABLE 

 DESCRIPTION 'EXPORT SAMPLE ITS TABLE TO A FILE' 

 (


DEFINE SCHEMA TEST_SCHEMA 

 DESCRIPTION 'SAMPLE TEST SCHEMA'

 ( 

 Col1 VARCHAR(10), 

 Col2 VARCHAR(10), 

 Col3 VARCHAR(100), 

Col4 VARCHAR(250) 

 );

DEFINE OPERATOR Export_Operator 

 TYPE EXPORT 

 SCHEMA TEST_SCHEMA 

 ATTRIBUTES 

 ( 

 VARCHAR UserName = @UserName, 

 VARCHAR UserPassword = @UserPassword, 

 VARCHAR TdpId = @TdpId, 

 VARCHAR SelectStmt 

 );

 

 DEFINE OPERATOR Stream_Operator

 DESCRIPTION 'STREAM OPERATOR FOR Teradata PT ' 

 TYPE STREAM 

 SCHEMA * 

 ATTRIBUTES ( 

 VARCHAR TdpId= @TdpId1, 

 VARCHAR UserName = @UserName1, 

 VARCHAR UserPassword=@UserPassword1, 

 VARCHAR PrivateLogName, 

 VARCHAR LogTable 

 );

STEP APPLY_UPSERT 

 ( 

  APPLY 

 'INSERT INTO DB.TARGET_TABLE(Col1,Col2,Col3,Col4) Values (:Col1,:Col2,:Col3,:Col4);' 

 TO OPERATOR ( STREAM_LOAD_OPERATOR [1] 

 ATTRIBUTES 

 (LogTable ='tables_log', PrivateLogName = 'StreamLog.log')) 

 SELECT Source_Id, Geo_Cd, Geo_Desc, City_Name FROM OPERATOR ( Export_Operator [1] 

 ATTRIBUTES 

 ( SelectStmt ='SELECT Col1,Col2,Col3,Col4 FROM  DB.Source_Table;' )); 

 );

);



ERROR:-

TPT_INFRA: TPT02192: Error: Cannot load shared library    

           dlopen error:        0509-022 Cannot load module .

        0509-026 System error: A file or directory in the path name does not exist.

TPT_INFRA: TPT02109: Cannot open shared library libstreamop.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

Job step APPLY_UPSERT terminated (status 8)

Job edwd terminated (status 8)

Please provide your inputs...

Thanks in advance...

Regards,

Sam

Enthusiast

Re: While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.

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?

Enthusiast

Re: While loading data from DB2 to Teradata through TPT script using ODBC operator getting error.

Hi Vasu,

Yes we are able to connect SQLA.

Regards,

Sam