Catch the Errors

Seven Stars med
Seven Stars

Catch the Errors

Hello community,

 

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.BatchUpdateExceptionSmiley SurprisedRA-00001....

 

I think there is variable which contains this error. Do you have any idea ?

 

thanks,

BR,

Med

 

 

Highlighted
Six Stars

Re: Catch the Errors

Hi,

In your advanced parameter of the output component try to desactivate: "use btach size" option .

 

 

Seven Stars med
Seven Stars

Re: Catch the Errors

 

But in our politic we use the batch parameters.

 

im looking now for the variable which contains the error.

Moderator

Re: Catch the Errors

Hello,

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.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars med
Seven Stars

Re: Catch the Errors

Hello,

 

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.

 

So i found the solution by adding the oracleoutput between two tJavascript and i catch the error.

 

Thanks,

BR

Moderator

Re: Catch the Errors

Hello,

Thanks for sharing your solution with us on forum.

Have you tried to use tLogCatcher to fetch messages from Java Exception?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog