RIB EXT Publisher Issue - Error Code: 1554 (Doc ID 2958775.1)

Last updated on JULY 18, 2023

Applies to:

Symptoms

Experiencing issues publishing messages from RIB EXT. Some messages are showing published but not being received downstream while others are showing no activity at all.

Find that messages for ItemLoc Publisher in RIB-RMS and Item Publisher within RIB-RMS are erroring with the following, so message does not get sent to RIB-EXT.

ERROR
-------------
Error Code: 1554
Call: INSERT INTO RIB_MESSAGE (MESSAGE_NUM, ADAPTER_CLASS_LOCATION, ADAPTER_INSTANCE_NUMBER, ATTEMPT_COUNT, DELETE_PENDING, IN_QUEUE, JMS_QUEUE_ID, MAX_ATTEMPTS, NEXT_ATTEMPT_TIME, REASON_CODE, TOPIC_NAME, ID, CUSTOM_DATA, CUSTOM_FLAG, FAMILY, MESSAGE_DATA, PUBLISH_TIME, RIB_MESSAGE_ID, THREAD_VALUE, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [1716017, rib-rms_Items_pub, 3, 0, false, false, jms1, 5, null, JMS, etItemsFromRMS, 200008004, null, F, Items, 20000800418144<manufacturer_ctry_id>KP<primary_manufacturer_ctry_ind>N, 2023-06-19 18:44:17.777, Items_pub_3|2023.06.19 18:44:17.777|4940, 3, ISCMfrMod]
Query: InsertObjectQuery(com.retek.rib.domain.hospital.bo.impl.HospitalEntryImpl@4518e215[messageNum=1716017])



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update a store value in MFCS and save the changes.
2. Check activity in RIB admin and no adapter activity is shown.
3. Validate the store adapters are online.

Cause

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