All Forums Tools
DKing 7 posts Joined 04/12
08 Jan 2014
Delimiter Issue With TPT on Linux Platform

We are experiencing a delimiter issue with TPT on Linux.  The same script works fine on AIX.
The problem shows itself as incorrect data in the selection of CURRENT_DATE and also in incorrect data in a character field.
There are delimiters that can be used and yield correct data,  but these delimeters do not solve our problem because they are 2 character delimiters(^^) and we have downstream systems that cannot use them.
Is this a known TPT issue?  Can anyone suggest solutions?
 
 
 

M.Saeed Khurram 544 posts Joined 09/12
08 Jan 2014

Hi DKing,
Can you please tell which delimiter is causing issue?
 

Khurram

DKing 7 posts Joined 04/12
08 Jan 2014

Khurram,
 
We experienced the issue with each of these.
 
Debra

DKing 7 posts Joined 04/12
08 Jan 2014

VARCHAR TextDelimiter = '|'
VARCHAR TextDelimiter = ''
VARCHAR TextDelimiter = '~'

feinholz 1234 posts Joined 05/08
08 Jan 2014

Please provide the script and a sample of data, and a detailed explanation of the problem.
It is not clear what "incorrect data" means.
Are there any errors being shown?
What version of TPT are you using?
(Some of this information should be provided automatically, it speeds up the analysis.)

--SteveF

DKing 7 posts Joined 04/12
08 Jan 2014

We are experiencing a delimiter issue with TPT on Linux. The same script works fine on AIX.
This is the version:

Teradata Parallel Transporter DataConnector Version 13.10.00.07
Teradata Parallel Transporter Export Operator Version 13.10.00.05

This is the script:
DEFINE JOB DUMP_XXXXXX_TYP_XXX
DESCRIPTION 'MIGRATE XXXXXX_TYP_XXX'
(
DEFINE SCHEMA XXXXXX_TYP_XXX
DESCRIPTION 'SAMPLE XXXXXX_TYP_XXX'
(
TPT_COL0 VARCHAR(50),
TPT_COL4 VARCHAR(50),
TPT_COL7 VARCHAR(50)
);
DEFINE OPERATOR FILE_WRITER()
 DESCRIPTION 'TERADATA PARALLEL TRANSPORTER DATA CONNECTOR OPERATOR'
TYPE DATACONNECTOR CONSUMER
SCHEMA XXXXXX_TYP_XXX
ATTRIBUTES
(
VARCHAR PrivateLogName = 'XXXX',
VARCHAR DirectoryPath = '/home/XXXX', VARCHAR FileName = 'XXXX',
VARCHAR IndicatorMode     = 'N',
VARCHAR Format = 'Delimited',
VARCHAR TextDelimiter = '|',
VARCHAR OpenMode = 'Write'
);
DEFINE OPERATOR EXPORT_OPERATOR()
DESCRIPTION 'TERADATA PARALLEL TRANSPORTER EXPORT OPERATOR'
TYPE EXPORT
SCHEMA XXXXXX_TYP_XXX
ATTRIBUTES
(
VARCHAR PrivateLogName = 'XXX_MODEL_STG.XXXX_XXX_TYP_XXX.exporter.log',
VARCHAR TdpId = 'XXXX',
VARCHAR UserName = 'XXXX',
VARCHAR UserPassword = 'XXXX',
INTEGER MaxSessions       =  10,
INTEGER MinSessions       =  1,
VARCHAR QueryBandSessInfo,
VARCHAR SelectStmt        = ' SELECT
CAST(XXXX_XXX_TYP_ID AS VARCHAR(50)) AS A1, CAST(''One Time Data Migration''  AS VARCHAR(50))  AS A7, CAST(''One Time Data Migration'' AS VARCHAR(50)) AS A8  FROM XXX_MODEL_STG.XXXX_XXX_TYP_XXX
;
  '
);
STEP export_to_file
(
APPLY TO OPERATOR (FILE_WRITER() )
SELECT * FROM OPERATOR (EXPORT_OPERATOR() ); ); );
This shows the bad output from the TPT:
2.|One Time Data Migration|One Time Data Migration
4.|iontiontiontiontiontion|One Time Data Migration
6.|One Time Data Migration|One Time Data Migration
8.|One Time Data Migration|One Time Data Migration
 
 

feinholz 1234 posts Joined 05/08
08 Jan 2014

I tried running the exact same test inhouse and do not get the same results.
I get:
 
test1|One Time Data Migration|One Time Data Migration
test2|One Time Data Migration|One Time Data Migration
test3|One Time Data Migration|One Time Data Migration
test4|One Time Data Migration|One Time Data Migration
 

--SteveF

DKing 7 posts Joined 04/12
08 Jan 2014

Feinholz,
We are finding that we have to run the test a few times before seeing the error. For the first time, you generally get it correct.
Debra
 

DKing 7 posts Joined 04/12
08 Jan 2014

Our OS version is -- Red Hat Enterprise Linux Server release 6.3 (Santiago)
 

feinholz 1234 posts Joined 05/08
08 Jan 2014

Please do the following:
add the following to the file writer operator definition:
VARCHAR TraceLevel = 'all'
Re-run the job (until it fails), and then please send me the .out file for that failed job.
steven.feinholz@teradata.com
 

--SteveF

ratchetandclank 49 posts Joined 01/08
17 Jan 2014

Debra, 
How many records were there in the source table approximately. 
 

You must sign in to leave a comment.