My Oracle Support Banner

ItemTcktCre Message Fails in Error Hospital With "User-Defined Exception [Invalid Message Type]" (Doc ID 1986814.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Retail Integration Bus - Version 13.2 to 13.2.7 [Release 13.2]
Oracle Retail Warehouse Management System - Version 13.2 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.

Symptoms

After performing data conversion for DC_ITEM_TICKET table, ItemTcktCre messages were created and inserted into the ITEM_MFQUEUE table.  However, all of these messages went to the error hospital with the following description, found in RWMS RIB_MESSAGE_FAILURE:

javax.ejb.EJBException: Exception while processing request: Error from {call RDMSUB_ITEMS.CONSUME(?,?,?,?,?)}: [E] User-Defined Exception[Invalid Message Type]
at com.retek.rib.binding.subscriber.impl.PlsqlSubscriberCoreServiceImpl.subscribe(PlsqlSubscriberCoreServiceImpl.java:71)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler$1.run(RIBMessageSubscriberEjb.java:390)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler$1.run(RIBMessageSubscriberEjb.java:381)
at java.security.AccessController.doPrivileged(AccessController.java:273)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:381)
at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:383)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:289)
at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:191)
at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(RIBMessageSubscriberEjb.java:220)


RWMS13DEV.RDMRIB_CONSTANTS package has predefined message type constants. There is no ItemTcktCre among them.

Steps to Reproduce:

  1. Fill in dc_item_ticket.dat file with relevant values.
  2. Run dc_load_main.ksh -q dc_load.seq
  3. Check if ITEM_TICKET RMS table has all values from dc_item_ticket.dat
  4. Check if ItemTcktCre messages are created successfully
  5. Check entries in RWMS schema for tables RIB_MESSAGE, RIB_MESSAGE_FAILURE

 

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!


In this Document
Symptoms
Changes
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.