persistent timeout error while executing salesforce query using tSalesforceInput

[Learner13]

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

[Anonymous]

Hi

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

[Learner13]

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.

[Anonymous]

@Barkha Pal​ 

I would suggest you to try:

1. Try to add condition to reduce the number of returned records.
2. 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