DSXchange

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

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

What error do you get?

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

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

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

Post your script.

/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" \

Must be more than that, yes?

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

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

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.

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

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

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

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.

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

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