Last updated on MARCH 08, 2017
Applies to:
Oracle Transportation Management - Version 5.5.02 to 5.5.05.06 [Release 5.5]Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2014***
Symptoms
-- Problem Statement:
When multiple integration transactions are inbound to OTM and trying to unassign allocated orders on the same shipment, the following error is observed:
2009-05-28 10:53:36.637 537497 Error Exception Read_Record_Failure
(cachedUser=DOMAIN.USER/ADMIN/ADMIN, class=class
glog.ejb.allocation.ejb_AllocationBase_vif86s_Impl, currentUserName=DOMAIN.USER,
primaryContext=1048723, vpdUser=DOMAIN.USER/ADMIN/ADMIN)
Unable to read {0=null} {1=null} from the database. Either the record has been removed by another
user or you do not have rights to view it. (cachedUser=DOMAIN.USER/ADMIN/ADMIN,
class=class glog.ejb.allocation.ejb_AllocationBase_vif86s_Impl, currentUserName=DOMAIN.USER,
primaryContext=1048723, vpdUser=DOMAIN.USER/ADMIN/ADMIN)
at sun.reflect.GeneratedConstructorAccessor436.newInstance(Unknown Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at glog.util.exception.GLException.factory(GLException.java:413)
at glog.util.exception.GLException.factory(GLException.java:390)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1067)
at glog.util.remote.BeanManagedEntityBean.doLoad(BeanManagedEntityBean.java:248)
at glog.util.remote.BaseEntityBean$2.doIt(BaseEntityBean.java:493)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:803)
at glog.util.remote.BaseEntityBean.ejbLoad(BaseEntityBean.java:491)
at glog.util.remote.BeanManagedEntityBean.ejbLoad(BeanManagedEntityBean.java:588)
at
glog.ejb.allocation.ejb_AllocationBase_vif86s_Impl.ejbLoad(ejb_AllocationBase_vif86s_Impl.java:136)
at weblogic.ejb20.manager.ExclusiveEntityManager.getReadyBean(ExclusiveEntityManager.java:324)
at weblogic.ejb20.manager.ExclusiveEntityManager.preInvoke(ExclusiveEntityManager.java:246)
at weblogic.ejb20.internal.BaseEJBObject.preInvoke(BaseEJBObject.java:137)
at weblogic.ejb20.internal.EntityEJBObject.preInvoke(EntityEJBObject.java:89)
at
glog.ejb.allocation.ejb_AllocationBase_vif86s_EOImpl.getPK(ejb_AllocationBase_vif86s_EOImpl.java:622)
at
glog.business.allocation.AllocationUpdateSessionBean.removeAllocations(AllocationUpdateSessionBean.java:705)
at
glog.business.allocation.AllocationUpdateSessionServerSideEJBWrapper.removeAllocations(AllocationUpdateSessionServerSideEJBWrapper.java:460)
at
glog.business.allocation.AllocationUpdateSessionBean.removeAllocationsForShipments(AllocationUpdateSessionBean.java:635)
at
glog.business.allocation.AllocationUpdateSessionServerSideEJBWrapper.removeAllocationsForShipments(AllocationUpdateSessionServerSideEJBWrapper.java:364)
at
glog.business.allocation.AllocationUpdateSessionServerSideEJBWrapper_fcse0h_EOImpl.removeAllocationsForShipments(AllocationUpdateSessionServerSideEJBWrapper_fcse0h_EOImpl.java:748)
at
glog.business.allocation.AllocationExecutor.unallocateOrdersFromShipments(AllocationExecutor.java:877)
at glog.business.action.order.OrderActions.unassignUnassignableOrders(OrderActions.java:216)
at
glog.business.action.order.UnassignOrdersActionExecutor.unassignOrders(UnassignOrdersActionExecutor.java:77)
at glog.business.session.OrderActionSessionBean.unassignOrders(OrderActionSessionBean.java:432)
at
glog.business.session.OrderActionSessionServerSideEJBWrapper.unassignOrders(OrderActionSessionServerSideEJBWrapper.java:470)
at
glog.business.session.OrderActionSessionHome_likuwd_EOImpl.unassignOrders(OrderActionSessionHome_likuwd_EOImpl.java:3718)
at glog.server.agent.business.order.UnAssignOrder.execute(UnAssignOrder.java:61)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:51)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at
glog.server.workflow.WorkflowSessionServerSideEJBWrapper.execute(WorkflowSessionServerSideEJBWrapper.java:32)
at
glog.server.workflow.WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.execute(WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.java:262)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:341)
at glog.server.workflow.Trigger.trigger(Trigger.java:111)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:111)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:70)
at glog.util.event.EventThread.run(EventThread.java:79)
at java.lang.Thread.run(Thread.java:534)
-- Steps To Reproduce:
1. Create a shipment with two or more orders
2. Through integration, update each order in separate transactions that cause the Order Release unassignment.
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