Why areRIB Messages not Published to the Topics with the Exception "oracle.jms.AQjmsException: Unable to get a physical connection from the database"? (Doc ID 1069067.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.2 and later
Information in this document applies to any platform.
itemmasters.pls
itemmasterb.pls
itemmaster.fmb
Checked for relevance 12-JUL-2010

Checked for relevance on 10-Jun-2014

Goal

Why are Retail Integration Bus (RIB) messages not published to the topics with the exception "oracle.jms.AQjmsException: Unable to get a physical connection from the database"?

The following exceptions also seen in the logs:

oracle.oc4j.rmi.ApplicationStoppedException: Application is not in RUNNING state

allocateConnection: javax.resource.spi.EISSystemException: Error occurred when attempting to create a JMS connection: oracle.jms.AQjmsException: Unable to get a physical connection from the database...there are no connections available

ERROR com.retek.rib.domain.getnext.service.impl.GetNextPublisherCoreServiceImpl - Unable to publish message to JMS.
com.retek.rib.collab.RibAPIException: Error from {call RMSMFM_ALLOC.GETNXT(?,?,?,?,?,?,?,?)}: [InitError] Closed Connection

Solution

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 hundreds of Community platforms