My Oracle Support Banner

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 MARCH 30, 2019

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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