Oracle Spatial Distance Engine Fails To Return A Distance When Planning an Order With a Final Depot Stop If Property EQUIPMENT_RESTRICTIONS = Y (Doc ID 2027289.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

If the property EQUIPMENT_RESTRICTIONS = Y, when planning an order with a return to a depot using a rate base of Shipment Distance from the Last Stop to the Destination Depot,
the order fails because Spatial is unable to find a distance and a Null Pointer like this is thrown:

java.lang.NullPointerException
at glog.business.rate.ratedistance.external.OracleSpatialEngine.buildRouteRequestInputParmsWithEq(OracleSpatialEngine.java:403)
at glog.business.rate.ratedistance.external.OracleSpatialEngine.lookupDistance(OracleSpatialEngine.java:86)
at glog.business.rate.ratedistance.RateDistanceSession.lookupExternalDistance(RateDistanceSession.java:1374)
at glog.business.rate.ratedistance.RateDistanceSession.calcDistance(RateDistanceSession.java:358)
at glog.business.rate.ratedistance.RateDistanceSession.calculateDistance(RateDistanceSession.java:256)
at glog.business.rate.ratedistance.RateDistanceSession.calculateDistance(RateDistanceSession.java:229)
at glog.business.shipment.TShipment.calcDestDepotDistance(TShipment.java:6518)
at glog.business.rate.rateengine.ratable.REShipment.getDestDepotDistance(REShipment.java:1976)
at glog.business.rate.rateengine.ratable.REShipment.getMember(REShipment.java:5057)
at glog.business.rate.rateengine.operand.MethodOperand.calc(MethodOperand.java:61)
at glog.business.rate.rateengine.guts.RECharge.evaluate(RECharge.java:791)
at glog.business.rate.rateengine.guts.RACGrid2.costShipment(RACGrid2.java:354)
at glog.business.rate.rateengine.RatingEngine.rateIt(RatingEngine.java:883)
at glog.business.rate.rateengine.RatingEngine.findShipmentCost(RatingEngine.java:767)
at glog.business.rate.rateengine.RatingEngine.findShipmentCosts(RatingEngine.java:656)
at glog.business.rate.rateengine.RatingEngine.findShipmentCosts(RatingEngine.java:414)
at glog.business.rate.ratefinder.RateFinder.findShipmentCosts(RateFinder.java:297)
at glog.business.rate.ratefinder.RateFinder.findShipmentCosts(RateFinder.java:193)
at glog.business.rate.ratefinder.RateFinder.findShipmentCosts(RateFinder.java:177)
at glog.business.rate.ratefinder.RateFinder.findShipmentCosts(RateFinder.java:119)
at glog.business.rate.ratefinder.RateFinder.findCommonFeasibleRateEngineResult(RateFinder.java:575)
at glog.business.shipment.ShipmentBuilder.expandLegOptionOnCosts(ShipmentBuilder.java:3171)
at glog.business.shipment.ShipmentBuilder.calculateAndSetCosts(ShipmentBuilder.java:3055)
at glog.business.shipment.ShipmentBuilder.makeLegOptionsOnTLeg(ShipmentBuilder.java:1462)
at glog.business.shipment.ShipmentBuilder.makeLegOptions(ShipmentBuilder.java:1833)
at glog.business.shipment.ShipmentBuilder.buildItineraryOptions(ShipmentBuilder.java:1703)
at glog.business.shipment.ShipmentBuilder.buildItineraryOptionses(ShipmentBuilder.java:1662)
at glog.business.action.order.BuildRoutingOptionsAction.buildRoutingOptions(BuildRoutingOptionsAction.java:175)
at glog.business.action.order.BuildRoutingOptionsAction.buildRoutingOptions(BuildRoutingOptionsAction.java:112)
at glog.business.action.order.BuildRoutingOptionsAction.buildRoutingOptions(BuildRoutingOptionsAction.java:66)
at glog.business.session.OrderActionSessionBean.buildRoutingOptions(OrderActionSessionBean.java:2562)
at glog.business.session.OrderActionSessionServerSideEJBWrapper.buildRoutingOptions(OrderActionSessionServerSideEJBWrapper.java:2294)
at glog.business.session.OrderActionSessionBean.buildRoutingOptions(OrderActionSessionBean.java:2513)
at glog.business.session.OrderActionSessionServerSideEJBWrapper.buildRoutingOptions(OrderActionSessionServerSideEJBWrapper.java:2251)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.business.session.OrderActionSessionHome_likuwd_EOImpl.buildRoutingOptions(Unknown Source)
at glog.business.session.gen.OrderActionSessionSkel.buildRoutingOptions(OrderActionSessionSkel.java:1605)
at glog.business.session.gen.OrderActionSessionSkel.exec(OrderActionSessionSkel.java:345)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:16)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:83)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:50)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(Unknown Source)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

The same order can be planned if the property EQUIPMENT_RESTRICTIONS = N and a distance is returned.
When running only a distance query with the property EQUIPMENT_RESTRICTIONS = Y, a distance is returned.

Cause

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