ABORT raised when attempting to execute routine... sometimes

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pnpmarques
Participant
Posts: 35
Joined: Wed Jun 15, 2005 9:27 am

ABORT raised when attempting to execute routine... sometimes

Post by pnpmarques »

Hello,
In my sequence I have a routine activity which goal is to search for a specific string in job log entries using "dsjob -logdetail..." command.
Sometimes, in testing environment, the sequence ends with only the follownig error message:
Attempting to Cleanup after ABORT raised in job <jobname>..JobControl

Our suggestion to Datastage administrator has always been importing routine again and compile sequence, which worked, but we are afraid these situations will happen again for no apparent reason.

Has anyone experienced this before?

Best regards.
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Please post the entire messages you are getting.
pandeeswaran
pnpmarques
Participant
Posts: 35
Joined: Wed Jun 15, 2005 9:27 am

Post by pnpmarques »

(...)
<sequence_job>..JobControl (DSWaitForJob): Job <parallel_job> has finished, status = 1 (Finished OK)
<sequence_job>..JobControl (@Job_15): Checkpointed run of job <parallel_job>
Attempting to Cleanup after ABORT raised in job <sequence_job>..JobControl
(<sequence_job>) <- <sequence_job>: Job under control finished.

That's it, no information at all.
Next step is the routine activity I mentioned before. It's odd that I have to compile this routine so that the sequence finishes ok.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If you reset the aborted job, is there a "From previous run..." message added to the log? If so, please post the contents.
-craig

"You can never have too many knives" -- Logan Nine Fingers
pnpmarques
Participant
Posts: 35
Joined: Wed Jun 15, 2005 9:27 am

Post by pnpmarques »

Finally I got it:
From previous run
DataStage Job 675 Phantom 538
Program "DSRunJob": Line 403, Variable "TempName" previously undefined. Empty string used.
Subroutine "DSU.RtSearchStringInJobLog" called with 3 arguments, 0 were expected"
Program "JOB.1188344055.DT.1592358232": Line 1144, Unable to load subroutine.
Attempting to Cleanup after ABORT raised in job <job_name>..JobControl

DataStage Phantom Aborting with @ABORT.CODE = 3

I found this information:
http://www-01.ibm.com/support/docview.w ... wg1JR39860

I am going to test if declaring this variable in the routine is the solution.
pnpmarques
Participant
Posts: 35
Joined: Wed Jun 15, 2005 9:27 am

Post by pnpmarques »

So far it has been running good. I am declaring this topic as Resolved.
Post Reply