Messages Failing with Data Error (Doc ID 2989192.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Goal

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 (PlsqlApplicationMessageInjectorClient.java:165) - Error while calling Injector Service.
com.sun.xml.ws.fault.ServerSOAPFaultException: 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(PlsqlApplicationMessageInjectorServiceBean.java:178)
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(PlsqlApplicationMessageInjectorServiceBean.java:69)
 

Solution

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