Don't get warning message for execute command
Moderators: chulett, rschirm, roy
Don't get warning message for execute command
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
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
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
Can you please confrim what is happening in the script that you have posted?
2) Return code 127 is for command/script not found. Debug the script please. If your script gives a proper exit DS will fail.
1) $status - Will it have the return value or exit value of the previous executed command/script. In most of scripting we use $?ssh -i /aa/oracle/.ssh/rsa_cognos10_dsadmin test pfexec /ee/c10_cubes/script/Capital.sh
set vReturnStatus = $status
exit $vReturnStatus
2) Return code 127 is for command/script not found. Debug the script please. If your script gives a proper exit DS will fail.
Thanks,
Prasanna
Prasanna
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
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
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
However I support the method of handling the return values in trigger expression and have a control over the jobs fate.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.