Warning in parallel job causes loss of data
Posted: Tue Apr 08, 2008 7:16 am
Hi guys
We are looking into parallel jobs but have met the following scenario:
Warning Limit = 1
When a warning pops up in one of the threads in the job,
this message is seen:
Issuing abort after 1 warnings logged.
but the remaining threads just keeps loading data.
At the end the job finishes with following messages:
Parallel job reports successful completion
Job completed before it could be aborted. !!!
I have warninglimit = 1 for a reason, so what is happening here?
The problem is generelly spoken a risc in all our jobs so I need one solution to cover the whole, not one solution for file stages, another for ODBC and a third for Oracle.
Anyone seen this before, and how did you manage it??
Rgds Jan
We are looking into parallel jobs but have met the following scenario:
Warning Limit = 1
When a warning pops up in one of the threads in the job,
this message is seen:
Issuing abort after 1 warnings logged.
but the remaining threads just keeps loading data.
At the end the job finishes with following messages:
Parallel job reports successful completion
Job completed before it could be aborted. !!!
I have warninglimit = 1 for a reason, so what is happening here?
The problem is generelly spoken a risc in all our jobs so I need one solution to cover the whole, not one solution for file stages, another for ODBC and a third for Oracle.
Anyone seen this before, and how did you manage it??
Rgds Jan