Hello friends...
Can we Avoid the Job Abort state even after getting fatal error while processing any Row?
Actually,i want my job to process all the rows.Now my job get abort/stop when 3 or 4 fatal errors occured.But i want that the job should proceed after any fatal error also...
Please guide me how to acheive this!!
Thanx
Avoid 'Run Stop' even on fatal Error
Moderators: chulett, rschirm, roy
Avoid 'Run Stop' even on fatal Error
Arun Verma
-
keshav0307
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Mr Verma
As per my opinion, there are some reason reason of the fatal error, you can not simply continue even if there is fatal error.;
e.g. if the fatal error is bcoz of some design issue, how can you expect the job still to continue all the row to process....
but you can still continue with proper handling the data at the the kind of stages you are using...
i would also like to know, if there is any way to achieve this.
As per my opinion, there are some reason reason of the fatal error, you can not simply continue even if there is fatal error.;
e.g. if the fatal error is bcoz of some design issue, how can you expect the job still to continue all the row to process....
but you can still continue with proper handling the data at the the kind of stages you are using...
i would also like to know, if there is any way to achieve this.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is ALWAYS a way in server jobs to run without creating fatal errors from the job design, if you are not using row buffering. I include that caveat (a) because you do not have control of the ipc mechanism and (b) because theverma seems infatuated with using the IPC stage.
Environmental fatal errors, such as inability to connect to data sources, are not part of the job design and should, of course, remain fatal errors.
Environmental fatal errors, such as inability to connect to data sources, are not part of the job design and should, of course, remain fatal errors.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.