My Oracle Support Banner

Messages Failing with Data Error (Doc ID 2989192.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Oracle Retail Integration Cloud Service - Version 23.0 and later
Information in this document applies to any platform.


There are messages piled up and all failing due to the data errors. 

RIb AQ Topic Depth alert 1 issues, >= 3000: RIB_RWMS_ITEMS_SUB_1_ETITEMSTLFROMRIB:22783

Injector service -https:/../PlsqlApplicationMessageInjectorServiceBean/PlsqlApplicationMessageInjectorServiceBeanService?WSDL

2023-11-20 12:14:59,790 ERROR [Items_sub_1] master.PlsqlApplicationMessageInjectorClient ( - Error while calling Injector Service. Client received SOAP Fault from server: EJB Exception: : java.lang.RuntimeException: Exception calling plsql inject. Error from {call RDMSUB_ITEMS.CONSUME(?,?,?,?,?)}: [425] ORA-02291: integrity constraint (RWMS16.IA_IM_FK) violated - parent key not found[ORA-02291: integrity constraint (RWMS16.IA_IM_FK) violated - parent key not found]
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.invokeInjectForMessageType(
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(


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

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