Job aborting while writing 0 Records to Oracle table

[BillB]

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

[BillB]

We are encountering this problem with more jobs resulting in abort which are writing zero records,

Any insight in the matter shall be welcomed

[ray.wurlod]

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?