Error while loading data from Oracle table to teradata table

Teradata Applications
Enthusiast

Error while loading data from Oracle table to teradata table

Hi Experts,

I am trying to run a TPT script which aims to load data from oracle table to teradata table.On Executing the script am getting the following error:

gilderoy:/ngs/app/slsaudedwt >tbuild -f ora_tera.ctl -v para_var.sql

Teradata Parallel Transporter Version 13.10.00.12

Job log: /opt/teradata/client/13.10/tbuild/logs/slsaudt-28962.out

Job id is slsaudt-28962, running on gilderoy

Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/slsaudtLVCP

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

Job step MAIN_STEP terminated (status 8)

Job slsaudt terminated (status 8)

My TPT Script:

DEFINE JOB ora_tera

DESCRIPTION 'Loading data from oracle environment to teradata'

(

            DEFINE SCHEMA Oracle_DataSource_Schema

            DESCRIPTION 'Schema of Oracle Data Source'

            (

                        Emp_Id                 VARCHAR(10),

                        Emp_frst_Name          VARCHAR(50),

                        Emp_Last_Name          VARCHAR(50),

                        Emp_Age                INTEGER,

                        Emp_Salary             DECIMAL(18,3)

             );

            DEFINE OPERATOR ODBC_Operator

DESCRIPTION 'TPT ODBC Operator'

TYPE ODBC

SCHEMA Oracle_DataSource_Schema

            ATTRIBUTES

            (

                        VARCHAR  PrivateLogName      = @ODBCPrivateLogName,

                        VARCHAR  DSNName             = @DSNName,

                        VARCHAR  UserName            = @ODBCUserName,

                        VARCHAR  UserPassword        = @ODBCPassword,

                        VARCHAR  SelectStmt          = @SelectStmt

            );

 DEFINE OPERATOR LOAD_OPERATOR

    DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'

    TYPE LOAD

    SCHEMA *

    ATTRIBUTES

    (

       VARCHAR PrivateLogName    = @LoadPrivateLogName,

       VARCHAR TargetTable       = @TargetTable,

       VARCHAR TdpId             = @TargetTdpId,

       VARCHAR UserName          = @TargetUserName,

       VARCHAR UserPassword      = @TargetUserPassword,

       VARCHAR ErrorTable1       = @ErrorTable1,

       VARCHAR ErrorTable2       = @ErrorTable2,

       VARCHAR LogTable          = @LogTable

    );

            APPLY

                ( 'INSERT INTO ' || @TargetTable || '

                                 (

                                 :Emp_id,

                                 :Emp_frst_Name,

                                 :Emp_Last_Name,

                                 :Emp_Age,

                                 :Emp_Salary

                                 );')

           TO OPERATOR (  $LOAD [@LoadInstances] )

           SELECT * FROM OPERATOR (  ODBC_Operator [@ODBCInstances]);

        );             

);

My TBuild Library details:

 >ls  -l /opt/teradata/client/13.10/tbuild/lib

total 18744

-r--r--r--    1 root     system       963207 Nov 16 2012  libdataconop.so

-r--r--r--    1 root     system        52495 Nov 16 2012  libddlop.so

-r--r--r--    1 root     system       145692 Jul 11 2012  libexportop.so

-r--r--r--    1 root     system       612006 Nov 16 2012  libfeomop.so

-r--r--r--    1 root     system       608506 Nov 16 2012  libflimop.so

-r--r--r--    1 root     system       111938 Nov 16 2012  libinsertop.so

-r--r--r--    1 root     system       124897 Mar 01 2011  libloadop.so

-r--r--r--    1 root     system        66415 Nov 16 2012  liblogview.so

-r--r--r--    1 root     system       617062 Nov 16 2012  libmlimop.so

-r--r--r--    1 root     system       237610 Nov 16 2012  libodbcop.so

-r--r--r--    1 root     system       567705 Nov 16 2012  libopcommon.so

-r--r--r--    1 root     system        13048 Nov 16 2012  liboscmdop.so

-r--r--r--    1 root     system       175324 Nov 16 2012  libptmin.so

-r--r--r--    1 root     system        38972 Nov 16 2012  libptmos.so

-r--r--r--    1 root     system       206895 Nov 16 2012  libptmpi.so

-r--r--r--    1 root     system        87969 Nov 16 2012  libptmpo.so

-r--r--r--    1 root     system      2893172 Nov 16 2012  libpxcommon.so

-r--r--r--    1 root     system       207750 Nov 16 2012  libpxextrct.so

-r--r--r--    1 root     system        15128 Nov 16 2012  libpxicu.so

-r--r--r--    1 root     system       126221 Nov 16 2012  libselectop.so

-r--r--r--    1 root     system       349594 Apr 30 2012  libstreamop.so

-r--r--r--    1 root     system        84054 Nov 16 2012  libtableqry.so

-r--r--r--    1 root     system      1120659 Jan 28 2011  libtelapi.so

-r--r--r--    1 root     system       125710 Feb 24 2011  libupdateop.so

Please reply...

2 REPLIES
Enthusiast

Re: Error while loading data from Oracle table to teradata table

Error while loading data from Oracle table to teradata table

Hi Experts,

I am trying to run a TPT script which aims to load data from oracle table to teradata table.On Executing the script am getting the following error:

gilderoy:/ngs/app/slsaudedwt >tbuild -f ora_tera.ctl -v para_var.sql

Teradata Parallel Transporter Version 13.10.00.12

Job log: /opt/teradata/client/13.10/tbuild/logs/slsaudt- 28962.out

Job id is slsaudt-28962, running on gilderoy

Found CheckPoint file: /opt/teradata/client/13.10/tbuild/checkpoint/ slsaudtLVCP

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

Job step MAIN_STEP terminated (status 8)

Job slsaudt terminated (status 8)

My TPT Script:

DEFINE JOB ora_tera

DESCRIPTION 'Loading data from oracle environment to teradata'

(

            DEFINE SCHEMA Oracle_DataSource_Schema

            DESCRIPTION 'Schema of Oracle Data Source'

            (

                        Emp_Id                 VARCHAR(10),

                        Emp_frst_Name          VARCHAR(50),

                        Emp_Last_Name          VARCHAR(50),

                        Emp_Age                INTEGER,

                        Emp_Salary             DECIMAL(18,3)

             );

            DEFINE OPERATOR ODBC_Operator

DESCRIPTION 'TPT ODBC Operator'

TYPE ODBC

SCHEMA Oracle_DataSource_Schema

            ATTRIBUTES

            (

                        VARCHAR  PrivateLogName      = @ODBCPrivateLogName,

                        VARCHAR  DSNName             = @DSNName,

                        VARCHAR  UserName            = @ODBCUserName,

                        VARCHAR  UserPassword        = @ODBCPassword,

                        VARCHAR  SelectStmt          = @SelectStmt

            );

 DEFINE OPERATOR LOAD_OPERATOR

    DESCRIPTION 'TERADATA PARALLEL TRANSPORTER LOAD OPERATOR'

    TYPE LOAD

    SCHEMA *

    ATTRIBUTES

    (

       VARCHAR PrivateLogName    = @LoadPrivateLogName,

       VARCHAR TargetTable       = @TargetTable,

       VARCHAR TdpId             = @TargetTdpId,

       VARCHAR UserName          = @TargetUserName,

       VARCHAR UserPassword      = @TargetUserPassword,

       VARCHAR ErrorTable1       = @ErrorTable1,

       VARCHAR ErrorTable2       = @ErrorTable2,

       VARCHAR LogTable          = @LogTable

    );

            APPLY

                ( 'INSERT INTO ' || @TargetTable || '

                                 (

                                 :Emp_id,

                                 :Emp_frst_Name,

                                 :Emp_Last_Name,

                                 :Emp_Age,

                                 :Emp_Salary

                                 );')

           TO OPERATOR (  $LOAD [@LoadInstances] )

           SELECT * FROM OPERATOR (  ODBC_Operator [@ODBCInstances]);

        );             

);

My TBuild Library details:

 >ls  -l /opt/teradata/client/13.10/tbuild/lib

total 18744

-r--r--r--    1 root     system       963207 Nov 16 2012  libdataconop.so

-r--r--r--    1 root     system        52495 Nov 16 2012  libddlop.so

-r--r--r--    1 root     system       145692 Jul 11 2012  libexportop.so

-r--r--r--    1 root     system       612006 Nov 16 2012  libfeomop.so

-r--r--r--    1 root     system       608506 Nov 16 2012  libflimop.so

-r--r--r--    1 root     system       111938 Nov 16 2012  libinsertop.so

-r--r--r--    1 root     system       124897 Mar 01 2011  libloadop.so

-r--r--r--    1 root     system        66415 Nov 16 2012  liblogview.so

-r--r--r--    1 root     system       617062 Nov 16 2012  libmlimop.so

-r--r--r--    1 root     system       237610 Nov 16 2012  libodbcop.so

-r--r--r--    1 root     system       567705 Nov 16 2012  libopcommon.so

-r--r--r--    1 root     system        13048 Nov 16 2012  liboscmdop.so

-r--r--r--    1 root     system       175324 Nov 16 2012  libptmin.so

-r--r--r--    1 root     system        38972 Nov 16 2012  libptmos.so

-r--r--r--    1 root     system       206895 Nov 16 2012  libptmpi.so

-r--r--r--    1 root     system        87969 Nov 16 2012  libptmpo.so

-r--r--r--    1 root     system      2893172 Nov 16 2012  libpxcommon.so

-r--r--r--    1 root     system       207750 Nov 16 2012  libpxextrct.so

-r--r--r--    1 root     system        15128 Nov 16 2012  libpxicu.so

-r--r--r--    1 root     system       126221 Nov 16 2012  libselectop.so

-r--r--r--    1 root     system       349594 Apr 30 2012  libstreamop.so

-r--r--r--    1 root     system        84054 Nov 16 2012  libtableqry.so

-r--r--r--    1 root     system      1120659 Jan 28 2011  libtelapi.so

-r--r--r--    1 root     system       125710 Feb 24 2011  libupdateop.so

Please reply...

Enthusiast

Re: Error while loading data from Oracle table to teradata table

Hi Atul,

I am also facing same issue as below when i try to extract data from oracle into files.

Teradata Parallel Transporter Version 14.00.00.10

Job log: /opt/teradata/client/14.00/tbuild/logs/whupbit-95.out

Job id is whupbit-95, running on tide1a08

Found CheckPoint file: /opt/teradata/client/14.00/tbuild/checkpoint/whupbitLVCP

This is a restart job; it restarts at step export_to_file.

TPT_INFRA: TPT02192: Error: Cannot load shared library

           dlopen error: Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module libodbc.a(odbc.so) could not be loaded.

Could not load module libodbc.a(odbc.so).

System error: No such file or directory

Could not load module /opt/teradata/client/14.00/tbuild/lib/libodbcop.so.

        Dependent module /opt/teradata/client/14.00/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

Job step export_to_file terminated (status 8)

Job whupbit terminated (status 8)

please can you tell me the reason for this ?