TPT19350 I/O error on file

Tools & Utilities
Enthusiast

TPT19350 I/O error on file

Hi,

I am using TPT script to load data from source file to target table.

Script is completing successfully, but it's giving error like "TPT19350 I/O error on file" in the log file.

Please help on this.

Please let me know how to handle errors in TPT script with informatica if you have any idea.

Iam calling TPT script in informatica command task.

Thanks,

Devallu Y

9 REPLIES
Enthusiast

Re: TPT19350 I/O error on file

Hi

I am getting this error frequently.

Can any one help me on this.

any help would appreciate.

Thanks,

Devallu Y

Teradata Employee

Re: TPT19350 I/O error on file

Please provide all messages that are being reported in the log.

There might be other messages that explain why the TPT19350 was reported.

The version of TPT and platform would also be helpful.

-- SteveF
Teradata Employee

Re: TPT19350 I/O error on file

Hi Devallu Y,

Has this been resolved already?

I'm wondering if this is Character-Set related?

Rommel

Enthusiast

Re: TPT19350 I/O error on file

i am also getting same error. here is my log.

Teradata Parallel Transporter Update Operator Version 13.10.00.04

UPDATE_OPERATOR: private log not specified

Teradata Parallel Transporter DataConnector Version 13.10.00.09

DATA_PRODUCER: TPT19008 DataConnector Producer operator Instances: 1

DATA_PRODUCER: TPT19003 ECI operator ID: DATA_PRODUCER-23583

DATA_PRODUCER: TPT19222 Operator instance 1 processing file '/infadata/tptctl/date1.txt'.

UPDATE_OPERATOR: connecting sessions

UPDATE_OPERATOR: preparing target table(s)

DATA_PRODUCER: TPT19350 I/O error on file '/infadata/tptctl/date1.txt'.

DATA_PRODUCER: TPT19416 pmRead failed. Unexpected data format (16)

DATA_PRODUCER: TPT19305 Fatal error reading data.

UPDATE_OPERATOR: disconnecting sessions

DATA_PRODUCER: TPT19221 Total files processed: 0.

UPDATE_OPERATOR: Total processor time used = '0.63 Second(s)'

UPDATE_OPERATOR: Start : Fri Apr 19 13:05:26 2013

UPDATE_OPERATOR: End   : Fri Apr 19 13:05:37 2013

Job step MAIN_STEP terminated (status 12)

Job s0998cpm terminated (status 12)

tlog:

UPDATE_OPERATOR: preparing target table(s)

**** 13:05:33 This job will use the following tables:

              Target Table:  'lx_util.I1877_test'

              Error Table 2: 'lx_util.I1877_tpt_del_err2'

              Work Table:    'lx_util.I1877_tpt_del_wrk'

Task(APPLY_1[0001]): checkpoint completed, status = Success

Task(SELECT_2[0001]): checkpoint completed, status = Success

DATA_PRODUCER: TPT19350 I/O error on file '/infadata/tptctl/date1.txt'.

DATA_PRODUCER: TPT19416 pmRead failed. Unexpected data format (16)

DATA_PRODUCER: TPT19305 Fatal error reading data.

Enthusiast

Re: TPT19350 I/O error on file

Hi Devallu,

I too have faced the error "TPT19350 I/O error on file".

The probablities of this sort as per my exposure is as follows:

1. Huge size of file exported from different source. And the agreed delimeter as per coding was done as TAB, but all of a sudden the delimeter might have changed in the source file. So you can have a thorough walkthrough of the source file.

2. Suppose the source file have n columns to be imported and the definition at Table level is also n. There might be a probablity that the source file have some records with more or less than n columns. So you need to have a row by row traversal and find if the no the columns in each row is some.

We used the same using awk, I am citing a small example which might be helpfull to you.

cat 'file_name'|awk '{print NF}'|sort -u.

We have the definition at source and target end to be of 33 columns for each record. But after we executed the above, we found some varied result.

32

33

34

35

36

 And this indicated problem at source end.

:)

Hope this might be helpfull.

Enthusiast

Re: TPT19350 I/O error on file

my case i have one row and one column in input file.

here is file defination and read.

DESCRIPTION 'External File DELETE FROM CUSTOMER TABLE'

(

DEFINE SCHEMA CUST_NUM_SCHEMA

DESCRIPTION 'CUSTOMER NUMBER SCHEMA'

(

Cust_Num INTEGER

);

DEFINE OPERATOR DATA_PRODUCER

DESCRIPTION 'DATA CONNECTOR OPERATOR'

TYPE DATACONNECTOR PRODUCER

SCHEMA CUST_NUM_SCHEMA

ATTRIBUTES

(

VARCHAR OpenMode = 'Read',

VARCHAR Format = 'Formatted',

VARCHAR IndicatorMode,

VARCHAR DirectoryPath = '/infadata/tptctl',

VARCHAR FileName = 'date1.txt'

);

APPLY

(

'DELETE FROM lx_hold.I1877_test WHERE cno lt :CustNo')

TO OPERATOR (UPDATE_OPERATOR [1])

SELECT * FROM OPERATOR (DATA_PRODUCER[1]);

);

Teradata Employee

Re: TPT19350 I/O error on file

You have specified a record format of "formatted".

Are you sure your data file adheres to the required format?

-- SteveF
Enthusiast

Re: TPT19350 I/O error on file

it worked finally with using fastexporting file from teradata and Used as input to delete script.

What should be the format in tpt delete script if create data file manually in linux environment?

Thanks

Vengal

Teradata Employee

Re: TPT19350 I/O error on file

You should read the documentation to understand the various formats that we support, and then when creating that file, make sure to create it with one of the supported formats.

Our own tools (obviously) create output files in formats that are understood by our loaders.

-- SteveF