tRestClient tiemout causing a "failure" log

Six Stars

tRestClient tiemout causing a "failure" log

Hi all,
I have a request on the component tRestClient.

In my job I'm calling a Rest/POST that execute a stored procedure on a certain DB.
This procedure takes a couple of minutes to execute, and it seems like it does not give a response back to the TALEND Job (maybe for a timeout or similar).

If I check in the STAT table on the db I see that the execution of this specific sub-job is indicated as failed, but the procedure has been executed correctly without any issue.

How can I avoid this failure? As I have a monitoring on the stat table I need that the execution is traced in the right way.

Thank you in advance for your help.

Highlighted
Ten Stars

Re: tRestClient tiemout causing a "failure" log

Im not an exp
You make a tRESTClient call, but does it return immediately or waits and ends with a timeout?
And the db-procedure takes a couple of minutes, right? so you want to wait and keep the websession open?

Probably you need a GET call to check the status of the procedure.
Or need to define it in your stored procedure to return a value, if its not defined yet it probably wont send any information back.

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now