topic Re: Exception in component tSalesforceInput_2 java.net.SocketException: Connection reset in Talend Studio

Exception in component tSalesforceInput_2 java.net.SocketException: Connection reset

Anonymous — Sat, 16 Nov 2024 06:23:15 GMT

I am getting below error when performing bulk operation ...please suggest solution for this

Error :

Exception in component tSalesforceInput_2 (LDVMigration)
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at sun.security.ssl.InputRecord.readFully(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
at sun.security.ssl.AppInputStream.read(Unknown Source)
at java.io.BufferedInputStream.read1(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at sun.net.www.http.ChunkedInputStream.fastRead(Unknown Source)
at sun.net.www.http.ChunkedInputStream.read(Unknown Source)
at java.io.FilterInputStream.read(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(Unknown Source)

Re: Exception in component tSalesforceInput_2 java.net.SocketException: Connection reset

Anonymous — Fri, 08 Mar 2019 11:30:25 GMT

Hi,

Could you please refer the details of PK Chunking in Salesforce help document?

https://help.talend.com/reader/nR_huYVmZw4f~cGht7mCqw/fIkIpigGR99KVEyIDbxZ~g

I am not an authority over Salesforce. So let us wait for others also to respond.

@klokala - Any thoughts?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Exception in component tSalesforceInput_2 java.net.SocketException: Connection reset

vatsal_ras — Fri, 22 Mar 2019 10:35:22 GMT

This is a bug in talend when we use "PK chunking" option.

I will recommend you to try without it. Uncheck the option.

If you get a query time out please try to optimize the query.