Query to Salesforce using the TIBCO Data Virtualization 'Salesforce.com' adapter fails with errors

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 

Issue/Introduction

Query to Salesforce using the TIBCO Data Virtualization 'Salesforce.com' adapter fails with a connection reset error

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:
User-added image