SQL Loader - Failure [message #640058] |
Tue, 21 July 2015 11:30 |
|
Hi,
When my nightly job try to execute SQL* Loader to process a file which has 450K records, only 40K records are getting processed. But there are no errors or bad records mentioned in the SQL* Loader log files.
If i try to process the same file again on the next day, it processes all the 450K records successfully. I am facing this issue everyday and couldn't able to identify what is the root cause.
sqlldr parfile=$HOME/.dlgetpw/dlpassword/.getpw/parfile.par errors=10000 control="$home/control/cbusi.ctl" data="$home/data/pr.utf8" log="$home/logs/cbusi.log" bad="$home/logs/cbusi_BAD.txt" direct=true
|
|
|
|
Re: SQL Loader - Failure [message #640066 is a reply to message #640059] |
Tue, 21 July 2015 13:01 |
|
Hi,
Log file will be overwritten, but before that i have captured the logs. Please see below logs for same file,
I am seeing this error for the past 3 days, nothing has changed in it for more than months.
Not Working
45824 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 45824
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 15
Total stream buffers loaded by SQL*Loader load thread: 14
Working
404691 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 404695
Total logical records rejected: 4
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 122
Total stream buffers loaded by SQL*Loader load thread: 127
|
|
|
|
|
|
|
Re: SQL Loader - Failure [message #640164 is a reply to message #640058] |
Thu, 23 July 2015 03:32 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
What is your O/S?
sqlldr parfile=$HOME/.dlgetpw/dlpassword/.getpw/parfile.par errors=10000 control="$home/control/cbusi.ctl" data="$home/data/pr.utf8" log="$home/logs/cbusi.log" bad="$home/logs/cbusi_BAD.txt" direct=true
How does "$HOME" compare to "$home"?
|
|
|