Hi All,
This job is only aborting incase when there is 0 records to be writen in EH_EXCEPTION_INSTANCE (oracle enterprise edition) with following errors other wise running fine.
Wondering had it been permission issue (based upon search on this forum) then why running successfuly when it has few recourds to be written in this table.
EH_EXCEPTION_INSTANCE,0: Export complete; 0 records exported successfully, 0 rejected.
EH_EXCEPTION_INSTANCE,0: SQL*Loader-500: Unable to open file (\\.\pipe\ora.6300.66000d.fifo.0)
EH_EXCEPTION_INSTANCE,0: SQL*Loader-554: error opening file
EH_EXCEPTION_INSTANCE,0: SQL*Loader-509: System error: The operation completed successfully.
EH_EXCEPTION_INSTANCE,0: SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
EH_EXCEPTION_INSTANCE,0: The call to sqlldr failed; the return code = 256;
please see the loader logfile: E:/IBM/InformationServer/Server/Scratch/ora.6300.66000d.0.log for details.
EH_EXCEPTION_INSTANCE,0: Log file contents:
EH_EXCEPTION_INSTANCE,0: The runLocally() of the operator failed.
Also posting the
Contents of loader logfile for trobleshoot....
SQL*Loader: Release 10.2.0.1.0 - Production on Thu Apr 24 11:43:29 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: ora.6300.66000d.0.ctl
Data File: \\.\pipe\ora.6300.66000d.fifo.0
File processing option string: "FIX 1280"
Bad File: ora.6300.66000d.0.log.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct
Table EXCEPTION_INSTANCE, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
EXCEPTION_INSTANCE_ID 1:20 20 PACKED DECIMAL (38, 0)
NULL if 1:20 = 0X0000000000000000000000000000000000000000(character '')
EXCEPTION_ID 21:40 20 PACKED DECIMAL (38, 0)
NULL if 21:40 = 0X0000000000000000000000000000000000000000(character '')
EXCEPTION_RUN_ID 41:60 20 PACKED DECIMAL (38, 0)
NULL if 41:60 = 0X0000000000000000000000000000000000000000(character '')
EXCEPTION_INSTANCE_DESC 61:1060 1000 CHARACTER
NULL if 61:1060 = BLANKS
SOURCE_OBJECT_KEY 1061:1160 100 CHARACTER
NULL if 1061:1160 = BLANKS
DW_SK_ID 1161:1180 20 PACKED DECIMAL (38, 0)
NULL if 1161:1180 = 0X0000000000000000000000000000000000000000(character '')
PERSON_RESPONSIBLE_KEY 1181:1280 100 CHARACTER
NULL if 1181:1280 = BLANKS
SQL*Loader-500: Unable to open file (\\.\pipe\ora.6300.66000d.fifo.0)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: The operation completed successfully.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Table EXCEPTION_INSTANCE:
0 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: 0
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 0
Total stream buffers loaded by SQL*Loader load thread: 0
Run began on Thu Apr 24 11:43:29 2008
Run ended on Thu Apr 24 11:43:30 2008
Elapsed time was: 00:00:00.53
CPU time was: 00:00:00.06
Job aborting while writing 0 Records to Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't see any problem mentioned in the Oracle sqlldr log file.
Can you please post the full and exact message of any warning or error message in the DataStage job log itself? Also, is there anything in the sqlldr "bad" file?
Can you please post the full and exact message of any warning or error message in the DataStage job log itself? Also, is there anything in the sqlldr "bad" file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.