My Oracle Support Banner

Messages Getting Failed/Stuck with Error "Data Source rib-<app>-managed-datasource is not active, cannot allocate connections to applications" (Doc ID 2716120.1)

Last updated on FEBRUARY 14, 2024

Applies to:

Oracle Retail Integration Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

Messages were not getting published and stuck in *_MFQUEUE tables with below errors in publisher adapter logs:

Error:

[Timer-33] ERROR com.retek.rib.app.getnext.impl.GetNextPublisherEjb - Rolling back the transaction.
com.retek.rib.binding.exception.PublishException: Unable to publish message to JMS.
....
Caused by: java.sql.SQLException: weblogic.common.resourcepool.ResourceDisabledException: Data Source rib-rms-managed-datasource is not active, cannot allocate connections to applications
...
[Timer-33] ERROR com.retek.rib.app.getnext.impl.GetNextTimerTaskImpl - GetNextPublisher Service call failed.
java.lang.reflect.UndeclaredThrowableException: null
....
Caused by: com.retek.rib.binding.exception.PublishException: com.retek.rib.binding.exception.PublishException: Unable to publish message to JMS.
...
Caused by: com.sun.xml.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling getNextDataFromPlsqlApi().
...
[Timer-33] WARN com.retek.rib.app.getnext.impl.GetNextTimerTaskImpl - GetNextPublisher Service timer not aborting yet as fatalErrorCount(19) is less than abortAfterNumberOfErrors(20).
...
[Timer-33] WARN com.oracle.retail.integration.common.webservice.consumer.WebServiceConsumerFactory - Reload SoapServiceconsumer Configurationfalse
[Timer-33] WARN com.oracle.retail.integration.common.webservice.consumer.WebServiceConsumerFactory -ServiceConsumerSecurityPolicyConfig:com.oracle.retail.integration.common.webservice.consumer.WebServiceConsumerFactory$ServiceConsumerSecurityPolicyConfig@76c71428
[Timer-33] ERROR com.retek.rib.domain.getnext.service.impl.GetNextPublisherCoreServiceImpl - Unable to publish message to JMS.
com.sun.xml.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling getNextDataFromPlsqlApi().

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!

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