topic Re: Exception in tsalesforceInput component in Data Quality

Exception in tsalesforceInput component

MZein — Sat, 16 Nov 2024 02:10:36 GMT

Hi all

I have a subjob that contains TSalesforceInput----->tMap------

after reading 424000 row de salesforce object I got the error

Exception in component tSalesforceInput_1
java.io.IOException: com.sforce.ws.ConnectionException: Failed to send request to https://eu26.salesforce.com/services/Soap/u/44.0/00DD0000000Cli7

Is there any idea for this error. Note there where no proxy in the network

Re: Exception in tsalesforceInput component

manodwhb — Thu, 11 Jun 2020 10:23:14 GMT

@MZein ,check the below link may help.

https://community.talend.com/t5/Design-and-Development/com-sforce-ws-ConnectionException-Failed-to-send-request-to/td-p/145633

Re: Exception in tsalesforceInput component

MZein — Thu, 11 Jun 2020 12:02:21 GMT

Thank you very much @manodwhb

I already saw this post and it is not my case as my job run and I successfully getting 425000 row from Salesfoce and after that either I got the exception message (mentioned in my post) or the job halted (rest without getting more rows)

Any one have un idea for this urgent problem

regards

Re: Exception in tsalesforceInput component

manodwhb — Thu, 11 Jun 2020 12:41:07 GMT

@MZein ,can you try to increase Timeeout in the advanced settings of tsalesforceInput and check?

Re: Exception in tsalesforceInput component

MZein — Fri, 12 Jun 2020 14:03:14 GMT

Thank you @manodwhb

I solve the problem by selecting bulk query as I have query inside tSalesforceInput component. So when I select bulk query the job runtime also largely improved

Thank you again @manodwhb