TPT - problem with processing file

Tools & Utilities

TPT - problem with processing file

Hi everyone,

I have job consisting of several steps. I want to load data from flat files to database, but I have problem with one step. Below, I paste information from log file of this step when problem occured:

-----------------------------------

Teradata Parallel Transporter Version 14.00.00.06

Job log: /DWH/Develop/proc_ods/wyrocznia/wyrocznia_l_ods/tmp/wyrocznia_l_ods_WYR_ORDER_DOCUMENT_L_20150309_165331-1016.out

Job id is wyrocznia_l_ods_WYR_ORDER_DOCUMENT_L_20150309_165331-1016, running on dwd02

Teradata Parallel Transporter SQL DDL Operator Version 14.00.00.06

$DDL: private log not specified

$DDL: connecting sessions

$DDL: sending SQL requests

$DDL: TPT10508: RDBMS error 3807: Object 'IVM_DB_TMP.ET_WYR_ORDER_DOCUMENT_L' does not exist.

$DDL: TPT18046: Warning: error is ignored as requested in ErrorList

$DDL: TPT10508: RDBMS error 3807: Object 'IVM_DB_TMP.UV_WYR_ORDER_DOCUMENT_L' does not exist.

$DDL: TPT18046: Warning: error is ignored as requested in ErrorList

$DDL: Rows Deleted:  0

$DDL: disconnecting sessions

$DDL: Total processor time used = '0.058629 Second(s)'

$DDL: Start : Mon Mar  9 16:53:33 2015

$DDL: End   : Mon Mar  9 16:53:33 2015

Job step setup_step completed successfully

Teradata Parallel Transporter $FILE_READER: TPT19006 Version 14.00.00.06

$FILE_READER: TPT19008 DataConnector Producer operator Instances: 1

Teradata Parallel Transporter SQL Inserter Operator Version 14.00.00.06

$INSERTER: private log not specified

$FILE_READER: TPT19003 ECI operator ID: $FILE_READER-5124192

$FILE_READER: TPT19222 Operator instance 1 processing file '/DWH/Develop/SourceData_incr/wyrocznia_ods/load/order_document.dat'.

$INSERTER: connecting sessions

$FILE_READER: TPT19350 I/O error on file '/DWH/Develop/SourceData_incr/wyrocznia_ods/load/order_document.dat'.

$FILE_READER: TPT19003 SYSTEM_BUFFERMODE: 'no'

$FILE_READER: TPT19221 Total files processed: 0.

$INSERTER: Total Rows Sent To RDBMS:      0

$INSERTER: Total Rows Applied:            0

$INSERTER: disconnecting sessions

$INSERTER: Total processor time used = '0.059809 Second(s)'

$INSERTER: Start : Mon Mar  9 16:53:33 2015

$INSERTER: End   : Mon Mar  9 16:53:34 2015

Job step main_step terminated (status 12)

Job wyrocznia_l_ods_WYR_ORDER_DOCUMENT_L_20150309_165331 terminated (status 12)

-------------------------------------------------------------------------------------------------------------------

I checked the order_document.dat file, but there isn't any record (file is empty, but is normally). I noticed, when I add one sample record to this file, then problem disappear.

I will be very grateful for help / suggest on how to eliminate the problem. I would like, the TPT didn't break the job when any flat file will be empty.

Tags (1)
2 REPLIES
Enthusiast

Re: TPT - problem with processing file

>'/DWH/Develop/SourceData_incr/wyrocznia_ods/load/ order_document.dat'

there is a space char here, it's a typo or the the real script?

ciao

GIovanni

Re: TPT - problem with processing file

Hi,

I checked the log file once again and there I didn't see space char, so it was added when I paste it