2 Replies Latest reply: Feb 4, 2013 8:33 AM by 978291 RSS

    Msg stuck in RIB Hospital - RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)

    927509
      Hi,

      I am getting an error when i do the receiving of a packinglist/shipment in SIM

      While receiving a shipment, I add an new item which is not ranged to that store, and then do the receiving, before it the items gets ranged.

      The issue is from the SIM side all the tables get updated.

      But when it passes to RMS, the message gets stuck in RIB,

      It says Integrity constraint on a supplier ID,

      I am not able to pin point the exact place where it is failing..

      Any ideas?



      This is the stack trace

      -----
      javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-02291: integrity constraint (ISP_SUP_FK) violated - parent key not found returned by program unit NEW_ITEM_LOC.;
      at com.retek.rib.binding.subscriber.impl.PlsqlSubscriberCoreServiceImpl.subscribe(PlsqlSubscriberCoreServiceImpl.java:65)
           at com.retek.rib.j2ee.RIBMessageSubscriberEjb$MessageHandler.handleMessage(RIBMessageSubscriberEjb.java:357)
           at com.retek.rib.collab.HospitalController.performHandlerCall(HospitalController.java:380)
           at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:286)
           at com.retek.rib.collab.HospitalController.doMessage(HospitalController.java:188)
           at com.retek.rib.j2ee.RIBMessageSubscriberEjb.onMessage(RIBMessageSubscriberEjb.java:205)
           at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:585)
           at com.evermind.server.ejb.interceptor.joinpoint.EJBJoinPointImpl.invoke(EJBJoinPointImpl.java:35)
           at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
           at com.evermind.server.ejb.interceptor.system.DMSInterceptor.invoke(DMSInterceptor.java:52)
           at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
           at com.evermind.server.ejb.interceptor.system.SetContextActionInterceptor.invoke(SetContextActionInterceptor.java:44)
           at com.evermind.server.ejb.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:119)
           at com.evermind.server.ejb.InvocationContextPool.invoke(InvocationContextPool.java:55)
           at oracle.j2ee.connector.messageinflow.MessageEndpointImpl.OC4J_invokeMethod(MessageEndpointImpl.java:297)
           at Receiving_sub_1_EndPointProxy_65638f9.onMessage(Unknown Source)
           at oracle.j2ee.ra.jms.generic.WorkConsumer.run(WorkConsumer.java:287)
           at oracle.j2ee.connector.work.WorkWrapper.runTargetWork(WorkWrapper.java:242)
           at oracle.j2ee.connector.work.WorkWrapper.doWork(WorkWrapper.java:215)
           at oracle.j2ee.connector.work.WorkWrapper.run(WorkWrapper.java:190)
           at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:825)
           at java.lang.Thread.run(Thread.java:595)
      Caused by: com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_RECEIVING.CONSUME(?,?,?,?,?,?)}: [E] Error ORA-02291: integrity constraint (RMSPRD.ISP_SUP_FK) violated - parent key not found returned by program unit NEW_ITEM_LOC.
           at com.retek.rib.collab.general.OracleObjectSubscriberComponentImpl.processResult(OracleObjectSubscriberComponentImpl.java:416)
           at com.retek.rib.collab.general.OracleObjectSubscriberRePublisherComponentImpl.processResult(OracleObjectSubscriberRePublisherComponentImpl.java:65)
           at com.retek.rib.collab.general.OracleObjectSubscr
      -----