FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

Tools
Teradata Employee

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 (1)
6 REPLIES

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

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.

Teradata Employee

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

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;

    '

    );

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

Hi.

Are you selecting 16 columns into a 15 field schema?

Cheers.

Carlos.

Teradata Employee

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

Hi Carlos,

I'm just masking the 15 column.  The severidad field is not part of it.

Thank you.

Teradata Employee

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

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
Teradata Employee

Re: FEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

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