DSXchange

Hi,

Any idea how to troubleshoot the DS jobs if getting following error:-
DataStage Job 1051 Phantom 2051
Program "DSD.IPCOpen": Line 185, WRITE failure.
Attempting to Cleanup after ABORT raised in stage SMSCERRORLoadFactMetricaSmsError..Link_Collector
DataStage Phantom Aborting with @ABORT.CODE = 3

Regards,
SC

Hi,
i guess this comes at the ouput stage.
may i know what the value set for "Clean On Failure"

regards
kumar

Hi Kumar,

I have no idea what is the value set for "Clean On Failure". Can u guide me where to find it?

Regards,
SC

Do a job reset and look into the new message(s) in the log file, often they contain additional information.

ysweec wrote:Hi Kumar,

I have no idea what is the value set for "Clean On Failure". Can u guide me where to find it?

Regards,
SC

Hi,
u can find this in the output stage, under properties tab -->Opiton ---> Clean On Failure

regards
kumar

kumar_s wrote:u can find this in the output stage, under properties tab -->Opiton ---> Clean On Failure

Huh? Maybe in a PX job, but not in Server anywhere that I recall.

The best thing to try is what Arnd suggested - reset the job after it aborts via the Director and see if any messages come into the log labelled as 'From previous run...'.

Hi,
Iam sorry, yes that is in PX jobs

regards
lumar

Attempting to cleanup after abort is purely informational, and can be noted and ignored.

The actual error has occured in a Link Collector stage, and is a failure to write - presumably to a buffer used by that stage or to a file (Sequential File stage?) connected to its output. This is most likely to be a permissions or space problem.

Reset the job in Director; there may be a "from previous run..." message logged that contains additional diagnostic information.

Also, determine the name of the directory referred to in your UVTEMP configuration parameter, and check that its file system has plenty of free space.

Hi Ray,

Yes. My job is job server.
10x! That job can be reset and re-run successfully.

"determine the name of the directory referred to in your UVTEMP configuration parameter, and check that its file system has plenty of free space. "

Would like to what do u means by "determine the name of the directory referred to in your UVTEMP configuration parameter"? The name of the directory in where?

Regards,
SC

In the DataStage home directory is a file called uvconfig containing a heap of DataStage configuration parameters. UVTEMP is one of these. Its value is a directory used for various kinds of temporary file by the DataStage run machine.
From the operating system you can execute a command such as

Hi Ray,

10x so much.
So, u means just check the UVTEMP is refered to which directory and check the available space for that directory, right?
Anything to tune on the DS jobs?

SC