topic Catch the Errors in Talend Studio

Catch the Errors

med1 — Mon, 04 Dec 2017 13:42:20 GMT

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.BatchUpdateExceptionRA-00001....

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

thanks,

BR,

Med

Re: Catch the Errors

Théo_Cap — Mon, 04 Dec 2017 14:00:29 GMT

Hi,

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

Re: Catch the Errors

med1 — Mon, 04 Dec 2017 14:25:54 GMT

But in our politic we use the batch parameters.

im looking now for the variable which contains the error.

Re: Catch the Errors

Anonymous — Wed, 06 Dec 2017 02:49:52 GMT

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

Re: Catch the Errors

med1 — Wed, 06 Dec 2017 08:09:46 GMT

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,

Re: Catch the Errors

Anonymous — Thu, 07 Dec 2017 07:54:34 GMT

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