I have one requirement in ODI, If Load plans abort it should trigger a mail with the proper ODI error message. For that i have created one load plan with exception if load plan fails it will call the exception and in Exception i have added scenario of procedure in which i have used one variable which is responsible for fetching the ODI ERROR message and linked with OdiSendMail Function , but when i am running a load plan mail is getting triggered but without error message but when i am running a only procedure i am getting a mail with proper ODI Error message.
Can you please let me know why I am not getting a mail with proper ODI error message when I am running a load plan?