dspipe_init open - No such file or directory

[roy]

Hi Yall,
(The single post with dspipe_init that came out of a search returned me to a posts page not the post itself )

I have a job that runs twice.
first time against Oracle 8 (at 9:00 PM)
second time against Oracle 10g (at 9:30 PM)
Last night the first run failed at 9:25 giving the following errors in the director:

T_ChangedKodeySugPniya,2: dspipe_init(26595): open(/tmp/DW_DEV.Pny0040TeinatKodSugPniyaPrl.#2.T_ChangedKodeySugPniya.L_U_PnyKodSugPniya51-Output) - No such file or directory

T_ChangedKodeySugPniya,2: Operator's runLocally() failed

T_ChangedKodeySugPniya,2: Operator terminated abnormally: runLocally did not return APT_StatusOk

main_program: Unexpected exit status 1

main_program: Step execution finished with status = FAILED.

then the second run had a reset and run successfully (processing very few rows)
the /tmp is 1% full of 20GB and the whole job load at htat time will never come near to fill this space (I'll move it to my none volotile tmep dir anyway)

I was wondering does anyone have any ideas or potential causes for this to happen?
It is the first time I came across this message and the job usually finishes with no problem.
(Obviously I'll investigate this further)

My DS server has Oracle 8 & 10g (and hyperol if I got the name right)
But this is the dev machine and the process is in testing before production.
As far as I know there is very litle going on at this point on the DS server (I'll veryify that as well).

Any leads would be apreciated

Thanks in advance for your time,

[Kirtikumar]

Roy,

I faced similar kind of problem and errors in RTI jobs.

One of the causes- due to the full temp directory. After cleaning the directory the problem was fixed.

But as in your can temp has 1% used space, the problem might be with file creation permissions. Checking umask for the involved users may help.

[roy]

Thaks,
I've heard the sys admins say something about a problem with the FS(File System).
so it might be also the cause.

I guess a bad disk might have similar result as no space left in the FS.

I'll keep this posted if anything new pops out .

[AccentureTA]

Hello,

We are getting similar messages in the RTIAgent logs with no apparent cause or effect:

"..open(/tmp/ade.ProdRateEngine.<jobName>.1198531260747.rtiOutput) - A
file or directory in the path name does not exist..."

Our /tmp directory is not full and is 1% used currently.

Has anyone been able to find anything new about this?

Any help appreciated.

Thanks
Anand