TPT13103: Error 5 retrieving DML Group Attribute

Tools & Utilities
Enthusiast

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);

);

);

3 REPLIES
Teradata Employee

Re: TPT13103: Error 5 retrieving DML Group Attribute

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
Enthusiast

Re: TPT13103: Error 5 retrieving DML Group Attribute

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);

);

);

Teradata Employee

Re: TPT13103: Error 5 retrieving DML Group Attribute

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