Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Tools & Utilities
Enthusiast

Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Hi, TPT GURU,

I am getting the above error while running tbuild. could you please help?

DEFINE JOB MINI_BATCH

DESCRIPTION 'Mini-Batch Loading'

(

        DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA

        (

                Associate_Id VARCHAR(10),

                Associate_Name VARCHAR(25)

        );

        DEFINE OPERATOR DDL_OPERATOR

        TYPE DDL

        ATTRIBUTES

        (

                VARCHAR TdpId = @MyDstTdpId,

                VARCHAR UserName = @MyDstUserName,

                VARCHAR UserPassword = @MyDstUserPassword,

                VARCHAR WorkingDatabase = @MyDstUserDatabase,

                VARCHAR ARRAY ErrorList = ['3807','3803','5980']

        );

        DEFINE OPERATOR FILE_READER

        TYPE DATACONNECTOR PRODUCER

        SCHEMA PRODUCT_SOURCE_SCHEMA

        ATTRIBUTES

        (

                VARCHAR DirectoryPath = '/root/my/testme/',

                VARCHAR FileName = 'accounts.txt',

                VARCHAR FORMAT = 'Delimited',

                VARCHAR OpenMode = 'Read',

                VARCHAR TextDelimiter = '|'

        );

        DEFINE OPERATOR LOAD_OPERATOR

        TYPE LOAD

        SCHEMA *

        ATTRIBUTES

        (

                VARCHAR TdpId = @MyDstTdpId,

                VARCHAR UserName = @MyDstUserName,

                VARCHAR UserPassword = @MyDstUserPassword,

                VARCHAR WorkingDatabase = @MyDstUserDatabase

        );

        STEP STEP1

        (

                APPLY

                ('DROP TABLE stg_from_file;'),

                (

                        'CREATE TABLE stg_from_file (

                                Associate_Id integer,

                                Associate_Name char(25)

                        );'

                )

                TO OPERATOR (DDL_OPERATOR);

        );

        STEP STEP2

        (

                APPLY (

                        'INS INTO qli.stg_from_file (

                                :Associate_Id,

                                :Associate_Name

                        );'

                )

                TO OPERATOR (LOAD_OPERATOR[2])

                SELECT * FROM OPERATOR (FILE_READER[2]);

        );

);

 tbuild -f testme.tpt -v testme.var

Teradata Parallel Transporter Version 13.10.00.03

Job log: /opt/teradata/client/13.10/tbuild/logs/root-30.out

Job id is root-30, running on tdexp

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.03

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

Job step STEP1 completed successfully

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.03 Second(s)'

DDL_OPERATOR: Start : Thu Nov  1 10:46:49 2012

DDL_OPERATOR: End   : Thu Nov  1 10:46:49 2012

Teradata Parallel Transporter DataConnector Version 13.10.00.03

Teradata Parallel Transporter Load Operator Version 13.10.00.03

LOAD_OPERATOR: private log not specified

FILE_READER: TPT19008 DataConnector Producer operator Instances: 2

FILE_READER: TPT19003 ECI operator ID: FILE_READER-5436

FILE_READER: TPT19222 Operator instance 1 processing file '/root/my/testme/accounts.txt'.

LOAD_OPERATOR: TPT10306: Error 5 retrieving attribute 'LogTable'

Job step STEP2 terminated (status 12)

Job root terminated (status 12)

LOAD_OPERATOR: Total processor time used = '0.01 Second(s)'

LOAD_OPERATOR: Start : Thu Nov  1 10:46:56 2012

LOAD_OPERATOR: End   : Thu Nov  1 10:46:56 2012

FILE_READER: TPT19221 Total files processed: 0.

Thanks,

Jim

6 REPLIES
Teradata Employee

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

If you would consult the TPT manuals regarding the Load operator, you would notice that the LogTable attribute is a mandatory attribute. You did not supply a table name for the log table.

-- SteveF
Enthusiast

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Hi, Feinholz,

Thanks a lot, I have one more question. I am running my tpt script and get the following error.

 tbuild -f job1A.tpt -v myDesktop.var 

Teradata Parallel Transporter Version 13.10.00.09

Job log: /opt/teradata/client/13.10/tbuild/logs/appworx-300.out

Job id is appworx-300, running on XXXX.com

Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.09

DDL_OPERATOR: private log specified: ddl_log

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'XXX.ET_Trans' does not exist.

DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.03 Second(s)'

DDL_OPERATOR: Start : Wed Nov 21 15:53:41 2012

DDL_OPERATOR: End   : Wed Nov 21 15:53:42 2012

Job step Setup_Tables completed successfully

Teradata Parallel Transporter DataConnector Version 13.10.00.09

FILE_READER Instance 1 directing private log report to 'dataconnector_log-1'.

FILE_READER Instance 2 directing private log report to 'dataconnector_log-2'.

FILE_READER: TPT19008 DataConnector Producer operator Instances: 2

FILE_READER: TPT19003 ECI operator ID: FILE_READER-2474

FILE_READER: TPT19434 pmOpen failed. General failure (34): 'pmUnxDskOpen: 'open' error (Permission denied)'

FILE_READER: TPT19304 Fatal error opening file.

TPT_INFRA: TPT02192: Error: Cannot load shared library    

           dlopen error: libloadop.so: wrong ELF class: ELFCLASS64

TPT_INFRA: TPT02192: Error: Cannot load shared library    

           dlopen error: libloadop.so: wrong ELF class: ELFCLASS64

TPT_INFRA: TPT02109: Cannot open shared library libloadop.so, status = Open Error

TPT_INFRA: TPT02109: Cannot open shared library libloadop.so, status = Open Error

TPT_INFRA: TPT02240: Error: Cannot create operator object, status = Operator Error

TPT_INFRA: TPT02240: Error: Cannot create operator object, status = Operator Error

TPT_INFRA: TPT02103: Executor unable to set up its table object

TPT_INFRA: TPT02103: Executor unable to set up its table object

FILE_READER: TPT19221 Total files processed: 0.

Job step Load_Trans_Table terminated (status 12)

Job appworx terminated (status 12)

I think the issue was due to 64-bit or 32 bit component was used but not sure how to resolve it.

Any suggestions?

Regards,

Jim

Teradata Employee

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Looks like someone may have copied library files around, or you are pointing to the wrong directories.

Script-based TPT is a 32-bit application.

However, we also provide 64-bit versions of some of the operators for TPTAPI. Looks like someone may have copied the 64-bit operator files into the 32-bit directory.

Best thing might be to re-install TPT.

-- SteveF
Enthusiast

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Hi, Feinholz,

Thank you.

Here is my setting. I was wondering if you could spot something that is terrible wrong?

( We do use TPT API as well as TPT utility )

echo $TWB_ROOT

/opt/teradata/client/13.10/tbuild

echo $PATH

/opt/teradata/client/13.10/tbuild/bin

echo $LD_LIBRARY_PATH

/opt/teradata/client/13.10/tbuild/lib

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

total 3268

-r-xr-xr-x 1 root root 579083 Oct 12  2010 libdataconop.so*

-r-xr-xr-x 1 root root  30904 Oct 12  2010 libddlop.so*

-r-xr-xr-x 1 root root 339918 Oct 12  2010 libfeomop.so*

-r-xr-xr-x 1 root root 333827 Oct 12  2010 libflimop.so*

-r-xr-xr-x 1 root root  63495 Oct 12  2010 libinsertop.so*

-r-xr-xr-x 1 root root  38193 Oct 12  2010 liblogview.so*

-r-xr-xr-x 1 root root 342591 Oct 12  2010 libmlimop.so*

-r-xr-xr-x 1 root root 141906 Oct 12  2010 libodbcop.so*

-r-xr-xr-x 1 root root 342866 Oct 12  2010 libopcommon.so*

-r-xr-xr-x 1 root root   8991 Oct 12  2010 liboscmdop.so*

-r-xr-xr-x 1 root root  95898 Oct 12  2010 libptmin.so*

-r-xr-xr-x 1 root root  22365 Oct 12  2010 libptmos.so*

-r-xr-xr-x 1 root root 107768 Oct 12  2010 libptmpi.so*

-r-xr-xr-x 1 root root  39482 Oct 12  2010 libptmpo.so*

-r-xr-xr-x 1 root root 638247 Oct 12  2010 libpxcommon.so*

-r-xr-xr-x 1 root root   8440 Oct 12  2010 libpxicu.so*

-r-xr-xr-x 1 root root  74215 Oct 12  2010 libselectop.so*

-r-xr-xr-x 1 root root  51624 Oct 12  2010 libtableqry.so*

Thanks,

Jim

Enthusiast

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

Hi, Feinholz,

I only see libloadop.so under lib64, not under lib. Does that mean I only have TPTAPI component installed but not the one for TPT script? If so, does that mean I need to install libloadop.so for TPT script?

find /opt/teradata/client/13.10/tbuild -name "libloadop.so"

/opt/teradata/client/13.10/tbuild/lib64/libloadop.so

Thanks,

Jim

Teradata Employee

Re: Why I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?

I do not know why you do not have libloadop.so in your "lib" directory. You may want to try to re-install the product.

-- SteveF