My Oracle Support Banner

Messages Are Not Processing In RIB-SIM (Doc ID 2884417.1)

Last updated on JULY 21, 2022

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Messages are not flowing from to RIB to SIM and vice versa. When we tried to process them manually we are getting below java error exception.

ERROR
-----------------------
"javax.ejb.EJBException: EJB Exception: ; nested exception is:
  java.lang.RuntimeException: Exception calling inject.: EJB Exception: ; nested exception is:
  java.lang.RuntimeException: Exception calling inject.
  at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:406)
  at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:382)
  at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:288)
  at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:190)
  at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(RIBMessageSubscriberEjb.java:224)
  at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:439)
  at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:362)
  at weblogic.ejb.container.internal.JMSMessagePoller.processOneMessage(JMSMessagePoller.java:266)
  at weblogic.ejb.container.internal.JMSMessagePoller.pollContinuously(JMSMessagePoller.java:329)
  at weblogic.ejb.container.internal.JMSMessagePoller.pollForParent(JMSMessagePoller.java:456)
  at weblogic.ejb.container.internal.JMSMessagePoller.run(JMSMessagePoller.java:472)
  at java.lang.Thread.run(Thread.java:785)
Caused by: com.retek.rib.binding.exception.RIBIntegrationException: EJB Exception: ; nested exception is:
  java.lang.RuntimeException: Exception calling inject.: EJB Exception: ; nested exception is:
  java.lang.RuntimeException: Exception calling inject. - Nested exception: - javax.ejb.EJBTransactionRolledbackException: EJB Exception: ; nested exception is:
  java.lang.RuntimeException: Exception calling inject.
  at com.retek.rib.binding.subscriber.impl.J2eeSubscriberCoreServiceImpl.subscribe(J2eeSubscriberCoreServiceImpl.java:68)
  at com.ret

Issue seems to be related to high data volume (Not UI specific)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have high volume of messages in MPS_STAGED_MESSAGES (16M records, ~100k to process)
2. Observe messages are failing to be processed.

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


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