DSXchange

Hi,

I see ORA-00904 as a warning in my server job, also the job completed successfully. This is strange, ideally the job should fail because of oracle error.

Thanks,
Vishal Gupta

Not for warnings unless they exceed your runtime Warning Limit. Look for an option in the stage to 'treat warnings as fatal' if that's the behaviour you want.

The strange thing is ds is shoeing it as warning, however it should be fatal error. I could not find anything in stage properties for this kinda settings.

What stage are you using?

We routinely ran our Server jobs with a warning limit of 1 as they should never have any warnings... as noted, that would be another option.