Error in Execute Command Activity

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Error in Execute Command Activity

Post by ravij »

Hi,

I have a Sequence S1 which has J1, J2, J3, J4 jobs. J3 is my Execute Command activity which will run script. Now my Job Seuence S1 got aborted and the error log is
16:05:22: Execute_Del_DS (COMMAND sh -x) started
16:05:22: Execute_Del_DS finished, reply=1
16:05:22: Stop_Run Executed
16:05:22: Sequence terminated
In the Command field I gave sh -x and
in the Parameter field I gave cd #path#/filename.sh

I didn't get any error message except the above one about this error.

what could be the problem. Plese help me to solve this issue.

Thanks in advance.
Ravi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no problem. The job sequence has executed exactly as you programmed it to. Because the Execute Command activity's command returned a non-zero exit status, automatic handling of activities that fail has kicked in and aborted the job sequence, in the absence of any explicit failure handling or Exception Handler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
baglasumit21
Participant
Posts: 132
Joined: Wed Mar 01, 2006 11:12 pm
Location: Pune

Re: Error in Execute Command Activity

Post by baglasumit21 »

ravij wrote:Hi,

I have a Sequence S1 which has J1, J2, J3, J4 jobs. J3 is my Execute Command activity which will run script. Now my Job Seuence S1 got aborted and the error log is
16:05:22: Execute_Del_DS (COMMAND sh -x) started
16:05:22: Execute_Del_DS finished, reply=1
16:05:22: Stop_Run Executed
16:05:22: Sequence terminated
In the Command field I gave sh -x and
in the Parameter field I gave cd #path#/filename.sh

I didn't get any error message except the above one about this error.

what could be the problem. Plese help me to solve this issue.

Thanks in advance.
Hi Ravi,
Can you post your problem more clearly. What I can say currently is that if you want to run a script file abc.sh at path #path# which is supplied by parameter then you need to specify as #path#abc.sh

The parameter field is to supply the parameter to the script file.
For eg. if your abc.sh file takes parameter as userid and password then in the parameter field you need to specify
userid password
SMB
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

Post by ravij »

Hi,

I got some more information in Log i.e.
JS_XXX..JobControl (@Execute_Del_DS): Executed: sh -x cd /home/dsadm/monthly_churn/cs8_basedump_rem.sh
Reply=1
Output from command ====>
+ + /usr/bin/basename cd
command=cd
+ [ cd = type ]
+ [ cd = hash ]
+ cd /home/dsadm/abc/cs8_basedump_rem.sh
cd[53]: /home/dsadm/abc/cs8_basedump_rem.sh: 0403-037 The specified path name is not a directory.
I tried running this script with same command at UNIX prompt there also its giving same error as given above..

Any solution for this?
Your help is appreciated..
Ravi
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

try not to "cd" to a shell script, but to the directory where the shell script is located, i.e. "cd /home/dsadm/abc"
Post Reply