All Forums Tools
devallu_y 11 posts Joined 08/12
27 Sep 2012
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

devallu_y 11 posts Joined 08/12
28 Sep 2012

Hi
I am getting this error frequently.
Can any one help me on this.
any help would appreciate.
 
Thanks,
Devallu Y

feinholz 1234 posts Joined 05/08
10 Oct 2012

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

03 Feb 2013

 
Hi Devallu Y,
 
Has this been resolved already?
I'm wondering if this is Character-Set related?
 
Rommel

Capgemini 5 posts Joined 10/04
19 Apr 2013

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.
 

 

Vengal Jalagam
Sr. Teradata/ETL consultant

02CSE33 11 posts Joined 03/13
21 Apr 2013

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.
 
 

Regards,
Sudipta

Capgemini 5 posts Joined 10/04
22 Apr 2013

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

Vengal Jalagam
Sr. Teradata/ETL consultant

feinholz 1234 posts Joined 05/08
22 Apr 2013

You have specified a record format of "formatted".
Are you sure your data file adheres to the required format?
 

--SteveF

Capgemini 5 posts Joined 10/04
23 Apr 2013

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
 

Vengal Jalagam
Sr. Teradata/ETL consultant

feinholz 1234 posts Joined 05/08
23 Apr 2013

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

You must sign in to leave a comment.