My Oracle Support Banner

ICS Integration Throws '240 Seconds Of Wait Interval' Error Querying 1 Record From DBaaS Table (Doc ID 2520578.1)

Last updated on JANUARY 18, 2020

Applies to:

Integration Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : NA version, MICC Transfer to TSC

Call to DB through DBAdapter to retrieve single record fails with below exception.

ERROR
-----------------------
<servicebus:/VHG_FIN_SUPPL_ORDER_IMPOR_SERVI_01/Resources/resources/application_9874/inbound_9875/resourcegroup_9876/<oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.>
javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
com.bea.wli.sb.transports.jca.JCATransportException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception is:
javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
Caused By: oracle.tip.adapter.sa.api.JCABindingException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception is:
javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
Caused By: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception is:
javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
Caused By: javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
Caused By: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:336)
at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:267)
at oracle.cloud.cpi.agent.transport.AQChannel.syncSend(AQChannel.java:260)
at oracle.cloud.cpi.agent.transport.CpiSaasAgentTransporter.sendPacket(CpiSaasAgentTransporter.java:251)
at oracle.cloud.cpi.agent.transport.CpiSaasAgentTransporter.send(CpiSaasAgentTransporter.java:234)
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:27)
at oracle.cloud.cpi.agent.CpiSaasAgentImpl.execute(CpiSaasAgentImpl.java:117)
at oracle.cloud.cpi.agent.CpiSaasAgentImpl.syncReqRes(CpiSaasAgentImpl.java:291)
at sun.reflect.GeneratedMethodAccessor2138.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.tip.adapter.fw.common.CloudRedirectionCalloutImpl.invokeMethod(CloudRedirectionCalloutImpl.java:631)
at oracle.tip.adapter.fw.common.CloudRedirectionCalloutImpl.sendRuntimeRequestMessage(CloudRedirectionCalloutImpl.java:141)
at oracle.tip.adapter.fw.common.CloudRedirectionCalloutImpl.request(CloudRedirectionCalloutImpl.java:98)
at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:568)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an integration to invoke DBAdapter to get record(s) and note it fails with reported error.

 

Changes

 

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
Changes
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.