Batch execution does not receive a response

Six Stars

Batch execution does not receive a response

Hello,
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. 

Employee

Re: Batch execution does not receive a response

Hi,

 

     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


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.