Fatal Errors

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Fatal Errors

Post by admin »

Is there a way to prevent a job from aborting in Director when it receives a fatal error such as the one below?? Ive researched the data and there may be 1-2 occurrences in 50,000 records and it slows the job down drastically to code around it. The data is bogus and it is ok for the job to skip over it and continue running.

PatientOrderProfileORAREF.PhysicianOrderNumReference:
ORA-01460: unimplemented or unreasonable conversion requested

Thanks
Lisa
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Lisa,

Could you post more details with your questions, please. In such a general scenario as this, for example, it is hard to guess what kind of reject constraint would cause a job to slow "drastically." The folks will be better able to help if you give us the data examples and the code you tried that caused the performance problem.

Regards,

Clif


Monday, October 22, 2001, 2:56:16 PM, lhamilto@ncshealth.com wrote:



> Is there a way to prevent a job from aborting in Director when it
> receives a fatal error such as the one below?? Ive researched the
> data and there may be 1-2 occurrences in 50,000 records and it slows
> the job down drastically to code around it. The data is bogus and it
> is ok for the job to skip over it and continue running.

> PatientOrderProfileORAREF.PhysicianOrderNumReference:
> ORA-01460: unimplemented or unreasonable conversion requested

> Thanks
> Lisa
Locked