Skip to Main Content

Exception handling in ODI Load Plan not working

user12251389Oct 19 2021 — edited Oct 19 2021

I have package where i have grouped mappings and try to run them sequentially. This package is without notification.
I have created another package where i want to generate beep when exception occured. This package is with notification.
The variable Session_ID has below query:
SELECT <%=odiRef.getSession("SESS_NO")%> FROM dual
I have generated scenario based on both this packages.
When i run load plan, the process is getting stopped as soon as it receives exception in package for second mapping. I want to continue my process and run all the mappings in package even if the exception occured.
I dont know what step i am doing wrong.