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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend