Automatic reset of Parallel Job
Moderators: chulett, rschirm, roy
Automatic reset of Parallel Job
Hi,
I need to know if a aborted job can be reset automatically via script/reset job(if any).
I have a sequence scheduled to run daily. But certain jobs aborts due to lack of resources and once its reset and the sequence is re-started, it runs fine.
Since the abort is frequent, I need to know if I can reset the job automatically via a script. Also let me know if I can access the status of the job automatically.
Thanks in advance,
Divya
I need to know if a aborted job can be reset automatically via script/reset job(if any).
I have a sequence scheduled to run daily. But certain jobs aborts due to lack of resources and once its reset and the sequence is re-started, it runs fine.
Since the abort is frequent, I need to know if I can reset the job automatically via a script. Also let me know if I can access the status of the job automatically.
Thanks in advance,
Divya
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
-
- 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
Here are some of the frequent errros which we face:
a.Fatal Error: waitForWriteSignal(): Premature EOF on node etlprd3 No such file or directory
b.main_program: ORCHESTRATE step execution terminating due to SIGINT
c.Fatal Error: Tsort merger aborting: Scratch space full
d.Fatal Error: Unable to allocate communication resources
All the above errors aborts the job. But once the job is reset and run, its running fine.
Regards,
Divya
a.Fatal Error: waitForWriteSignal(): Premature EOF on node etlprd3 No such file or directory
b.main_program: ORCHESTRATE step execution terminating due to SIGINT
c.Fatal Error: Tsort merger aborting: Scratch space full
d.Fatal Error: Unable to allocate communication resources
All the above errors aborts the job. But once the job is reset and run, its running fine.
Regards,
Divya
-
- 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
No, I dont do any pre-sorting. The job is something like this,
sequential file 1 ---> Oracle Enterprise 1
Change_capture--->Filter--->
sequential file 2 ---> Oracle Enterprise 2
I dont know where exactly I get the error. Mostly it occurs even before the import from input files are done.
Regards,
Divya
sequential file 1 ---> Oracle Enterprise 1
Change_capture--->Filter--->
sequential file 2 ---> Oracle Enterprise 2
I dont know where exactly I get the error. Mostly it occurs even before the import from input files are done.
Regards,
Divya