All Forums Tools
wallace 7 posts Joined 07/11
01 Nov 2012
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

poppan.com , it is all about data warehouse.

 

feinholz 1234 posts Joined 05/08
06 Nov 2012

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

wallace 7 posts Joined 07/11
21 Nov 2012

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

poppan.com , it is all about data warehouse.
 

feinholz 1234 posts Joined 05/08
21 Nov 2012

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

wallace 7 posts Joined 07/11
26 Nov 2012

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

poppan.com , it is all about data warehouse.
 

wallace 7 posts Joined 07/11
26 Nov 2012

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

poppan.com , it is all about data warehouse.
 

feinholz 1234 posts Joined 05/08
26 Nov 2012

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

You must sign in to leave a comment.