Query to Salesforce database using the TIBCO Data Virtualization 'Salesforce.com' adapter fails with the following connection reset error.
ERROR [DBChannel-4] 2022-07-14 07:16:05.123 -0700 ServerChannelConnection - User Exception Occurred com.compositesw.common.UserException: Error [sforce-2900000]: Cause: ; nested exception is: javax.net.ssl.SSLException: Connection reset [Log ID: d456cb59-2e3b-4c8b-b5e4-cd1ea91f570a] at com.compositesw.common.UserException$Builder.build(UserException.java:165) [cscommon.jar:?] at com.compositesw.server.dbchannel.AbstractCommand.sendError(AbstractCommand.java:195) [csserver.jar:?] at com.compositesw.server.dbchannel.AbstractCommand.sendError(AbstractCommand.java:184) [csserver.jar:?] at com.compositesw.server.dbchannel.ServerCommand.getrows(ServerCommand.java:974) [csserver.jar:?] at com.compositesw.server.dbchannel.ServerCommand.dispatchCommand(ServerCommand.java:167) [csserver.jar:?] at com.compositesw.server.dbchannel.ServerCommand.run(ServerCommand.java:86) [csserver.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:834) [?:?] ... Caused by: org.apache.axis.AxisFault: ; nested exception is: javax.net.ssl.SSLException: Connection reset at com.compositesw.cdms.ds.sforce.SForceSession.handleSForceException(SForceSession.java:608) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession$QueryTask.run(SForceSession.java:483) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.retry(SForceSession.java:359) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.query(SForceSession.java:664) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceCursor.next(SForceCursor.java:325) ~[?:?] at com.compositesw.server.qe.physical.operator.SqlScan.next(SourceFile:786) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.nextInternal(SourceFile:438) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.next(SourceFile:417) ~[csqe.jar:?] at com.compositesw.server.qe.QueryResult.next(SourceFile:409) ~[csqe.jar:?] at com.compositesw.server.dbchannel.CsResult.preFetchRows(CsResult.java:297) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.prefetch(CsResultProcessor.java:81) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.run(CsResultProcessor.java:70) ~[csserver.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] ... 3 more ... Suppressed: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) ~[?:?] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:110) ~[?:?] at java.net.SocketOutputStream.write(SocketOutputStream.java:150) ~[?:?] at sun.security.ssl.SSLSocketOutputRecord.encodeAlert(SSLSocketOutputRecord.java:83) ~[?:?] at sun.security.ssl.TransportContext.fatal(TransportContext.java:400) ~[?:?] at sun.security.ssl.TransportContext.fatal(TransportContext.java:312) ~[?:?] at sun.security.ssl.TransportContext.fatal(TransportContext.java:307) ~[?:?] at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1531) ~[?:?] at sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:975) ~[?:?] at java.io.BufferedInputStream.fill(BufferedInputStream.java:252) ~[?:?] at java.io.BufferedInputStream.read(BufferedInputStream.java:271) ~[?:?] at org.apache.commons.httpclient.HttpParser.readRawLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpParser.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpConnection.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.readResponse(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.execute(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpClient.executeMethod(Unknown Source) ~[?:?] at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) ~[?:?] at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) ~[?:?] at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) ~[?:?] at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) ~[?:?] at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) ~[?:?] at org.apache.axis.client.Call.invokeEngine(Call.java:2784) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2767) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2443) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2366) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:1812) ~[?:?] at com.sforce.soap.partner.SoapBindingStub.query(SoapBindingStub.java:5663) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession$QueryTask.run(SForceSession.java:465) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.retry(SForceSession.java:359) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.query(SForceSession.java:664) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceCursor.next(SForceCursor.java:325) ~[?:?] at com.compositesw.server.qe.physical.operator.SqlScan.next(SourceFile:786) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.nextInternal(SourceFile:438) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.next(SourceFile:417) ~[csqe.jar:?] at com.compositesw.server.qe.QueryResult.next(SourceFile:409) ~[csqe.jar:?] at com.compositesw.server.dbchannel.CsResult.preFetchRows(CsResult.java:297) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.prefetch(CsResultProcessor.java:81) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.run(CsResultProcessor.java:70) ~[csserver.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:186) ~[?:?] at java.net.SocketInputStream.read(SocketInputStream.java:140) ~[?:?] at sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:478) ~[?:?] at sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:472) ~[?:?] at sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70) ~[?:?] at sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1318) ~[?:?] at sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:959) ~[?:?] at java.io.BufferedInputStream.fill(BufferedInputStream.java:252) ~[?:?] at java.io.BufferedInputStream.read(BufferedInputStream.java:271) ~[?:?] at org.apache.commons.httpclient.HttpParser.readRawLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpParser.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpConnection.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.readResponse(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodBase.execute(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(Unknown Source) ~[?:?] at org.apache.commons.httpclient.HttpClient.executeMethod(Unknown Source) ~[?:?] at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) ~[?:?] at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) ~[?:?] at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) ~[?:?] at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) ~[?:?] at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) ~[?:?] at org.apache.axis.client.Call.invokeEngine(Call.java:2784) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2767) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2443) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:2366) ~[?:?] at org.apache.axis.client.Call.invoke(Call.java:1812) ~[?:?] at com.sforce.soap.partner.SoapBindingStub.query(SoapBindingStub.java:5663) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession$QueryTask.run(SForceSession.java:465) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.retry(SForceSession.java:359) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceSession.query(SForceSession.java:664) ~[?:?] at com.compositesw.cdms.ds.sforce.SForceCursor.next(SForceCursor.java:325) ~[?:?] at com.compositesw.server.qe.physical.operator.SqlScan.next(SourceFile:786) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.nextInternal(SourceFile:438) ~[csqe.jar:?] at com.compositesw.server.qe.topology.SelectPTree.next(SourceFile:417) ~[csqe.jar:?] at com.compositesw.server.qe.QueryResult.next(SourceFile:409) ~[csqe.jar:?] at com.compositesw.server.dbchannel.CsResult.preFetchRows(CsResult.java:297) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.prefetch(CsResultProcessor.java:81) ~[csserver.jar:?] at com.compositesw.server.dbchannel.CsResultProcessor.run(CsResultProcessor.java:70) ~[csserver.jar:?] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] ... 3 more