Item Family Messages Are Failing With java.sql.SQLException: ORA-01400: cannot insert NULL into ("TAFRHOSP"."RIB_MESSAGE_ROUTING_INFO"."NAME")
(Doc ID 1382282.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Retail Integration Bus - Version 13 and laterInformation in this document applies to any platform.
Symptoms
Occasionally item family messages which are coming from RMS are failing at the RIB TAFR 'ItemsToItemsTLTAFR' side with the following exception in the rib-tafr logs.
Error:
"TRAN_LEVEL_IND is not found in routing info record"
....
Internal Exception: java.sql.SQLException: ORA-01400: cannot insert NULL into ("TAFRHOSP"."RIB_MESSAGE_ROUTING_INFO"."NAME")
....
Error Code: 1400
Call: INSERT INTO RIB_MESSAGE_ROUTING_INFO (DETAIL1_NAME, DETAIL1_VALUE, NAME, DETAIL2_NAME, DETAIL2_VALUE, VALUE, SEQ_NUMBER, MESSAGE_NUM) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
bind => [null, null, null, null, null, null, 0, XXXX]
With this issue, sometimes the rib-tafr.ItemsToItemsTL_tafr is also shutting down.
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 |