After Cloning Of RIB Database, Cannot StartUp Hospital Retry Adapters And Messages Are Not Flowing

(Doc ID 1434044.1)

Last updated on JANUARY 24, 2018

Applies to:

Oracle Retail Integration Bus - Version 13.1.1 and later
Information in this document applies to any platform.

Symptoms

After cloning of Retail Integration Bus (RIB) database from one environment to other, in the newly cloned environment, while processing the messages , the hospital retry adapters JMS Hospital Retry AQ1 and PUB Hospital Retry AQ1 adapters cannot be started UP

When checked in the logs, the following errors are shown :

Errors :

....
2012-01-17 12:27:22,863 [Timer-13] ERROR com.retek.rib.j2ee.J2eeJMSPublisher - Failed to publish message to JMS
javax.jms.JMSSecurityException: allocateConnection: javax.resource.spi.SecurityException: createManagedConnection: javax.jms.JMSSecurityException: JMS-232: An invalid user/password was specified for the JMS connection
...
Internal Exception: java.sql.SQLException: The Network Adapter could not establish the connection
Error Code: 20; nested exception is: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: The Network Adapter could not establish the connection
Error Code: 20
....
....
2012-03-05 13:02:54,674 [Timer-11] ERROR com.retek.rib.j2ee.J2eeJMSPublisher - Failed to publish message to JMS
oracle.jms.AQjmsException: JMS-243: Topic etItemsFromRMS not found
at oracle.jms.AQjmsError.throwEx(AQjmsError.java:353)
at oracle.jms.AQjmsSession.createTopic(AQjmsSession.java:2205)
....


Steps To Reproduce :

  1. Clone the RIB database from one instance to other.
  2. Create a new RIBAQ User with the necessary permissions
  3. Try to process the message.
  4. But they fail with exceptions like "Topic xxx not found" and "An invalid user/password was specified for the JMS connection"

Cause

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