SAP Knowledge Base Article - Preview

3763587 - Cannot implement a keep alive on the OData connection - Data Services

Symptom

  •  RUN-058107: |Data flow <DF>|Reader <Source>
    Error reading from <Source>: <Failed to read data, Exception: Exception, Problem executing POST while requestion access
    token:Connection reset
    java.net.SocketException: Connection reset
    at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:328)
    at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355)
    at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808)
    at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966)
    at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484)
    at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478)
    at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:160)
    at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:111)
    at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1510)
    at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1425)
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:455)
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:426)
    at org.apache.http.conn.ssl.SSLConnectionSocketFactory.createLayeredSocket(SSLConnectionSocketFactory.java:436)
    at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:384)
    at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142)
    at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:376)
    at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:393)
    at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:236)
    at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:186)
    at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
    at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:110)
    at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
    at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:56)
    at com.acta.adapter.odata.util.AccessTokenUtil.getAccessToken(AccessTokenUtil.java:45)
    at com.acta.adapter.odata.util.ODataSAML2BearerUtil.FetchAccessToken(ODataSAML2BearerUtil.java:125)
    at com.acta.adapter.odata.base.ODataV2Handler.connect(ODataV2Handler.java:270)
    at com.acta.adapter.odata.base.ODataV2Handler.readEntities(ODataV2Handler.java:1026)
    at com.acta.adapter.odata.base.ODataV2Handler.collectData(ODataV2Handler.java:1111)
    at com.acta.adapter.odata.base.ODataV2Handler.readNext(ODataV2Handler.java:1088)
    at com.acta.adapter.odata.operations.OdataTableSource.readNext(OdataTableSource.java:345)
    at com.acta.adapter.sdk.StreamListener.handleBrokerMessage(StreamListener.java:188)
    at com.acta.brokerclient.BrokerClient.handleMessage(BrokerClient.java:402)
    at com.acta.brokerclient.BrokerClient$MessageHandler.run(BrokerClient.java:1541)
    at com.acta.brokerclient.ThreadPool$PoolThread.run(ThreadPool.java:100)
  • Experiencing connection reset errors when longer running jobs connect to SuccessFactors endpoing via OData adapter.
  • Customer cannot change their firewall timeout that is causing the connection reset as it is a security concern.
  • The setting on the OData adapter -Dsun.net.keepAlive=true in the additional Java Launcher Options setting does not work.
  • OS Keep alive settings have no affect -
    net.ipv4.tcp_keepalive_time=60
    net.ipv4.tcp_keepalive_intvl=15
    net.ipv4.tcp_keepalive_probes=4


Read more...

Product

SAP Data Services all versions

Keywords

KBA , EIM-DS-EXE , Job Execution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.