Job is successful even after oracle error

vishu19aug · Post by **vishu19aug** » Wed Feb 05, 2014 4:46 pm

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

chulett · Post by **chulett** » Wed Feb 05, 2014 4:51 pm

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.

vishu19aug · Post by **vishu19aug** » Wed Feb 05, 2014 7:05 pm

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.

chulett · Post by **chulett** » Wed Feb 05, 2014 11:54 pm

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.