A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
Developer9
Premium Member
Posts: 187 Joined: Thu Apr 14, 2011 5:10 pm
Post
by Developer9 » Thu Mar 26, 2015 12:51 pm
Hi,
I got the following error message and sequencer is getting aborted .jobs are not triggered
Code: Select all
Attempting to Cleanup after ABORT raised in job SEQ010_MASTER..JobControl
Job SEQ010_MASTER aborted.
Made a copy of this sequencer and re-compiled all jobs and the Sequencer ..But still the jobs are not triggered.
Please help me with the identifying the issue
Thank you
oracledba
Premium Member
Posts: 49 Joined: Mon Aug 06, 2012 9:21 am
Post
by oracledba » Thu Mar 26, 2015 12:57 pm
this is the sequence job error. Post the abort message from the parallel job. Master failed because one of the jobs it is calling is aborting.
Developer9
Premium Member
Posts: 187 Joined: Thu Apr 14, 2011 5:10 pm
Post
by Developer9 » Thu Mar 26, 2015 1:24 pm
@oracledba,
Below is the design in my Sequencer for three 3 jobs
Code: Select all
JobAcvtivity 1 >UVActivity>JA2 >JA3 >Notification Activity
JA1 is used for generating DATE and using in UVA is input for JA2
Message
Code: Select all
SEQ010_MASTER..JobControl (DSWaitForJob): JA1 1 has finished, status = 1 (Finished OK)
SEQ010_MASTER..JobControl (@JA1): Checkpointed run of job 'JA1'
Now the Sequencer is aborting after the JA1 (job1) execution itself without triggering job2 and job3.
Hope this information is clear to find out the issue
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Mar 26, 2015 1:27 pm
<split / moved to your own post>
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Mar 26, 2015 3:56 pm
There's no other information in the job logs, either of the sequence itself or of JA1 or JA2?
Please note: it's SEQUENCE, not Sequencer. A Sequencer is something that you can use in a Sequence.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Developer9
Premium Member
Posts: 187 Joined: Thu Apr 14, 2011 5:10 pm
Post
by Developer9 » Fri Mar 27, 2015 9:47 am
@ray,
Thanks for the correction
..Job log doesn't have any additional messages
I know its hard to some one to suggest with our proper information ..I will update with any findings
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Mar 27, 2015 10:20 am
Developer9 wrote: Now the Sequencer is aborting after the JA1 (job1) execution itself without triggering job2 and job3.
So the information you'll need should be in the Sequence's log and should also mean it is either a problem with the User Variables stage or the inability to find/start JA2. If you're not sure what all of the messages mean, post them here.
I'd also be curious what options you have enabled in the sequence job, obviously checkpoints but what others - the 'automatically handle' one? Also let us know what your trigger expressions are between the stages.
-craig
"You can never have too many knives" -- Logan Nine Fingers