DataStage Job not aborting despite ORA-01652 error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
asingh
Premium Member
Premium Member
Posts: 46
Joined: Sun Jan 28, 2007 5:31 pm
Location: Sydney

DataStage Job not aborting despite ORA-01652 error

Post by asingh »

We have discovered a issue with DataStage jobs when an "ORA-01652: unable to extend temp space" error occurs during a select statement.
The issue is not regarding the Oracle error as it was found that the table statistics were stale rather it was that the DataStage job continued processing and finished with an 'OK' status hence allowing subsequent jobs in the calling sequence to run. This issue was only picked up in Development however if the jobs does not abort the error will be difficult to pick up once in Production.

Is there a config setting that needs to be enabled to make the DataSatge job fail for this kind of Oracle error?
Post Reply