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.
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;
'
);
Hi.
Are you selecting 16 columns into a 15 field schema?
Cheers.
Carlos.
Hi Carlos,
I'm just masking the 15 column. The severidad field is not part of it.
Thank you.
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
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
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)