All Forums Tools
cloghin 17 posts Joined 04/12
25 Feb 2013
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.

kusumayella 16 posts Joined 08/10
26 Feb 2013

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;'
);
 
 
 

cloghin 17 posts Joined 04/12
26 Feb 2013

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.

kusumayella 16 posts Joined 08/10
27 Feb 2013

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

feinholz 1234 posts Joined 05/08
27 Feb 2013

What version of 13.10 are you using?
The issue you are having was fixed in 13.10.00.07.
 

--SteveF

cloghin 17 posts Joined 04/12
28 Feb 2013

That must be it. I am running
Teradata Parallel Transporter Version 13.10.00.04 . We will upgrade ideally to 14.
Thanks feinholz!
 

zammohan 6 posts Joined 04/14
30 Apr 2014

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.

Best,
Shyam

feinholz 1234 posts Joined 05/08
30 Apr 2014

Please be specific in the issue you are having.
Provide the script and the error you are getting.
 

--SteveF

You must sign in to leave a comment.