Don't get warning message for execute command

times29 · Post by **times29** » Tue Mar 12, 2013 1:08 pm

Hi,
I am calling below script from execute command and it fails but not seeing in warning in director who can i fix that.

csh /aa/app/scripts/Capital.csh

#!/bin/csh

ssh -i /aa/oracle/.ssh/rsa_cognos10_dsadmin test pfexec /ee/c10_cubes/script/Capital.sh

set vReturnStatus = $status

exit $vReturnStatus

i get

Reply=127
Output from command ====>

but i don't see warning in director who can i get warning in director if Reply is not 0

Thanks

prasson_ibm · Post by **prasson_ibm** » Tue Mar 12, 2013 2:17 pm

Hi,
I am not sure how you will get warning message,but in case you want to abort the seq. ,that you can set in seq.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 12, 2013 3:10 pm

Do you have automatic error handling enabled in the sequence? Do you have a Failure trigger on the Execute Command activity?

sudha03_vpr · Post by **sudha03_vpr** » Tue Mar 12, 2013 4:22 pm

You may need to add a link from the execute command to the notification activity followed by terminator stage to abort the process.

Trigger option of the execute command should be custom conditional and define your condition there in case of unexpected output.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 12, 2013 4:54 pm

In my opinion you should never create DataStage jobs that abort intentionally.

chulett · Post by **chulett** » Tue Mar 12, 2013 7:13 pm

... unless it's a Sequence job that is restartable.

times29 · Post by **times29** » Tue Mar 12, 2013 7:21 pm

Well that will not fix my problem

where is scenario

execute command1 --->execute command 2----->execute command 3 these are in sequence 1 then sequence 2 is trigger by sequence 1 OK condition

What happen right now is even if execute command 2 fails i don't see any warning or abort message in sequence 1 as it is not generating one.

chulett · Post by **chulett** » Tue Mar 12, 2013 7:26 pm

You need to check the return status between the Execute Command stages and decide what to do if they "fail". What is your trigger expression? Or at least answer Ray's questions.

prasannakumarkk · Post by **prasannakumarkk** » Tue Mar 12, 2013 11:19 pm

Can you please confrim what is happening in the script that you have posted?

ssh -i /aa/oracle/.ssh/rsa_cognos10_dsadmin test pfexec /ee/c10_cubes/script/Capital.sh

set vReturnStatus = $status

exit $vReturnStatus

1) $status - Will it have the return value or exit value of the previous executed command/script. In most of scripting we use $?

2) Return code 127 is for command/script not found. Debug the script please. If your script gives a proper exit DS will fail.

times29 · Post by **times29** » Wed Mar 13, 2013 6:23 am

i want somethimg like below in return trigger who can i rewrite it in trigger.

If vRtnCode <> 0 or ISNULL(vRtnCode) = 1 Then vErrCode = DSLogEvent (DSJ.ME, DSJ.LOGWARNING, "Script completed with a non-zero valued return code:" : vRtnCode) end

times29 · Post by **times29** » Wed Mar 13, 2013 6:42 am

I am doing custom trigger now still not getting warning and yes
automatic error handling is enabled in the sequence

if Build_Cube_Quarter.$ReturnValue <>0 then JOBSTATUS =2 else JOBSTATUS =1

Reply=127
Output from command ====>
/db01/c10_cubes/script/DSFINBUILD_Quarter.sh: line 2: -: command not found

chulett · Post by **chulett** » Wed Mar 13, 2013 7:09 am

You cannot set any sort of "job status" in the trigger. However, you can check $ReturnValue <>0 and branch to a Terminator to abort the Sequence if that's what you want.

priyadarshikunal · Post by **priyadarshikunal** » Thu Mar 14, 2013 3:06 pm

In sequence there should be a option to "Log warning for the steps failed other than OK" or similar. If that option is checked, then if the return value is not 0 from the command, a warning will be logged for execute command stage.

However I support the method of handling the return values in trigger expression and have a control over the jobs fate.