Batch execution does not receive a response

Six Stars

Batch execution does not receive a response

I have a Job scheduled on a windows machine that execute every day at the same time.

This job simply use a tRestClient Component to execute a stored procedure on my oracle db through the connection to the Application Express.

The procedure is beign executed correctly and everything works properly, the issue is that as the procedure takes some minutes to execute, the talend job lose the control on the execution and the batch that is beign executed is not closing. 

So in general the execution of the batch is not stopped... How can I solve this issue? I have already tried to set the timeout of the tRestClient component but it does not work.

Thank you in advance for your help. 


Re: Batch execution does not receive a response



     There seems to be multiple issues in this flow. You are specifying that your job executes at a specific time everyday. So it is a batch job. In a batch job, could you please advise why you are using a tRestClient to call a Oracle stored procedure?


     Have you tried to integrate the stored procedure with the Talend components directly? Now if the stored procedure is a part of a standard packaged application, then we will have to see why the procedure is taking so long time. What is the normal expected time of completion and it is supposed to run for several minutes?


     If you could share the screenshots of the jobs, it would be easier to analyse the flow and issue. Please also share the component screenshot of the problematic component (where you are making the call to procedure).


Warm Regards,


Nikhil Thampi


Talend named a Leader.

Get your copy


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


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now