Query to Salesforce using the TIBCO Data Virtualization 'Salesforce.com' adapter fails with errors
book
Article ID: KB0072125
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
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
Environment
All supported Operating Systems
Resolution
This error can be caused due to the reuse of the SSL sessions in TDV to the Salesforce database. Disabling the "SSL Session Reuse" field on the data source Advanced panel can help alleviate this connection reset error. Screenshot of the field in the data source panel:
Issue/Introduction
Query to Salesforce using the TIBCO Data Virtualization 'Salesforce.com' adapter fails with a connection reset error