topic Re: persistent timeout error while executing salesforce query using tSalesforceInput in Talend Studio

persistent timeout error while executing salesforce query using tSalesforceInput

Learner13 — Fri, 15 Nov 2024 23:53:52 GMT

I am executing a simple salesforce query that should return over 10 million records. I am getting timeout after few hours of execution. Earlier it ran completely in about 6 hours through talend. I am creating standard salesforce connection with api version 37.0.

java.io.IOException: com.sforce.ws.ConnectionException: Request to

https://test.salesforce.com/services/Soap/u/37.0/

timed out. TimeTaken=19402 ConnectionTimeout=6000000 ReadTimeout=0

Re: persistent timeout error while executing salesforce query using tSalesforceInput

Anonymous — Tue, 10 Aug 2021 10:11:35 GMT

Is it a standard object or custom object? I have the same timeout error for retrieving one of community object, I have seen many topics about this error asked on internet. I resolved it by increasing the Timeout value on the advanced setting panel of tSalesforInput and adding filter conditions in the Condition field.

Regards

Shong

Re: persistent timeout error while executing salesforce query using tSalesforceInput

Learner13 — Tue, 10 Aug 2021 10:23:14 GMT

Thanks for your reply @Shicong Hong.

It is the standard object and I tried with increasing the timeout in advanced settings but no help. Job is failing with timeout error way before the timeout I have set.

Re: persistent timeout error while executing salesforce query using tSalesforceInput

Anonymous — Wed, 11 Aug 2021 05:54:41 GMT

@Barkha Pal

I would suggest you to try:

Try to add condition to reduce the number of returned records.
Search the same error about the object you are retrieving on internet or salesforce forum to see you could find a useful clue, because I feel that this error is more related to the salesforce object.

Regards

Shong