Showing below is a part from the log file.
In my session, I am using Source-based commit (as per the
requirements). Commit Interval is the max value. Basically, the intention is to do a commit for whole set of rows at the end (when successful load happens). Otherwise do a rollback on failure.
Delimiter in my source is NEW LINE (\012). That's fine.
It works well. But, sometimes, I am getting the error with large files.
My problem is, while doing the load for a large file of around 65MB (may contain around 640000 rows), this creates some operating system error and the session fails.
Why this is happening ? Any clue
WRITER_2_1_1> WRT_8167 Start loading table [S_TAX_INSURANCE_CHG_HIST]
at: Thu Dec 11 16:29:53 2003
READER_2_1_1> Thu Dec 11 18:12:51 2003
READER_2_1_1> FR_3002 Error reading from file [\\Ifgw01
\Interfaces\Dev\ReSolve\SrcFiles\TAXINSUR.TXT]. Operating system
error message [Invalid argument].
READER_2_1_1> Thu Dec 11 18:12:52 2003
READER_2_1_1> BLKR_16034 ERROR: Fetch failed.
WRITER_2_1_1> WRT_8333 Rolling back all the targets due to fatal
session error.
WRITER_2_1_1> WRT_8325 Final rollback executed for the target
[T_JOB_PROGRESS, S_TAX_INSURANCE_CHG_HIST, R_TAX_INSURANCE_CHG_HIST1,
R_TAX_INSURANCE_CHG_HIST, S_TAX_INSURANCE_CHG_HIST1] at end of load
WRITER_2_1_1> Thu Dec 11 18:13:46 2003
WRITER_2_1_1> WRT_8170 Writer run terminated: Abort Session request
received from the DTM
Basically, my window screen pops up an OS message
An error occurred connecting to .... (the netwark drive mapping )Microsoft Windows Network : The local device name is already om use. This connection has not been restored.
I am surprised, while such network connection error is happening when I run perticularly this session.
In my session, I am using Source-based commit (as per the
requirements). Commit Interval is the max value. Basically, the intention is to do a commit for whole set of rows at the end (when successful load happens). Otherwise do a rollback on failure.
Delimiter in my source is NEW LINE (\012). That's fine.
It works well. But, sometimes, I am getting the error with large files.
My problem is, while doing the load for a large file of around 65MB (may contain around 640000 rows), this creates some operating system error and the session fails.
Why this is happening ? Any clue
WRITER_2_1_1> WRT_8167 Start loading table [S_TAX_INSURANCE_CHG_HIST]
at: Thu Dec 11 16:29:53 2003
READER_2_1_1> Thu Dec 11 18:12:51 2003
READER_2_1_1> FR_3002 Error reading from file [\\Ifgw01
\Interfaces\Dev\ReSolve\SrcFiles\TAXINSUR.TXT]. Operating system
error message [Invalid argument].
READER_2_1_1> Thu Dec 11 18:12:52 2003
READER_2_1_1> BLKR_16034 ERROR: Fetch failed.
WRITER_2_1_1> WRT_8333 Rolling back all the targets due to fatal
session error.
WRITER_2_1_1> WRT_8325 Final rollback executed for the target
[T_JOB_PROGRESS, S_TAX_INSURANCE_CHG_HIST, R_TAX_INSURANCE_CHG_HIST1,
R_TAX_INSURANCE_CHG_HIST, S_TAX_INSURANCE_CHG_HIST1] at end of load
WRITER_2_1_1> Thu Dec 11 18:13:46 2003
WRITER_2_1_1> WRT_8170 Writer run terminated: Abort Session request
received from the DTM
Basically, my window screen pops up an OS message
An error occurred connecting to .... (the netwark drive mapping )Microsoft Windows Network : The local device name is already om use. This connection has not been restored.
I am surprised, while such network connection error is happening when I run perticularly this session.