All Forums Tools
tiiiway 12 posts Joined 05/16
18 May 2016
FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

Any help will be much appreciated.  Thank you.
 
Teradata Parallel Transporter Version 14.00.00.04
Job log: /apps/tpt/Datos/TDA_DESA/Tptlogs/root-924.out
Job id is root-924, running on TDExpress1403_Sles10
Teradata Parallel Transporter Update Operator Version 14.00.00.04
MLOAD_OPERATOR_150: private log not specified
Teradata Parallel Transporter Export Operator Version 14.00.00.04
FEXP_OPERATOR: private log not specified
FEXP_OPERATOR: connecting sessions
MLOAD_OPERATOR_150: connecting sessions
FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement
FEXP_OPERATOR: disconnecting sessions
FEXP_OPERATOR: Total processor time used = '0.08 Second(s)'
FEXP_OPERATOR: Start : Wed May 18 11:45:07 2016
FEXP_OPERATOR: End   : Wed May 18 11:45:09 2016
MLOAD_OPERATOR_150: preparing target table(s)
MLOAD_OPERATOR_150: entering Acquisition Phase
MLOAD_OPERATOR_150: disconnecting sessions
MLOAD_OPERATOR_150: Total processor time used = '0.19 Second(s)'
MLOAD_OPERATOR_150: Start : Wed May 18 11:45:07 2016
MLOAD_OPERATOR_150: End   : Wed May 18 11:45:11 2016
Job step Apply_MLoad terminated (status 12)
Job root terminated (status 12)
 

Tags:
CarlosAL 512 posts Joined 04/08
18 May 2016

Hi.
Error message is self-explanatory: The schema is different from the data selected from the EXPORT operator.
If you want us to help you it would be nice if you show us the tpt script. We have no crystal balls...
Cheers.
Carlos.

tiiiway 12 posts Joined 05/16
18 May 2016

Hello, please see details below.  Thanks!
 
DEFINE SCHEMA BEPS
 DESCRIPTION 'Schema'    
    x1Column             INTEGER,
    x2Column         VARCHAR(2),
    x3Column         VARCHAR(15),
    x4Column             VARCHAR(30),
    x5Column             VARCHAR(30),
    x6Column             VARCHAR(30),
    x7Column         VARCHAR(30),
    x8Column     TIME(6),
    x9Column         VARCHAR(20),
    x10Column     ANSIDATE,
    x11Column         INTEGER,
    x12Column         ANSIDATE,
    x13Column         DECIMAL(18,0),
    x14Column         DECIMAL(18,0),
    x15Column             BYTEINT
   );

DEFINE OPERATOR FEXP_OPERATOR
   TYPE EXPORT
   SCHEMA BEPS
   ATTRIBUTES
   (
   VARCHAR UserName = 'xxxxxx',
   VARCHAR UserPassword = 'xxxxxx',
   VARCHAR TdpId = 'xxxxxx',
    INTEGER MaxSessions,
    INTEGER MinSessions,
    INTEGER TenacityHours,
    INTEGER TenacitySleep,
    VARCHAR AccountID,
    VARCHAR PrivateLogName,
    VARCHAR TraceLevel,
    VARCHAR WorkingDatabase,
    VARCHAR ErrorTable = 'DB_LOG.BEPS_fxlog',
    VARCHAR SelectStmt =
        'SELECT
        x1Column
        ,x2Column
        ,x3Column
        ,x4Column
        ,x5Column
        ,x6Column
        ,x7Column
        ,x8Column
        ,x9Column
        ,x10Column
        ,x11Column
        ,x12Column
        ,x13Column
        ,x14Column
        ,x15Column,Severidad
     FROM  DB_STAGE.VBEPS;
    '
    );

CarlosAL 512 posts Joined 04/08
19 May 2016

Hi.
Are you selecting 16 columns into a 15 field schema?
Cheers.
Carlos.

tiiiway 12 posts Joined 05/16
19 May 2016

Hi Carlos,
I'm just masking the 15 column.  The severidad field is not part of it.
Thank you.

feinholz 1234 posts Joined 05/08
19 May 2016

Please provide the entire script.
In the schema you defined one of the columns as ANSIDATE.
But by default, the database will return DATE information in an integer format.
In order for you to get the DATE data in ANSI format, you will need to tell the database to provide the DATE data in ANSI format through the DateForm attribute, and set it to "ANSIDATE".
 

--SteveF

feinholz 1234 posts Joined 05/08
19 May 2016

And remove this from the Export operator definition:
    VARCHAR ErrorTable = 'DB_LOG.BEPS_fxlog',
It is not being used; it is being ignored, but it should not be there.
The Export operator does not use an error table.
 
 

--SteveF

You must sign in to leave a comment.