Oracle warnings not appearing in job log

NigeGriff · Post by **NigeGriff** » Fri Oct 09, 2009 3:52 am

In server edition oracle warnings generated warnings in the director job log. The job could then be configured so that 'X' many warnings would cause the job to abend.

Oracle warnings do not seem to generate job warnings in enterprise oracle stage.

Is there a way to force the job to abend if a certain number of oracle warnings are generated by the oracle stage?

ShaneMuir · Post by **ShaneMuir** » Fri Oct 09, 2009 4:10 am

What sort of load are you doing? Upsert or Bulk Load?

I am pretty sure an Upsert gives warnings, but a bulk load doesn't.
I am not even sure if a bulk load will write to a reject link.

NigeGriff · Post by **NigeGriff** » Mon Oct 12, 2009 3:48 am

The oracle stage is performing an upsert.

No warnings appear in the job log but when a peek stage is configured to capture rejected records on the oracle stage, oracle warnings appear in the job log as peek output but not as job warnings.