Cannot view full Log Detail for SQL *Loader
Posted: Mon Dec 22, 2008 7:04 am
Hi,
I'm having a unix script ICF_LAB_SERV_LINE_DETL.sh. This script has been called in Sequencer job. This script is used to load a table with SQL Loader. While running, I got an SQL Loader error.
Checking in Datastage Director I can view
LabStandardProcessingSeq.61.JobControl (ExecSH): Error when executing command: /dso/dsorg1a/apps/scripts/ICF_LAB_SERV_LINE_DETL.sh dsoreg1 dsoreg1 dsosit /dso/dsorg1a/apps/scripts 61 /dso/dsorg1a/clients/upsx/lab/output /dso/dsorg1a/clients/upsx/lab/logs
*** Output from command was: ***
partition already exists,hence dropping
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Dec 22 05:44:50 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Load completed - logical record count 10.
Datafile= /dso/dsorg1a/clients/upsx/lab/output/LabStdProc_61.txt
Datafile Record count=10
Loaded records= 10
Allowed Error record count= 0
Minimum records to load:10
All records were loaded, but load failed due to some Oracle errors
Check log file /dso/dsorg1a/clients/upsx/lab/logs/ICF_LAB_SERV_LINE_DETL_61.log for more details
When trying to get the log details from command line as
dsjob -logdetail dsoreg1 LabStandardProcessingSeq.61 166
I can get only
LabStandardProcessingSeq.61.JobControl (ExecSH): Error when
executing command:
/dso/dsorg1a/apps/scripts/ICF_LAB_SERV_LINE_DETL.sh dsoreg1 dsoreg1
dsosit /dso/dsorg1a/apps/scripts 61
/dso/dsorg1a/clients/upsx/lab/output
/dso/dsorg1a/clients/upsx/lab/logs
*** Output from command was: ***
partition already exists,hence dropping
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Dec 22 05:44:50
2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Why can't I get the whole log details that I can view in Director?
I'm having a unix script ICF_LAB_SERV_LINE_DETL.sh. This script has been called in Sequencer job. This script is used to load a table with SQL Loader. While running, I got an SQL Loader error.
Checking in Datastage Director I can view
LabStandardProcessingSeq.61.JobControl (ExecSH): Error when executing command: /dso/dsorg1a/apps/scripts/ICF_LAB_SERV_LINE_DETL.sh dsoreg1 dsoreg1 dsosit /dso/dsorg1a/apps/scripts 61 /dso/dsorg1a/clients/upsx/lab/output /dso/dsorg1a/clients/upsx/lab/logs
*** Output from command was: ***
partition already exists,hence dropping
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Dec 22 05:44:50 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Load completed - logical record count 10.
Datafile= /dso/dsorg1a/clients/upsx/lab/output/LabStdProc_61.txt
Datafile Record count=10
Loaded records= 10
Allowed Error record count= 0
Minimum records to load:10
All records were loaded, but load failed due to some Oracle errors
Check log file /dso/dsorg1a/clients/upsx/lab/logs/ICF_LAB_SERV_LINE_DETL_61.log for more details
When trying to get the log details from command line as
dsjob -logdetail dsoreg1 LabStandardProcessingSeq.61 166
I can get only
LabStandardProcessingSeq.61.JobControl (ExecSH): Error when
executing command:
/dso/dsorg1a/apps/scripts/ICF_LAB_SERV_LINE_DETL.sh dsoreg1 dsoreg1
dsosit /dso/dsorg1a/apps/scripts 61
/dso/dsorg1a/clients/upsx/lab/output
/dso/dsorg1a/clients/upsx/lab/logs
*** Output from command was: ***
partition already exists,hence dropping
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Dec 22 05:44:50
2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Why can't I get the whole log details that I can view in Director?