TPT export formatted/ timestamp schema mismatch

Tools
Enthusiast

TPT export formatted/ timestamp schema mismatch

Hello Teradata experts,

I am getting EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement

with the following TPT script. Could anyone hint me what i am doing wrong please?

I am using UTF8 as we have unicode columns as well.

USING CHAR SET UTF8 DEFINE JOB TEXPORT

DESCRIPTION 'EXPORT TERADATA table with filter into formatted flat file for import'

(

DEFINE SCHEMA aa

DESCRIPTION 'table to move across instances'

(

COLUMN1 INTEGER,

COLUMN2 TIMESTAMP(6)

);

DEFINE OPERATOR EXPORT_OPERATOR

DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'

TYPE EXPORT

SCHEMA zendesk

ATTRIBUTES

(

VARCHAR PrivateLogName = 'export_aa.bb_cases_log',

VARCHAR SpoolMode = 'noSpoolOnly',

VARCHAR TdpId = 'td',

VARCHAR UserName = '...',

VARCHAR UserPassword = '...',

VARCHAR SelectStmt = 'SELECT  id,effective_start_ts  FROM schema.table;'

);

DEFINE OPERATOR FILE_WRITER

DESCRIPTION 'TERADATA PARALLEL TRANSPORTER FLAT FILE WRITER'

TYPE DATACONNECTOR CONSUMER

SCHEMA *

ATTRIBUTES

(

VARCHAR PrivateLogName = 'dataconnector_aa.bb_cases_log',

VARCHAR DirectoryPath = '/var/data',

VARCHAR FileName = 'aa.bb.dat',

VARCHAR Format = 'Formatted',

VARCHAR Openmode = 'Write',

VARCHAR IndicatorMode = 'Y'

);

APPLY TO OPERATOR (FILE_WRITER)

SELECT * FROM OPERATOR (EXPORT_OPERATOR);

);

Thank you.

7 REPLIES
Enthusiast

Re: TPT export formatted/ timestamp schema mismatch

Hi,

Can you try to give the  same schema name (i.e aa) while defining the export operator instead of zendesk .

and also try to cast the id,effective_start_ts columns in select statement and see whether it's throwing same error or not.

USING CHAR SET UTF8 DEFINE JOB TEXPORT

DESCRIPTION 'EXPORT TERADATA table with filter into formatted flat file for import'

(

DEFINE SCHEMA aa

DESCRIPTION 'table to move across instances'

(

COLUMN1 INTEGER,

COLUMN2 TIMESTAMP(6)

);

DEFINE OPERATOR EXPORT_OPERATOR

DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'

TYPE EXPORT

SCHEMA zendesk

ATTRIBUTES

(

VARCHAR PrivateLogName = 'export_aa.bb_cases_log',

VARCHAR SpoolMode = 'noSpoolOnly',

VARCHAR TdpId = 'td',

VARCHAR UserName = '...',

VARCHAR UserPassword = '...',

VARCHAR SelectStmt = 'SELECT  id,effective_start_ts  FROM schema.table;'

);

Enthusiast

Re: TPT export formatted/ timestamp schema mismatch

Sorry, i was masking data fields in the above TPT and missed the schema name. In the real script they do match. I think the issues is related to TIMESTAMP and UTF8 because once i get the timestamp field out it works... Maybe that will help identify it.

Enthusiast

Re: TPT export formatted/ timestamp schema mismatch

Oh ok!! got it.

Try to update the reason and the possible solution once you identify it, It will be useful.

Teradata Employee

Re: TPT export formatted/ timestamp schema mismatch

What version of 13.10 are you using?

The issue you are having was fixed in 13.10.00.07.

-- SteveF
Enthusiast

Re: TPT export formatted/ timestamp schema mismatch

That must be it. I am running

Teradata Parallel Transporter Version 13.10.00.04 . We will upgrade ideally to 14.

Thanks feinholz!

Enthusiast

Re: TPT export formatted/ timestamp schema mismatch

Hi Feinholz,

I am also facing the same issue. The TPT version i am having is 13.00.00.02.

Is there any work around for this without upgrading?

TIA.

Teradata Employee

Re: TPT export formatted/ timestamp schema mismatch

Please be specific in the issue you are having.

Provide the script and the error you are getting.

-- SteveF