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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.