All Forums Tools
gpolanch 46 posts Joined 12/11
26 Dec 2011
TPT13103: Error 5 retrieving DML Group Attribute

Hello,

Can someone provide some insight with this TPT error?  My script file is very similar to Example 15 from the TPT User Guide.  It copies a source table to a destination table within Teradata.  Follows is my tbuild output and tlogview output for the associated logfile, and script file.   The tbuild command displays this error, then shortly after that, I get a win32 exception.  I am also getting random win32 exceptions when using OLELoad (discussed in a separate post).  Thanks!

C:\Documents and Settings\gpolanchyck>tbuild -f C:\tpt_scripts\test_example_15_i
cd9s.txt
Teradata Parallel Transporter Version 13.10.00.04
Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel Transporter/lo
gs/gp-16.out
Job id is gp-16, running on C53155
Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel
Transporter/checkpoint\gpolanchyckLVCP
This is a restart job; it restarts at step LOAD_Trans_Table.
Teradata Parallel Transporter Export Operator Version 13.10.00.03
EXPORT_OPERATOR: private log specified: gp_export_log
Teradata Parallel Transporter Load Operator Version 13.10.00.03
LOAD_OPERATOR: private log specified: gp_load_log
EXPORT_OPERATOR: connecting sessions
LOAD_OPERATOR: TPT13103: Error 5 retrieving DML Group Attribute

>>>>>>>>>>>>>>>>>>>>>> GOT WIN32 EXCEPTION  <<<<<<<<<<<<<<<<<<<

LOAD_OPERATOR: Total processor time used = '0.09375 Second(s)'
LOAD_OPERATOR: Start : Mon Dec 26 13:47:32 2011
LOAD_OPERATOR: End   : Mon Dec 26 13:47:36 2011
Job step LOAD_Trans_Table terminated (status 12)
Job gpolanchyck terminated (status 12)

 

C:\Program Files\Teradata\Client\13.10\Teradata Parallel Transporter\logs>tlogvi
ew -l gp-16.out
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel
Transporter/checkpoint\gpLVCP
This is a restart job; it restarts at step LOAD_Trans_Table.
Teradata Parallel Transporter Coordinator Version 13.10.00.04
Teradata Parallel Transporter Executor Version 13.10.00.04
Teradata Parallel Transporter Executor Version 13.10.00.04
Teradata Parallel Transporter Export Operator Version 13.10.00.03
EXPORT_OPERATOR: private log specified: gp_export_log
Teradata Parallel Transporter Load Operator Version 13.10.00.03
LOAD_OPERATOR: private log specified: gp_load_log
EXPORT_OPERATOR: connecting sessions
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,
 Total Rows Sent = 0
LOAD_OPERATOR: TPT13103: Error 5 retrieving DML Group Attribute
LOAD_OPERATOR: Total processor time used = '0.09375 Second(s)'
LOAD_OPERATOR: Start : Mon Dec 26 13:47:32 2011
LOAD_OPERATOR: End   : Mon Dec 26 13:47:36 2011
Job step LOAD_Trans_Table terminated (status 12)
Job gp terminated (status 12)
Total available memory:          10000000
Largest allocable area:          10000000
Memory use high water mark:         81232
Free map size:                       1024
Free map use high water mark:          18
Free list use high water mark:          0

------------------------------------------------------ ---------------

/* Teradata Parallel Trans_ICD9Sporter */
/* User Guide - Job Example 15 */

DEFINE JOB EXTRACT_TABLE_LOAD_HEPC_ICD9
DESCRIPTION 'Export rows from a Teradata table to another Teradata table'
(
  DEFINE SCHEMA GP_HEPC_ICD9S
  DESCRIPTION 'SOURCE SCHEMA'
  (
  ICD9_CODE VARCHAR(10)
  );

DEFINE OPERATOR DDL_OPERATOR
TYPE DDL
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_ddl_log',
VARCHAR TdpId = 'xxxxxxx',
VARCHAR UserName = 'xxxxxxx',
VARCHAR UserPassword = 'xxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxx',
VARCHAR LogonMech = 'LDAP',
VARCHAR ErrorList = '3807'
);

DEFINE OPERATOR EXPORT_OPERATOR
TYPE EXPORT
SCHEMA GP_HEPC_ICD9S
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_export_log',
VARCHAR TdpId = 'xxxxxxx',
VARCHAR UserName = 'xxxxxxx',
VARCHAR UserPassword = 'xxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxx',
VARCHAR LogonMech = 'LDAP',
VARCHAR SelectStmt = 'SELECT * FROM GP_HEPC_ICD9S;'
);

DEFINE OPERATOR LOAD_OPERATOR
TYPE LOAD
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_load_log',
VARCHAR TdpId = 'xxxxxxx',
VARCHAR UserName = 'xxxxxxx',
VARCHAR UserPassword = 'xxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxx',
VARCHAR LogonMech = 'LDAP',

VARCHAR TargetTable = 'xxxxxxx' || '.Trans',
VARCHAR LogTable = 'xxxxxxx'  || '.LG_Trans',

VARCHAR ErrorTable1 = 'xxxxxxx'  || '.ET_Trans',
VARCHAR ErrorTable2 = 'xxxxxxx'  || '.UV_Trans'
);

STEP Setup_Tables
(
APPLY
('CREATE TABLE ' || 'xxxxxxx'
|| '.Trans (
    ICD9_CODE VARCHAR(10));'
)
TO OPERATOR (DDL_OPERATOR);
);

STEP LOAD_Trans_Table
(
APPLY TO OPERATOR (LOAD_OPERATOR)
SELECT * FROM OPERATOR (EXPORT_OPERATOR);
);

);

 

feinholz 1234 posts Joined 05/08
26 Dec 2011

Your APPLY statement does not have a DML group.

You need an INSERT statement for the Load operator.

It should be:

 

APPLY

(

   'INSERT INTO . . . . ;'

)

TO OPERATOR (LOAD_OPERATOR)

SELECT * FROM OPERATOR (EXPORT_OPERATOR);

 

--SteveF

gpolanch 46 posts Joined 12/11
26 Dec 2011

Thanks much!  Looks like the INSERT was not in the User Guide for Example 15.   I'm getting farther now, the table "Trans" is created, though it is empty, and when select from it, it gives the error "Trans is being loaded."  Wonder if you can take another look?  Below is my console output, log, and script.  Thanks!

C:\Documents and Settings\gpolanchyck>tbuild -f C:\tpt_scripts\test_example_15_i
cd9s.txt
Teradata Parallel Transporter Version 13.10.00.04
Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel Transporter/lo
gs/gpolanchyck-21.out
Job id is gpolanchyck-21, running on C53155
Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel
Transporter/checkpoint\gpolanchyckLVCP
This is a restart job; it restarts at step LOAD_Trans_Table.
Teradata Parallel Transporter Load Operator Version 13.10.00.03
Teradata Parallel Transporter Export Operator Version 13.10.00.03
LOAD_OPERATOR: private log specified: gp_load_log
EXPORT_OPERATOR: private log specified: gp_export_log
LOAD_OPERATOR: connecting sessions
EXPORT_OPERATOR: connecting sessions

>>>>> GOT unhandled win32 exception

LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase

>>>>> GOT second win32 exception

LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.71875 Second(s)'
LOAD_OPERATOR: Start : Mon Dec 26 22:45:31 2011
LOAD_OPERATOR: End   : Mon Dec 26 22:48:38 2011
Job step LOAD_Trans_Table terminated (status 8)
Job gpolanchyck terminated (status 8)

-----------------------------------------------

C:\Program Files\Teradata\Client\13.10\Teradata Parallel Transporter\logs>tlogview -l gpolanchyck-21.out
TPT_INFRA: TPT04101: Warning: TMSM failed to initialize
Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel
Transporter/checkpoint\gpolanchyckLVCP
This is a restart job; it restarts at step LOAD_Trans_Table.
Teradata Parallel Transporter Coordinator Version 13.10.00.04
Teradata Parallel Transporter Executor Version 13.10.00.04
Teradata Parallel Transporter Executor Version 13.10.00.04
Teradata Parallel Transporter Load Operator Version 13.10.00.03
Teradata Parallel Transporter Export Operator Version 13.10.00.03
LOAD_OPERATOR: private log specified: gp_load_log
EXPORT_OPERATOR: private log specified: gp_export_log
LOAD_OPERATOR: connecting sessions
EXPORT_OPERATOR: connecting sessions
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0,
 Total Rows Sent = 0
LOAD_OPERATOR: disconnecting sessions
LOAD_OPERATOR: Total processor time used = '0.71875 Second(s)'
LOAD_OPERATOR: Start : Mon Dec 26 22:45:31 2011
LOAD_OPERATOR: End   : Mon Dec 26 22:48:38 2011
Job step LOAD_Trans_Table terminated (status 8)
Job gpolanchyck terminated (status 8)
Total available memory:          10000000
Largest allocable area:          10000000
Memory use high water mark:         81144
Free map size:                       1024
Free map use high water mark:          16
Free list use high water mark:          0

----------------------------------------------

/* Teradata Parallel Trans_ICD9Sporter */
/* User Guide - Job Example 15 */

DEFINE JOB EXTRACT_TABLE_LOAD_HEPC_ICD9
DESCRIPTION 'Export rows from a Teradata table to another Teradata table'
(
  DEFINE SCHEMA GP_HEPC_ICD9S
  DESCRIPTION 'SOURCE SCHEMA'
  (
  ICD9_CODE VARCHAR(10)
  );

DEFINE OPERATOR DDL_OPERATOR
TYPE DDL
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_ddl_log',
VARCHAR TdpId = 'xxxxxxxx',
VARCHAR UserName = 'xxxxxxxx',
VARCHAR UserPassword = 'xxxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxxx',
VARCHAR LogonMech = 'LDAP',
VARCHAR ErrorList = '3807'
);

DEFINE OPERATOR EXPORT_OPERATOR
TYPE EXPORT
SCHEMA GP_HEPC_ICD9S
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_export_log',
VARCHAR TdpId = 'xxxxxxxx',
VARCHAR UserName = 'xxxxxxxx',
VARCHAR UserPassword = 'xxxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxxx',
VARCHAR LogonMech = 'LDAP',
VARCHAR SelectStmt = 'SELECT * FROM GP_HEPC_ICD9S;'
);

DEFINE OPERATOR LOAD_OPERATOR
TYPE LOAD
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'gp_load_log',
VARCHAR TdpId = 'xxxxxxxx',
VARCHAR UserName = 'xxxxxxxx',
VARCHAR UserPassword = 'xxxxxxxx',
VARCHAR WorkingDatabase = 'xxxxxxxx',
VARCHAR LogonMech = 'LDAP',

VARCHAR TargetTable = 'xxxxxxxx' || '.Trans',
VARCHAR LogTable = 'xxxxxxxx'  || '.LG_Trans',

VARCHAR ErrorTable1 = 'xxxxxxxx'  || '.ET_Trans',
VARCHAR ErrorTable2 = 'xxxxxxxx'  || '.UV_Trans'
);

STEP Setup_Tables
(
APPLY
('CREATE TABLE ' || 'xxxxxxxx'
|| '.Trans (
    ICD9_CODE VARCHAR(10));'
)
TO OPERATOR (DDL_OPERATOR);
);

STEP LOAD_Trans_Table
(
APPLY
('INSERT INTO ' || 'xxxxxxxx' || '.Trans(ICD9_CODE)
VALUES(:ICD9_CODE);')
TO OPERATOR (LOAD_OPERATOR)
SELECT * FROM OPERATOR (EXPORT_OPERATOR);
);

);

 

 

 

 

 

feinholz 1234 posts Joined 05/08
05 Jan 2012

If you get a message that "<table-name> is being loaded" it means you started a job and it somehow terminated in an unknown state. It usually means that there are sessions still connected somewhere and so the table is locked.

If you tried to restart the job right after a possible coredump or abnormal termination, then those sessions could hang around for about 20 minutes.

 

--SteveF

You must sign in to leave a comment.