Analytics Software

HI,

I am using below command- which is actually an input for therd party schedular (Dollar Universe $U).

D:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\agent\bin\startscen "PKG_POZ_BOSS_OMP_BSMASTERSTOCK" "-1" "TEST" "-NAME=btvmd79_odi_agent"

$U scheduler t is a product developed by ORSYP (French company) www.orsyp.com

Requirement in details:
$U does accept return codes, however, it seems that ODI is sending back “return code 0” when the PKG fails, which is understood by $U as “all OK”, the idea would be to have a different return code when the PKG fails (I am just rep-phrasing the original statement).

Now in package execution is as below.
interfaces execution -> if KO calling a procedure for writing email contents which are to be sent

as per my understandings,

I've noticed a different thing, when a pkg or a scenario ends with an error, the return code it send to OS is always 88.

i've also noticed that if the last step goes well the scenario ends in OK state,
even if another object before the last one return an error.

so if you have an object that sends an email in case of KO the scenario will end in error only if the sending goes in error.

to avoid this we've used a procedure as the last one in case of ko
that contains a java beanshell command,

throw new Exception("ErrorMessage")
but i am not geting details of how could i throw exception?
can someone help me please.

Thanks,
Mahesh