Hi, I am having the same problem. When using RowErrFileName i was hoping the file which had the error in it got skipped (or the row got skipped) and the tpt process just went to the next file. However the script stops and does not continue to load other files.
Here is my script:
DEFINE JOB load_amr(
/******************************************************/
DEFINE OPERATOR W_1_op_load_amr
TYPE LOAD
SCHEMA *
ATTRIBUTES
(
VARCHAR UserName, VARCHAR UserPassword, VARCHAR LogTable, VARCHAR TargetTable, INTEGER BufferSize, INTEGER ErrorLimit, INTEGER MaxSessions, INTEGER MinSessions,
INTEGER TenacityHours, INTEGER TenacitySleep, VARCHAR AccountID, VARCHAR DateForm,
VARCHAR ErrorTable1, VARCHAR ErrorTable2, VARCHAR NotifyExit, VARCHAR NotifyExitIsDLL,
VARCHAR NotifyLevel, VARCHAR NotifyMethod, VARCHAR NotifyString, VARCHAR PauseAcq,
VARCHAR PrivateLogName, VARCHAR TdpId, VARCHAR TraceLevel, VARCHAR WorkingDatabase
);
/******************************************************/
DEFINE OPERATOR DDL_OPERATOR()
TYPE DDL
ATTRIBUTES
(
VARCHAR TdpId ='vm',
VARCHAR UserName ='d1_cdr_loader',
VARCHAR UserPassword = 'd1',
VARCHAR PrivateLogName = 'ddllog',
VARCHAR ErrorList = '3807'
);
/******************************************************/
DEFINE SCHEMA W_0_sc_load_amr
(
AMR_Profile VARCHAR(255),
AMR_Date VARCHAR(255),
AMR_Time VARCHAR(255),
AMR_Value VARCHAR(255),
AMR_Unit VARCHAR(255),
AMR_Status VARCHAR(255),
AMR_UTC_Offset VARCHAR(255)
);
/******************************************************/
DEFINE OPERATOR W_0_op_load_amr
TYPE DATACONNECTOR PRODUCER
SCHEMA W_0_sc_load_amr
ATTRIBUTES
(
VARCHAR ArchiveDirectoryPath,
VARCHAR EnableScan,
VARCHAR FileName,
VARCHAR Format, VARCHAR OpenMode, INTEGER BlockSize,
VARCHAR RowErrFileName,
INTEGER BufferSize, INTEGER RetentionPeriod, INTEGER RowsPerInstance, INTEGER SecondarySpace,
INTEGER UnitCount, INTEGER VigilElapsedTime, INTEGER VigilWaitTime, INTEGER VolumeCount,
VARCHAR AccessModuleName, VARCHAR AccessModuleInitStr,
VARCHAR DirectoryPath, VARCHAR ExpirationDate,
VARCHAR IndicatorMode, VARCHAR PrimarySpace, VARCHAR PrivateLogName, VARCHAR RecordFormat,
VARCHAR RecordLength, VARCHAR SpaceUnit, VARCHAR TextDelimiter, VARCHAR VigilNoticeFileName,
VARCHAR VigilStartTime, VARCHAR VigilStopTime, VARCHAR VolSerNumber, VARCHAR UnitType
);
/******************************************************/
STEP SETUP_TABLES
(
APPLY
('drop table D1_STG.AMR; '),
('drop table D1_STG.AMR_e1; '),
('drop table D1_STG.AMR_e2; '),
('drop table D1_STG.AMR_log; '),
('CREATE MULTISET TABLE d1_stg.amr ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
AMR_Profile VARCHAR(255),
AMR_Date VARCHAR(255),
AMR_Time VARCHAR(255),
AMR_Value VARCHAR(255),
AMR_Unit VARCHAR(255),
AMR_Status VARCHAR(255),
AMR_UTC_Offset VARCHAR(255)
)
PRIMARY INDEX ( AMR_Profile, AMR_Date, AMR_Time );
')
TO OPERATOR (DDL_OPERATOR());
);
/******************************************************/
STEP LOAD_TABLE
(
APPLY
('INSERT INTO D1_STG.AMR(
AMR_Profile,
AMR_Date,
AMR_Time,
AMR_Value,
AMR_Unit,
AMR_Status,
AMR_UTC_Offset
)
VALUES
(
:AMR_Profile,
:AMR_Date,
:AMR_Time,
:AMR_Value,
:AMR_Unit,
:AMR_Status,
:AMR_UTC_Offset
);'
)
TO OPERATOR
(
W_1_op_load_amr[1]
ATTRIBUTES
(
UserName = 'd1_cdr_loader',
UserPassword = 'd1',
ErrorTable2 = 'd1_stg.amr_e2',
ErrorTable1 = 'd1_stg.amr_e1',
LogTable = 'd1_stg.amr_log',
TargetTable = 'd1_stg.amr',
MaxSessions = 20,
TdpId = 'vm'
)
)
SELECT
AMR_Profile,
AMR_Date,
AMR_Time,
AMR_Value,
AMR_Unit,
AMR_Status,
AMR_UTC_Offset
FROM OPERATOR
(
W_0_op_load_amr[1]
ATTRIBUTES
(
ArchiveDirectoryPath='/opt/cdr/d1/ARC/',
DirectoryPath='/opt/cdr/d1/DAT/amr/',
EnableScan='Y',
FileName = '*.csv',
Format = 'DELIMITED',
RowErrFileName = 'amrErrors.txt',
OpenMode = 'Read',
IndicatorMode = 'N',
/* AccessModuleInitStr = '-inst_num 1 -inst_count 1 -delimiter x7e -indicdata Y -file_name datafile -pread N -quoted_strings " ' */
/* AccessModuleName = '/usr/lib/libamrsock.so', */
TextDelimiter = ';'
)
);
/******************************************************/
); );
And here is the output of the script:
Teradata Parallel Transporter Version 13.10.00.03
Job log: /opt/teradata/client/13.10/tbuild/logs/d1_cdr_loader-104.out
Job id is d1_cdr_loader-104, running on s10-1310
Teradata Parallel Transporter SQL DDL Operator Version 13.10.00.03
DDL_OPERATOR: private log specified: ddllog
DDL_OPERATOR: connecting sessions
DDL_OPERATOR: sending SQL requests
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'D1_STG.AMR_e1' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'D1_STG.AMR_e2' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
DDL_OPERATOR: TPT10508: RDBMS error 3807: Object 'D1_STG.AMR_log' does not exist.
DDL_OPERATOR: TPT18046: Warning: error is ignored as requested in ErrorList
Job step SETUP_TABLES completed successfully
DDL_OPERATOR: disconnecting sessions
DDL_OPERATOR: Total processor time used = '0.08 Second(s)'
DDL_OPERATOR: Start : Sun Nov 13 13:11:16 2011
DDL_OPERATOR: End : Sun Nov 13 13:11:42 2011
Teradata Parallel Transporter DataConnector Version 13.10.00.03
Teradata Parallel Transporter Load Operator Version 13.10.00.03
W_1_op_load_amr: private log not specified
W_0_op_load_amr: TPT19008 DataConnector Producer operator Instances: 1
W_0_op_load_amr: TPT19003 ECI operator ID: W_0_op_load_amr-14127
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120001000001_20110812_01.csv'.
W_1_op_load_amr: connecting sessions
W_1_op_load_amr: preparing target table
W_1_op_load_amr: entering Acquisition Phase
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120101000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000006_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000007_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000008_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120701000009_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120801000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120801000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120801000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120801000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120801000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000006_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000007_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000008_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000009_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108120901000010_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000006_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000007_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121001000008_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121100000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121100000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121100000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121100000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121100000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121201000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121301000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121301000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121401000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121401000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121401000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000002_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000003_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000004_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000005_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000006_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121501000007_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108121825000001_20110812_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130000000001_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130101000001_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000001_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000002_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000003_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000004_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000005_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000006_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000007_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130701000008_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130801000001_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130801000002_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108130801000003_20110813_01.csv'.
W_0_op_load_amr: TPT19222 Operator instance 1 processing file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108131144000001_20110813_01.csv'.
W_0_op_load_amr: TPT19350 I/O error on file '/opt/cdr/d1/DAT/amr/BEL_EBLEDM_201108131144000001_20110813_01.csv'.
W_0_op_load_amr: TPT19435 pmRead failed. EOF encountered before end of record (35)
W_0_op_load_amr: TPT19305 Fatal error reading data.
W_0_op_load_amr: TPT19221 Total files processed: 66.
W_1_op_load_amr: disconnecting sessions
W_1_op_load_amr: Total processor time used = '1.12 Second(s)'
W_1_op_load_amr: Start : Sun Nov 13 13:11:45 2011
W_1_op_load_amr: End : Sun Nov 13 13:14:13 2011
Job step LOAD_TABLE terminated (status 12)
Job d1_cdr_loader terminated (status 12)
As you can see the tpt script stops at the file with the problem in it (the problem is that the last line of the file misses some delimiters).
I can work around it by editing the file in question and adding a space behind the last delimiter or by adding some of the missing delimiters. After that I can restart the script. Now all the files will be read again which takes some time.
Another workaround is ofcourse to load the files 1 by 1 via a bash shell script but that takes very long too, because then the tpt script needs perform every step in the load script for every file. So that would be an alternative.
However I have a lot more files to load, so it would be nice to be able to just load all the correct files, let the script skip the bad files and only having to reload the bad files after correcting them.
Maybe I am missing the correct purpose of the RowErrFileName ?
Ok, a few things.
First, if you are reading all of those files (you used the wildcard *.csv) you should be specifying more than 1 instance of the DataConnector operator so that you can get these files read in parallel, instead of serially.
Next, if the CSV files only have 7 columns of information, you can do "SELECT *" in the script instead of "SELECT AMR_Profile,
AMR_Date,
AMR_Time,
AMR_Value,
AMR_Unit,
AMR_Status,
AMR_UTC_Offset . . ."
Next, I think the job terminated because of this:
W_0_op_load_amr: TPT19435 pmRead failed. EOF encountered before end of record (35)
This tells me that the last record in the file did not have a newline character before the EOF was reached (it was not a complete record).
(I thought we fixed that, but I will have to check with the developers).
The parsing of CSV files relies on the "end-of-record" marker to indicate the end of the record.
This type of error is probably treated differently than just a different type of record that does not have the same number of columns as the schema.
Any news from your check with the developers?
It would be nice if this error would also been treated the same, so that the file would be skipped. This way the file could be corrected aftwerwards and reloaded again, without having to reload the files that went allright.
Upgrade to the latest patch for 13.10, which should be 13.10.00.07.
That should fix this problem.
I am trying to load XML File using TPT and below is the script....
DEFINE JOB LOADING_LOB_DATA
DESCRIPTION 'LOAD PRODUCT DEFINITION TABLE'
(
DEFINE SCHEMA SOURCE_SCHEMA
DESCRIPTION 'PRODUCT INFORMATION SCHEMA'
(
COL2_CLOB CLOB(50000)
);
DEFINE OPERATOR FILE_READER ()
TYPE DATACONNECTOR PRODUCER
SCHEMA SOURCE_SCHEMA
ATTRIBUTES
(
VARCHAR PrivateLogName = 'dataconnector_log',
VARCHAR DirectoryPath = 'G:\Users\YashNeil\Desktop\VZ',
VARCHAR FileName = 'VZVOD_999999_20120412_100510_000000004.xml',
VARCHAR Format = 'unformatted',
VARCHAR OpenMode = 'Read'
);
DEFINE OPERATOR SQL_INSERTER ()
TYPE INSERTER
INPUT SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'inserter_log',
VARCHAR TdpId = 'localtd',
VARCHAR UserName = 'tduser',
VARCHAR UserPassword = 'tduser'
);
STEP Loading_LOB_Data
(
APPLY
('INSERT INTO retail.stage values (:Col2_CLOB);')
TO OPERATOR (SQL_INSERTER [1])
SELECT * FROM OPERATOR (FILE_READER());
);
);
I am gettting below error for this script...
Teradata Parallel Transporter Version 13.00.00.02
Job log: G:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\/l
ogs/YashNeil-49.out
Job id is YashNeil-49, running on YashNeil-PC
Found CheckPoint file: G:\Program Files\Teradata\Client\13.0\Teradata Parallel T
ransporter\/checkpoint\YashNeilLVCP
This is a restart job; it restarts at step Loading_LOB_Data.
Teradata Parallel Transporter SQL Inserter Operator Version 13.00.00.02
SQL_INSERTER: private log specified: inserter_log
Teradata Parallel Transporter DataConnector Version 13.00.00.02
FILE_READER Instance 1 directing private log report to 'dataconnector_log-1'.
FILE_READER Instance 1 restarting.
FILE_READER DataConnector Producer operator Instances: 1
SQL_INSERTER: connecting sessions
FILE_READER Operator instance 1 processing file 'G:\Users\YashNeil\Desktop\VZ\VZ
VOD_999999_20120412_100510_000000004.xml'.
FILE_READER: TPT19003 !ERROR! LOB column data length error on record 1
FILE_READER Total files processed: 0.
SQL_INSERTER: Total Rows Sent To RDBMS: 0
SQL_INSERTER: Total Rows Applied: 0
SQL_INSERTER: disconnecting sessions
SQL_INSERTER: Total processor time used = '0.280802 Second(s)'
SQL_INSERTER: Start : Tue May 08 20:56:57 2012
SQL_INSERTER: End : Tue May 08 20:56:59 2012
Job step Loading_LOB_Data terminated (status 12)
Job YashNeil terminated (status 12)
Could someone help me in fixing this problem...