Timeout Exception in tsalesforceinput component

[mani1304]

,

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.

[TRF · Accepted solution]

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

[mani1304]

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.

[TRF]

What if you try the query within the developer console?

[mani1304]

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