FATAL ERROR

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
develop
Premium Member
Premium Member
Posts: 7
Joined: Fri May 26, 2006 4:34 pm

FATAL ERROR

Post by develop »

hi
this is the fatal error i got
"Parallel job reports failure (code 134)"

any help would be greatly appreciated
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

This is the error code given out from server. But you should be getting some other warning or error which is the actual reason.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Reset the job in Director. Additional diagnostic information may be logged "from previous run". Ask your support provider what "code 134" means.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

Code 132 means that the dataset is not available.

Code 1 means the File path is incorrect.

Code 134??

Are you using $APT_CONFILE_FILE. The Datatype should be FilePath and it should point to the right Configuration file.

But Iam not sure whether I got Code 138 or Code 134.

Kumar,

You dont get any warnings or other error messages in these case where there in only one error message which states Parallel Job reports failure along with this Code.

Ray,

Whatever you have mentioned is that applicable to Parallel jobs. I have seen them in Server jobs though.

HTH
--Rich
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

Post by roblew »

I have just run into this error as well. The job is a simple job that extracts from a SQL Server view and loads to Oracle.


main_program: Requesting delayed metadata.
APT_ParseError: Parsing parameters "max=0" for schema type "ustring": Max length must be positive, got: "0"
Could not find type: ustring[max=0]

Contents of phantom output file =>
RT_SC16/OshExecuter.sh: line 20: 25457 Aborted (core dumped) $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1

Parallel job reports failure (code 134)


From another thread, I took Ray's suggestion to take a look at the script.

1 #!/bin/sh
2 # Shell script for Datastage to execute an Orchestrate osh script, generated at 2006-10-10 15:32:29
3 #
4 # Parameters:
5 # $1 - osh script to run (file path)
6 # $2 - fifo name to write osh diagnostic output
7 # $3 onwards - osh options (may be absent)
8 oshscript=$1
9 oshpipe=$2
10 shift
11 shift
12 if test ! -x "$APT_ORCHHOME/bin/osh"
13 then echo '##OSHRETVAL NOOSH' > $oshpipe
14 exit 1
15 fi
16 $APT_ORCHHOME/bin/osh "$@" -f $oshscript > $oshpipe 2>&1 &
17 oshpid=$!
18 # Write the pid of the conductor process to the fifo
19 echo '##OSHPID' $oshpid > $oshpipe
20 wait $oshpid
21 # Write the terminating string to the fifo
22 echo '##OSHRETVAL' $? > $oshpipe
23 # end of script


At line 20, it looks like it's just waiting for the PID to return its termination status, which I assume returned "25457 Aborted". Is there a way to find out what the error really was? Does it have anything to do with the "Max length must be positive" message?
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

I got this error when i explicity gave column length less than the actuall database column length.

so had to change that inside the job, if i have to avoid this error.

Thanks
Post Reply