TPT Operator Template error "Output Schema does not match data from SELECT statement"

Tools
Enthusiast

TPT Operator Template error "Output Schema does not match data from SELECT statement"

Hello !!

I am getting "TPT12108: Output Schema does not match data from SELECT statement" error when I am using a TPT script (operator templates) to copy a Table from TDSERVER-A to TDSERVER-B, . This script usually runs fine. I am observing error this time bcause the table has TIMESTAMP(3). Can someone take a look at the script/error and tell me if I should make adjustments or there are limitations with operator templates in 13.10 ? 

TPT Version:

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

Teradata Parallel Transporter Executor Version 13.10.00.10

Teradata Parallel Transporter Coordinator Version 13.10.00.10

Teradata Parallel Transporter Executor Version 13.10.00.10

Teradata Parallel Transporter Load Operator Version 13.10.00.04

Teradata Parallel Transporter Export Operator Version 13.10.00.06

DDL of Table being copied:

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

CREATE MULTISET TABLE SANDBOX.TEST_TABLEA ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      PKey VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      BusinessModifiedTS TIMESTAMP(3) FORMAT 'YYYY-MM-DDbHH:MI:SS.S(3)',

      BusinessModifiedDT DATE FORMAT 'YYYY-MM-DD'

      )

PRIMARY INDEX ( PKey );

TPT Script:

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

DEFINE JOB load_source_to_target_table

DESCRIPTION 'This job is to export source table and load to target table using operator templates'

(

STEP STEP_LOAD

(

APPLY $INSERT

TO OPERATOR( 

$LOAD [@LoadInstances]

ATTR

(

PrivateLogName = @TargetTable || '.load.log'

)

)

SELECT *

FROM OPERATOR

(

$EXPORT[@ExportInstances]

ATTR

(

PrivateLogName = @TargetTable || '.export.log'

)

);

);

);

Job Variables File:

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

SourceTdpId = 'TDQA',

SourceUserName ='tXXXXX',

SourceUserPassword='XXXXXX',

SourceDBTable='SANDBOX.TEST_TABLEA',

SelectStmt='select * from ' || @SourceDBTable ||' ;', 

ExportInstances=1,

SourceMaxSessions=40,

/*The following variables should be initialzied with target database server/user/table details */

TargetTdpId = 'TDDEV',

TargetUserName ='tXXXXX',

TargetUserPassword='XXXXX',

TargetDatabase='two_week_space',

TargetTable='TEST_TABLEA',

TargetWorkingDatabase='SANDBOX',

ExportTraceLevel='All',

LogTable = '' || @TargetWorkingDatabase || '.' || @TargetTable || 'lg',

LoadInstances=1,

TargetMaxSessions=40



TPT Output:

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

Teradata Parallel Transporter Version 13.10.00.10

Job log: /opt/teradata/client/13.10/tbuild/logs/tXXXXX-2408.out

Job id is tXXXXX-2408, running on XXXXXX

Teradata Parallel Transporter Load Operator Version 13.10.00.04

$LOAD: private log specified: TEST_TABLEA.load.log

Teradata Parallel Transporter Export Operator Version 13.10.00.06

$EXPORT: private log specified: TEST_TABLEA.export.log-1

$LOAD: connecting sessions

$EXPORT: connecting sessions

$EXPORT: TPT12108: Output Schema does not match data from SELECT statement

$EXPORT: disconnecting sessions

$EXPORT: Total processor time used = '0.119924 Second(s)'

$EXPORT: Start : Tue Feb 17 13:23:05 2015

$EXPORT: End   : Tue Feb 17 13:23:06 2015

$LOAD: preparing target table

$LOAD: entering Acquisition Phase

$LOAD: disconnecting sessions

$LOAD: Total processor time used = '0.630907 Second(s)'

$LOAD: Start : Tue Feb 17 13:23:05 2015

$LOAD: End   : Tue Feb 17 13:23:11 2015

Job step STEP_LOAD terminated (status 12)

Job tXXXXX terminated (status 12)



Thanks !!

4 REPLIES
Teradata Employee

Re: TPT Operator Template error "Output Schema does not match data from SELECT statement"

Write to me offline at steven.feinholz@teradata.com.

I need you to run something for me with trace enabled and then send me the debug output.

-- SteveF
Enthusiast

Re: TPT Operator Template error "Output Schema does not match data from SELECT statement"

Thanks for the response. I forwarded you the log by enabling trace. 

Teradata Employee

Re: TPT Operator Template error "Output Schema does not match data from SELECT statement"

It turns out this issue was fixed in a later version of 13.10 than you are using.

Please upgrade all of the TPT packages to the latest 13.10 efixes.

Your job should run fine just after that.

-- SteveF
Enthusiast

Re: TPT Operator Template error "Output Schema does not match data from SELECT statement"

Thanks for the update. 

--Sudhir