Retail Integration Bus (RIB) Messages Of Many Families Fail, Returning "ORA-01438" Error (Doc ID 370070.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Integration Bus - Version 10.3 to 11.2 [Release 10 to 11]
Information in this document applies to any platform.
Checked for relevance on 03-September-2010
Checked for relevance 07-Mar-2012


Symptoms

A Retail Integration Bus (RIB) message comes to Retail Data Management (RDM), and the consume call returns an error.

Error:

rib_ewItemsToRDMWH1.log
2006.05.09 15:52:36.189||HospitalController.checkFlaggedForInsertion()...Message had error:
java.sql.SQLException: OracleObjectSubscriberHelper.execute() threw Exception: Error from {call
RDMSUB_ITEMS.CONSUME(?,?,?,?,?)}: [E] User-Defined
Exception[RDMRIB_ERROR.k_ITEM_SUPPLIER_MISSING_ERROR - 007083777,00001]


The message does not get inserted into the error hospital, because of a secondary error.

Secondary Error:

HospitalController had a problem inserted error into error hospital:java.sql.SQLException:
ORA-01438: value larger than specified precision allows for this column.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms