Pipe Already Open error

[nivas]

Hi

I am developing a job wich move data from Oracle to Teradata.
I am using Oraoci plugin for pulling data and Multiload Plugin for loading data to Teradata.The job uses outputlink name as pipe. Due to some reasons the job aborted first time . After fixing the problem I am running the job. THis time I am getting the error

trn,1: dspipe_wait(5404): pipe already opened for read by process 3695
trn,0: dspipe_wait(5406): pipe already opened for read by process 3696
trn,1: Operator's runLocally() failed
trn,0: Operator's runLocally() failed

But when I change the output link name. THe job is successfully running.
Could any body suggest what needs to be done to run the job with the same output link name.

thanks
Nivas

[roy]

Hi,
At first glance it seems like a resource that was not properly released/closed due to the first run's crash.
you'll manually need to release it or cleanup defunct processes still runnning or it might have a timeout of some sort.

IHTH,

[nivas]

HI

Could you provide some more details.
How do we find out the rsources which are not released. How do we release them manually.

thanks
Nivas

Hi,
At first glance it seems like a resource that was not properly released/closed due to the first run's crash.
you'll manually need to release it or cleanup defunct processes still runnning or it might have a timeout of some sort.

IHTH,

[roy]

Hi,
alas all I can add is:
your sysadmins should be able to help.
show them what the job does, analize what runs and what resources are taken and they'll help you I'm sure.

Good Luck,