dsjob

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:08 pm

in dsjob when I get error in param how do i find the bug

narasimha · Post by **narasimha** » Thu Feb 08, 2007 5:09 pm

kishoreramachandran wrote:in dsjob when I get error in param how do i find the bug

What error do you get?

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:09 pm

it tells me the line number param not found, but everything looks fine

narasimha · Post by **narasimha** » Thu Feb 08, 2007 5:11 pm

Please post the exact error message, it easier to find the problem.

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:13 pm

./rama1.sh[17]: -param: not found
./rama1.sh[21]: -param: not found

chulett · Post by **chulett** » Thu Feb 08, 2007 5:14 pm

Post your script.

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:22 pm

/bin/ksh
DSHOME=/usr/local/Ascential/DataStage/DSEngine
export DSHOME
. $DSHOME/dsenv
$DSHOME/bin/dsjob -run \
-mode RESET \
-warn 10000 MANC pa1
$DSHOME/bin/dsjob -run \
-param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/node1.apt' \
-param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL=""' \
-param REMOTE_SERVER="MANC2P_MR" \
-param DB_USER="kishore" \
-param DB_PASSWORD="rama123" \
-param SOURCE_TABLE_NAME="price_order" \
-param PARTITION="P0122" \
-param TARGET_TABLE_NAME="aprice_order" \
-param NZ_DATA_SOURCE="NZSQL" \
-param NZ_DB="manc_ds" \
-param NZ_SERVER="50.1.11.18" \
-param NZ_USER="manc_d" \
-param NZ_PASSWORD="mancd" \

chulett · Post by **chulett** » Thu Feb 08, 2007 5:33 pm

Must be more than that, yes?

Edit your post to fix it rather than posting it all over again.

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:36 pm

i left the last line it is
-warn 10000 MANC pa1

narasimha · Post by **narasimha** » Thu Feb 08, 2007 5:40 pm

It makes it confusing, you should have edited your last post.....
MANC is your Project Name and pa1 your job name right?
Just curious if you run the dsjob (outside the script) along with the other details, do you still get the error mesages.

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:41 pm

when i run it from designer it is perfect, problem only with the script, the job name is pa1 and the project is MANC

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 5:43 pm

./rama1.sh: !/bin/ksh: not found
Error running job

Status code = -2 DSJE_BADSTATE
Status code = -9999 DSJE_DSJOB_ERROR

narasimha · Post by **narasimha** » Thu Feb 08, 2007 6:05 pm

kishoreramachandran wrote: Status code = -2 DSJE_BADSTATE
Status code = -9999 DSJE_DSJOB_ERROR

This means you need to recompile your job before you can run it.

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 6:09 pm

when I compile and execute it the first resetting part gets executed but after that its giving the same error

kishoreramachandran · Post by **kishoreramachandran** » Thu Feb 08, 2007 6:10 pm

the first dsjob command is ok problem with the second one only

DSXchange

dsjob

dsjob

Re: dsjob