After Cloning Of RIB Database, Cannot StartUp Hospital Retry Adapters And Messages Are Not Flowing
(Doc ID 1434044.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Retail Integration Bus - Version 13.1.1 and laterInformation 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)
....
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 :
- Clone the RIB database from one instance to other.
- Create a new RIBAQ User with the necessary permissions
- Try to process the message.
- But they fail with exceptions like "Topic xxx not found" and "An invalid user/password was specified for the JMS connection"
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 |