Hi,
I have a sequencer which triggers one Job, say 1st, if the 1st Job run successfully then runs the 2nd Job. If 1st Job fails then rerun 1st Job, lets call it 3rd Job. On completion of 3rd Job, 4th Job has to be triggered unconditionally.
|--------| |-----------|
|1stJob |-------Uncondtional-----| 2nd Job |
|--------| |-----------|
|
|
On Abort
|
|
|----------| |----------|
| 3rd Job |-----unconditional-----| 4th Job |
|----------| |----------|
This is the Sequencer and the Jobs (1st,2nd ..) are parallel Job.
This sequencer is giving warning
SS_Odh_Src_Stg_CustomerNodeHistory..JobControl (@RerunDtsStgCustomerNodeHistory): Controller problem: Unhandled abort encountered in job PJ_Odh_Dts_Stg_CustomerNodeHistory
And then Aborting
SS_Odh_Src_Stg_CustomerNodeHistory..JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors
The problem is 4th Job is not at all getting triggered though 1st Job has aborted and triggered 3rd Job
I am unable to understand the Problem.
Need help
Controller problem: Unhandled abort encountered in job
Moderators: chulett, rschirm, roy
Controller problem: Unhandled abort encountered in job
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 82
- Joined: Thu Dec 02, 2004 10:27 pm
- Location: INDIA
No, I don't have any exception handler.
3rd Job and 1st Job are same. Only thing is, the client want rerun functionality on abort. So 1st Job if aborted is again reset and run as 3rd Job. 2nd and 4th Job are also same but multiinstance and 2nd and 4th job run with Different Instance Numbers (Invocation Id).
3rd Job and 1st Job are same. Only thing is, the client want rerun functionality on abort. So 1st Job if aborted is again reset and run as 3rd Job. 2nd and 4th Job are also same but multiinstance and 2nd and 4th job run with Different Instance Numbers (Invocation Id).
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Try the following steps
1.) As job1 and job3 are same with different invocation id, copy job1 as job5 and replace it in your sequencer in place of job3.
2.) Attach an exception stage with a dsloginfo of job status
3.) Attach a routine to job3 as 'Otherwise' condition to display the jobstatus of job3.
1.) As job1 and job3 are same with different invocation id, copy job1 as job5 and replace it in your sequencer in place of job3.
2.) Attach an exception stage with a dsloginfo of job status
3.) Attach a routine to job3 as 'Otherwise' condition to display the jobstatus of job3.
Job1 and Job3 are not with different Invocation Id.
Job1 and Job3 are same single Parallel Job. It is not a multi-instance Job. The same Job is executed twice in case of 1st run Failure.
Any way, will try what you have suggested and get back.
Job1 and Job3 are same single Parallel Job. It is not a multi-instance Job. The same Job is executed twice in case of 1st run Failure.
Any way, will try what you have suggested and get back.
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.