topic Re: Timeout Exception in tsalesforceinput component in Talend Studio

Timeout Exception in tsalesforceinput component

mani1304 — Sat, 16 Nov 2024 02:47:45 GMT

I am facing below error while fetching huge number of records like 5+ million from tsalesforceinput component.

java.io.IOException: [UnexpectedErrorFault [ApiFault exceptionCode='QUERY_TIMEOUT'
exceptionMessage='Your query request was running for too long.'
extendedErrorDetails='{[0]}'
]

I increased Batchsize to 2000 and timeout to 600,000 it ran fine first time but after that again failing throwing above error, while I need to put batchsize to 500 and timeout to 60,000. Can someone suggest on how to get this.

Re: Timeout Exception in tsalesforceinput component

TRF — Fri, 03 Apr 2020 16:47:48 GMT

Try with the tSalesforceInput "Query Mode" option set to "Bulk" (and a bulk connection)

Re: Timeout Exception in tsalesforceinput component

mani1304 — Mon, 06 Apr 2020 18:04:45 GMT

Thanks but I tried it earlier and it's throwing InvalidBatch error, so switched back to Query mode and also it doesn't have Batch size, so can you suggest how to achieve it because I am thinking to try this again.

Re: Timeout Exception in tsalesforceinput component

TRF — Tue, 07 Apr 2020 07:59:01 GMT

What if you try the query within the developer console?

Re: Timeout Exception in tsalesforceinput component

mani1304 — Thu, 14 May 2020 08:27:30 GMT

I used bulk component and till now not faced any issues.