Page 1 of 1

oracle to teradata. job failure code 134

Posted: Thu Jan 11, 2007 9:31 pm
by lynnliu
Hi,
Has anyone met this problem? when i seperately accessed Oracle or Teradata, things is ok, but it failed when contained oracle with teradata together in one job. my job is simple, Oracle---->Teradata
The failed log as follow,

Code: Select all

main_program: The NLS character map <ASCL_ISO8859-1> specified may not be compatible with
the character set specified by NLS_LANG;
you may get unexpected results from your database.
*** glibc detected *** double free or corruption (out): 0x082aaba0 ***
Contents of phantom output file =>
RT_SC139/OshExecuter.sh: line 20: 14599 Aborted                 (core dumped) $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1
Parallel job reports failure (code 134)
I checked the RT_SC139

Code: Select all

1 ##!/bin/sh
2 ## Shell script for Datastage to execute an Orchestrate osh script, generated at 2005-12-19 19:19:02
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 ooshscript=$1
9 ooshpipe=$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
Thanks!

Posted: Thu Jan 11, 2007 9:33 pm
by I_Server_Whale
Hi,

You have posted the topic twice. Please remove the duplicate post.

Posted: Thu Jan 11, 2007 9:41 pm
by I_Server_Whale
A search on exact with 'Parallel job reports failure (code 134)' yielded this POST.

Posted: Fri Jan 12, 2007 12:51 am
by lynnliu
I am sorry for submitting twice.

Thanks for your reminder. I had search the post you metioned before posting this question. I am confused that why failed when puting oracle and teradata enterprise stage together. Different NLS result in this error? how to set the NLS_LANG in dsenv under this situation(Oracle is AMERICAN_AMERICAN.ZHS16GBK, teradata is ISO8859-1)?

Thanks.