topic tSalesforceInput SSL peer shut down incorrectly in Talend Studio

tSalesforceInput SSL peer shut down incorrectly

cvboas — Wed, 05 Jun 2024 11:58:10 GMT

I have a job that connects to extract the data from several objects from salesforce.

I use tsalesforceinput to extract the data and then insert into a mssql db. the job return this error with some objects but others work without problem.

tSalesforceInput_2 SSL peer shut down incorrectly
javax.net.ssl.SSLException: SSL peer shut down incorrectly
at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:596) ~[?:1.8.0_252]
at sun.security.ssl.InputRecord.read(InputRecord.java:532) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:990) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:948) ~[?:1.8.0_252]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[?:1.8.0_252]
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read(BufferedInputStream.java:345) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.fastRead(ChunkedInputStream.java:244) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.read(ChunkedInputStream.java:689) ~[?:1.8.0_252]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[?:1.8.0_252]
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(HttpURLConnection.java:3454) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:238) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[?:1.8.0_252]
at java.util.zip.GZIPInputStream.read(GZIPInputStream.java:117) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178) ~[?:1.8.0_252]
at java.io.InputStreamReader.read(InputStreamReader.java:184) ~[?:1.8.0_252]
at java.io.BufferedReader.fill(BufferedReader.java:161) ~[?:1.8.0_252]
at java.io.BufferedReader.read1(BufferedReader.java:212) ~[?:1.8.0_252]
at java.io.BufferedReader.read(BufferedReader.java:286) ~[?:1.8.0_252]
at com.csvreader.CsvReader.checkDataLength(Unknown Source) ~[javacsv-2.0.jar:?]
at com.csvreader.CsvReader.readRecord(Unknown Source) ~[javacsv-2.0.jar:?]
at org.talend.components.salesforce.runtime.BulkResultSet.next(BulkResultSet.java:21) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.advance(SalesforceBulkQueryInputReader.java:72) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.advance(FlowVariablesReader.java:78) ~[talend-codegen-utils.jar:?]

Any suggestion?

Re: tSalesforceInput SSL peer shut down incorrectly

Xiaodi_Shi — Thu, 06 Jun 2024 06:48:40 GMT

Hello,

Are you trying to connect to salesforce when using Talend Studio or Remote Engine server? Is your network OK with that?

What's java version are you using? You are able to enable net.debug to troubleshoot this to find root cause

-Djavax.net.debug=all

Best regards

Sabrina

Re: tSalesforceInput SSL peer shut down incorrectly

cvboas — Thu, 06 Jun 2024 11:20:22 GMT

Hello,

It's a Remote Engine server.

The network is OK.

The java version is the 1.8

the job only gives a error in one object, for all the others works with no problem.

I will enable the -Djavax.net.debug

Re: tSalesforceInput SSL peer shut down incorrectly

Xiaodi_Shi — Fri, 07 Jun 2024 05:02:46 GMT

Hello,

What does your specific object look like? Is this issue isolated to the Salesforce API?

Feel free to post your debug information here.

Best regards

Sabrina

Re: tSalesforceInput SSL peer shut down incorrectly

cvboas — Thu, 13 Jun 2024 15:50:23 GMT

Hello,

The object has 150 fields and I have more than 380000 lines.

I only have the problem with tSalesforceinput with this object, the others objects don't have any problem running.

I'm using a Bulk load with PKchunking

Re: tSalesforceInput SSL peer shut down incorrectly

Xiaodi_Shi — Fri, 14 Jun 2024 08:43:20 GMT

Hello,

Components have an API version in the advanced settings could you please let us know that value?

Here: /u/52.0

Best regards

Sabrina

Re: tSalesforceInput SSL peer shut down incorrectly

cvboas — Fri, 14 Jun 2024 07:18:37 GMT

Hello Sabrina,

The API version is 46.0

Best Regards