Error Dataset to Oracle

jusami25 · Post by **jusami25** » Fri Feb 13, 2009 7:54 am

Hi all,

We are trying to do a direct load from a DataSet to Oracle. When we have record on the DataSet the job finish ok, but we are facing below error when the DataSet generated from previous job doesn't have any record.

SQL*Loader-500: Unable to open file (\.\pipe\ora.64020.600000.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.
The call to sqlldr failed; the return code = 256;

Could you, please, help us with this?

Thanks in advance.

richdhan · Post by **richdhan** » Mon Feb 16, 2009 7:05 am

Hi,

How about using row generator and generate a dummy record. Load the dummy record along with the dataset records. If the dataset is empty then the dummy record will get inserted.

Use close command to delete the dummy record once the load operation is complete.

HTH
--Rich

jusami25 · Post by **jusami25** » Tue Mar 31, 2009 7:26 am

Hi Richdhan,

Thanks for the reply. We have thought the same solution you provide.

As this error seems to be an IBM bug. What we want to know is:

There is anyone who have faced the same problem?
There is an IBM patch to solve this?

Thanks.

chulett · Post by **chulett** » Tue Mar 31, 2009 7:57 am

Why not check to ensure there's data to load before invoking this process? It doesn't seem like a "bug" per se to me, the stage utilizes a named pipe to feed sqlldr and one of the two of them doesn't like the fact that there's no data to process.

jusami25 · Post by **jusami25** » Tue Mar 31, 2009 11:33 am

Hi,

I have found a on this topic a posible solution of the bug... viewtopic.php?t=119030&highlight=Job+Ab ... e+of+nodes

chulett · Post by **chulett** » Tue Mar 31, 2009 12:10 pm

Interesting... let us know after you get the patch if that fixes it for you.

jusami25 · Post by **jusami25** » Wed Apr 01, 2009 5:04 am

Sure chulett.

I will keep the forum updated