I have a problem with catching errors. I have tOracleOuptut component and i want to catch the errors of the execution.
I deactivate the Die en error option because i want job to end normally (code 0).
I executed the job and i get this error : java.sql.BatchUpdateExceptionRA-00001....
I think there is variable which contains this error. Do you have any idea ?
Here is a global variable ((String)globalMap.get("tOracleOutput_1_ERROR_MESSAGE")) in tOracleOutput component.
To access the global variable list, press Ctrl + Space bar on your keyboard and select the relevant global parameter.
In fact when you unchecked the Die on error option the variable ((String)globalMap.get("tOracleOutput_1_ERROR_MESSAGE")) dont receive any value and still null.
Thanks for sharing your solution with us on forum.
Have you tried to use tLogCatcher to fetch messages from Java Exception?