Unhandled failure (1) encountered calling routine DSU.Execu
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
Unhandled failure (1) encountered calling routine DSU.Execu
Hi All,
When i try to execute the sh script using the DSU.ExecuteScript routine, Its aborted.
Error message
JobControl (@removeInputFiles): Controller problem: Unhandled failure (1) encountered calling routine DSU.ExecuteScript
Can some one please respond for it.
Regards Magesh
When i try to execute the sh script using the DSU.ExecuteScript routine, Its aborted.
Error message
JobControl (@removeInputFiles): Controller problem: Unhandled failure (1) encountered calling routine DSU.ExecuteScript
Can some one please respond for it.
Regards Magesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your ExecuteScript routine is returning the value 1.
Presumably somewhere in the routine the statement Ans = 1 exists, and is being executed in this case.
Conventionally a non-zero exit status in UNIX/Windows indicates other than a successful completion. DataStage extends this convention to the value returned by routines.
Find out why your routine is executing an eAns = 1 statement and you will probably have solved this problem.
Or handle it in your job control code (a custom trigger on the Routine activity is suggested).
Presumably somewhere in the routine the statement Ans = 1 exists, and is being executed in this case.
Conventionally a non-zero exit status in UNIX/Windows indicates other than a successful completion. DataStage extends this convention to the value returned by routines.
Find out why your routine is executing an eAns = 1 statement and you will probably have solved this problem.
Or handle it in your job control code (a custom trigger on the Routine activity is suggested).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
"DSU.ExecuteScript" is a user-written DataStage BASIC routine. Since someone at your site wrote it and you didn't post the code, you will have little chance of getting a solution as it stands.
Since you posted this as a PX problem, the routine in question can ony be a before- or after- subroutine.
Since you posted this as a PX problem, the routine in question can ony be a before- or after- subroutine.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
What is "the access problem"?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
WHAT "sh file"? We're talking about a DataStage routine here.
Because you have not posted that code, we can not determine where the return value of 1 is coming from. Therefore, in light of that unwillingness, YOU have to be the detective.
Because you have not posted that code, we can not determine where the return value of 1 is coming from. Therefore, in light of that unwillingness, YOU have to be the detective.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I don't see the need to see any code. You've got a Sequence job with a Routine Activity stage that returns a non-zero value and when 'automatically handle' is enabled without the proper triggers that is considered 'unhandled' and the job aborts. All documented in the online help and discussed here ad nauseum.
Searching the forums for a generic portion of the error - "Controller problem: Unhandled failure" for example - will reveal those conversations.
Searching the forums for a generic portion of the error - "Controller problem: Unhandled failure" for example - will reveal those conversations.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers