Delimiter Issue With TPT on Linux Platform

Tools
N/A

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?

10 REPLIES

Re: Delimiter Issue With TPT on Linux Platform

Hi DKing,

Can you please tell which delimiter is causing issue?

Khurram
N/A

Re: Delimiter Issue With TPT on Linux Platform

Khurram,

We experienced the issue with each of these.

Debra

N/A

Re: Delimiter Issue With TPT on Linux Platform

VARCHAR TextDelimiter = '|'

VARCHAR TextDelimiter = ''

VARCHAR TextDelimiter = '~'

Teradata Employee

Re: Delimiter Issue With TPT on Linux Platform

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
N/A

Re: Delimiter Issue With TPT on Linux Platform

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

Teradata Employee

Re: Delimiter Issue With TPT on Linux Platform

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
N/A

Re: Delimiter Issue With TPT on Linux Platform

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

N/A

Re: Delimiter Issue With TPT on Linux Platform

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

Teradata Employee

Re: Delimiter Issue With TPT on Linux Platform

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