Database Cloud Instance Not Able To Send Response To OIC Instance For DBAdapter Query Results Error "java.net.SocketException: Connection reset" (Doc ID 2496064.1)

Last updated on DECEMBER 02, 2021

Applies to:

Symptoms

On :  NA version, Integration RT

Call from OIC to Agent fails with 120 seconds timeout error and agent log fails with Connection error below.

ERROR
-----------------------
Error on OIC log:
oracle.cloud.cpi.agent.transport.aq.CpiAQException: No response received within response time out window of 120 seconds. Agent may not be running, or temporarily facing connectivity issues to Oracle Integration Cloud Service. Please check the health of the Agent in Agent Monitoring page.
        at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:339)
        at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:270)
        at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:254)
        at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:229)
        at oracle.cloud.cpi.agent.transport.CpiSaasAgentTransporter.sendPacket(CpiSaasAgentTransporter.java:257)
        at oracle.cloud.cpi.agent.transport.CpiSaasAgentTransporter.send(CpiSaasAgentTransporter.java:235)
        at oracle.cloud.cpi.agent.transport.DistributedCpiCommandExecutorOmcs.send(DistributedCpiCommandExecutorOmcs.java:70)
        at oracle.cloud.cpi.agent.transport.DistributedCpiCommandExecutorOmcs.execute(DistributedCpiCommandExecutorOmcs.java:48)
        at oracle.cloud.cpi.agent.framework.CpiCommandBus.execute(CpiCommandBus.java:29)
        at oracle.cloud.cpi.agent.CpiSaasAgentImpl.execute(CpiSaasAgentImpl.java:111)
        at oracle.cloud.cpi.agent.CpiSaasAgentImpl.ping(CpiSaasAgentImpl.java:124)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at oracle.tip.tools.ide.adapters.db.common.plugin.connection.SaasAgentSvcImpl.sendCommandToAgent(SaasAgentSvcImpl.java:63)
        at oracle.tip.tools.ide.adapters.db.plugin.connection.CloudDatabaseConnection.sendCommandToAgent(CloudDatabaseConnection.java:440)
        at oracle.tip.tools.ide.adapters.db.common.plugin.connection.CloudDatabaseRemoteConnector.ping(CloudDatabaseRemoteConnector.java:135)
        at oracle.tip.tools.ide.adapters.db.plugin.connection.CloudDatabaseConnection.ping(CloudDatabaseConnection.java:172)
        at oracle.ics.webconsole.model.manager.AppConfigManager.testApplicationInstance(AppConfigManager.java:2419)
        at oracle.ics.webconsole.model.manager.AppConfigManager.testApplicationInstance(AppConfigManager.java:2383)
        at oracle.ics.webconsole.view.beans.AppConfigCreateResourceBean.testAppInstance(AppConfigCreateResourceBean.java:1629)
        at oracle.ics.webconsole.view.beans.AppConfigCreateBean.testAppInstance(AppConfigCreateBean.java:842)
        at oracle.ics.webconsole.view.beans.AppConfigCreateBean$HeaderPageTemplateBackingBean.customButton1Action(AppConfigCreateBean.java:1687)

Error on Agent log:
java.net.SocketException: Connection reset
       at java.net.SocketInputStream.read(SocketInputStream.java:209)
       at java.net.SocketInputStream.read(SocketInputStream.java:141)
       at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
       at sun.security.ssl.InputRecord.read(InputRecord.java:503)
       at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973)
       at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930)
       at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
       at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
       at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
       at java.io.BufferedInputStream.read(BufferedInputStream.java:345)
       at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:704)
       at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:647)
       at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1536)
       at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1441)
       at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:480)
       at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:338)
       at com.sun.jersey.client.urlconnection.URLConnectionClientHandler._invoke(URLConnectionClientHandler.java:253)
       at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:153)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an integration with DBAdapter to query for a record and note it didn't get response from DB Tables.

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.