Tweet
Hi,
When I am trying to crun bulk plan then Bulk plan is failing to plan the shipment. However when I am running RIQ then my results are coming correctly. On looking at logs, this error seems to be the problem, I am using pcmiler for calculating rate distance, rate distance type has been taken as PC Mile:
2008-06-30 12:51:08.023 378751 Error Exception insert into distance_lookup (x_lane_gid,rate_distance_gid,distance_value,domai n_name,distance_value_uom_code,distance_value_base ) values (?,?,?,?,?,?); [TEST.186, TEST.PC MILE, 1454.8 MI, TEST] [batch - 1]
2008-06-30 12:51:08.026 378751 Error Exception Cannot add the DISTANCE_LOOKUP record. [X_LANE_GID, RATE_DISTANCE_GID] must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_DISTANCE) violated
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_DISTANCE) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:13
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 639)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:185)
at oracle.jdbc.driver.T4CPreparedStatement.execute_fo r_rows(T4CPreparedStatement.java:633)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1161)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3001)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:3074)
at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.e xecuteUpdate(PreparedStatementBCELProxy.java:37)
at glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.j ava:133)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate. java:111)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:60 )
at glog.util.remote.BeanManagedEntityBean.executeUpda te(BeanManagedEntityBean.java:793)
at glog.util.remote.BeanManagedEntityBean$1.execute(B eanManagedEntityBean.java:195)
at glog.util.remote.BeanManagedEntityBean.dbModify(Be anManagedEntityBean.java:1066)
at glog.util.remote.BeanManagedEntityBean.doCreate(Be anManagedEntityBean.java:191)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityB ean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:79
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEnt ityBean.java:453)
at glog.ejb.rates.db.DistanceLookupBeanDB.ejbCreate(D istanceLookupBeanDB.java:52)
at DistanceLookupHome_EntityHomeWrapper893.create(Dis tanceLookupHome_EntityHomeWrapper893.java:44
at glog.business.rate.ratedistance.RateDistanceSessio n.saveDistance(RateDistanceSession.java:640)
at glog.business.rate.ratedistance.RateDistanceSessio n.calcDistance(RateDistanceSession.java:25
at glog.business.rate.ratedistance.RateDistanceSessio n.calculateDistance(RateDistanceSession.java:157)
at glog.business.rate.rateservice.RateServiceCalculat orImpl.getDistance(RateServiceCalculatorImpl.java: 240)
at glog.business.rate.rateservice.RateServiceCalculat orImpl.calculateService(RateServiceCalculatorImpl. java:96)
at glog.business.rate.rateservice.RateServiceSession. createServiceTimeResult(RateServiceSession.java:25 13)
at glog.business.rate.rateservice.RateServiceSession. calculateServiceTime(RateServiceSession.java:1751)
at glog.business.rate.rateservice.RateServiceSession. calculateRateService(RateServiceSession.java:1294)
at glog.business.rate.rateservice.RateServiceSession. calculateRateServiceSolutionWindow(RateServiceSess ion.java:1373)
at glog.business.rate.rateservice.RateServiceSession. calculateSinglePathRateServiceSolutionWindow(RateS erviceSession.java:1547)
at glog.business.shipment.LegOptionOptimizer.calculat eServiceTime(LegOptionOptimizer.java:462)
at glog.business.shipment.LegOptionOptimizer.getCheap estFeasibleOption(LegOptionOptimizer.java:297)
at glog.business.shipment.LegOptionOptimizer.buildIti neraryOptionOnBestLegOptions(LegOptionOptimizer.ja va:109)
at glog.business.shipment.ShipmentBuilder.buildBestIt ineraryOption(ShipmentBuilder.java:1389)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraph(ShipmentBuilder.java:1417)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraphCollection(ShipmentBuilder.java:467)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraphCollection(ShipmentBuilder.java:409)
at glog.business.consolidation.bulkplan.BuildShipment GraphCollectionTask.executePlanning(BuildShipmentG raphCollectionTask.java:25)
at glog.business.util.PlanningTask.execute(PlanningTa sk.java:15)
at glog.server.workflow.tasklist.Task.perform(Task.ja va:51)
at glog.server.workflow.tasklist.TaskList.executeInCa llerThread(TaskList.java:117)
at glog.business.util.PlanningTaskList.executeInCalle rThread(PlanningTaskList.java:80)
at glog.server.workflow.tasklist.TaskList.execute(Tas kList.java:97)
at glog.server.workflow.tasklist.TaskList.execute(Tas kList.java:15
at glog.business.consolidation.bulkplan.OrderPlanner. buildDirectShipmentGraphCollection(OrderPlanner.ja va:771)
at glog.business.consolidation.bulkplan.OrderPlanner. makeDirectTShipments(OrderPlanner.java:714)
at glog.business.consolidation.bulkplan.OrderPlanner. bulkPlan(OrderPlanner.java:306)
at glog.business.action.order.OrderActions.planUnassi gnedOrders(OrderActions.java:820)
at glog.business.action.order.BulkPlanActionExecutor. planOrders(BulkPlanActionExecutor.java:25
at glog.business.action.order.BulkPlanActionExecutor. planOrders(BulkPlanActionExecutor.java:113)
at glog.business.session.OrderActionSessionBean.planO rders(OrderActionSessionBean.java:947)
at glog.business.session.OrderActionSessionServerSide EJBWrapper.planOrders(OrderActionSessionServerSide EJBWrapper.java:1026)
at sun.reflect.GeneratedMethodAccessor299.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxNotSu pportedInterceptor.invoke(TxNotSupportedIntercepto r.java:43)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:47)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invo ke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 7)
at OrderActionSessionHome_RemoteProxy_6iid3ag.planOrd ers(Unknown Source)
at
When I am trying to crun bulk plan then Bulk plan is failing to plan the shipment. However when I am running RIQ then my results are coming correctly. On looking at logs, this error seems to be the problem, I am using pcmiler for calculating rate distance, rate distance type has been taken as PC Mile:
2008-06-30 12:51:08.023 378751 Error Exception insert into distance_lookup (x_lane_gid,rate_distance_gid,distance_value,domai n_name,distance_value_uom_code,distance_value_base ) values (?,?,?,?,?,?); [TEST.186, TEST.PC MILE, 1454.8 MI, TEST] [batch - 1]
2008-06-30 12:51:08.026 378751 Error Exception Cannot add the DISTANCE_LOOKUP record. [X_LANE_GID, RATE_DISTANCE_GID] must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_DISTANCE) violated
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_DISTANCE) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:13
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 639)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:185)
at oracle.jdbc.driver.T4CPreparedStatement.execute_fo r_rows(T4CPreparedStatement.java:633)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1161)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3001)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:3074)
at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.e xecuteUpdate(PreparedStatementBCELProxy.java:37)
at glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.j ava:133)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate. java:111)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:60 )
at glog.util.remote.BeanManagedEntityBean.executeUpda te(BeanManagedEntityBean.java:793)
at glog.util.remote.BeanManagedEntityBean$1.execute(B eanManagedEntityBean.java:195)
at glog.util.remote.BeanManagedEntityBean.dbModify(Be anManagedEntityBean.java:1066)
at glog.util.remote.BeanManagedEntityBean.doCreate(Be anManagedEntityBean.java:191)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityB ean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:79
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEnt ityBean.java:453)
at glog.ejb.rates.db.DistanceLookupBeanDB.ejbCreate(D istanceLookupBeanDB.java:52)
at DistanceLookupHome_EntityHomeWrapper893.create(Dis tanceLookupHome_EntityHomeWrapper893.java:44
at glog.business.rate.ratedistance.RateDistanceSessio n.saveDistance(RateDistanceSession.java:640)
at glog.business.rate.ratedistance.RateDistanceSessio n.calcDistance(RateDistanceSession.java:25
at glog.business.rate.ratedistance.RateDistanceSessio n.calculateDistance(RateDistanceSession.java:157)
at glog.business.rate.rateservice.RateServiceCalculat orImpl.getDistance(RateServiceCalculatorImpl.java: 240)
at glog.business.rate.rateservice.RateServiceCalculat orImpl.calculateService(RateServiceCalculatorImpl. java:96)
at glog.business.rate.rateservice.RateServiceSession. createServiceTimeResult(RateServiceSession.java:25 13)
at glog.business.rate.rateservice.RateServiceSession. calculateServiceTime(RateServiceSession.java:1751)
at glog.business.rate.rateservice.RateServiceSession. calculateRateService(RateServiceSession.java:1294)
at glog.business.rate.rateservice.RateServiceSession. calculateRateServiceSolutionWindow(RateServiceSess ion.java:1373)
at glog.business.rate.rateservice.RateServiceSession. calculateSinglePathRateServiceSolutionWindow(RateS erviceSession.java:1547)
at glog.business.shipment.LegOptionOptimizer.calculat eServiceTime(LegOptionOptimizer.java:462)
at glog.business.shipment.LegOptionOptimizer.getCheap estFeasibleOption(LegOptionOptimizer.java:297)
at glog.business.shipment.LegOptionOptimizer.buildIti neraryOptionOnBestLegOptions(LegOptionOptimizer.ja va:109)
at glog.business.shipment.ShipmentBuilder.buildBestIt ineraryOption(ShipmentBuilder.java:1389)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraph(ShipmentBuilder.java:1417)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraphCollection(ShipmentBuilder.java:467)
at glog.business.shipment.ShipmentBuilder.buildShipme ntGraphCollection(ShipmentBuilder.java:409)
at glog.business.consolidation.bulkplan.BuildShipment GraphCollectionTask.executePlanning(BuildShipmentG raphCollectionTask.java:25)
at glog.business.util.PlanningTask.execute(PlanningTa sk.java:15)
at glog.server.workflow.tasklist.Task.perform(Task.ja va:51)
at glog.server.workflow.tasklist.TaskList.executeInCa llerThread(TaskList.java:117)
at glog.business.util.PlanningTaskList.executeInCalle rThread(PlanningTaskList.java:80)
at glog.server.workflow.tasklist.TaskList.execute(Tas kList.java:97)
at glog.server.workflow.tasklist.TaskList.execute(Tas kList.java:15
at glog.business.consolidation.bulkplan.OrderPlanner. buildDirectShipmentGraphCollection(OrderPlanner.ja va:771)
at glog.business.consolidation.bulkplan.OrderPlanner. makeDirectTShipments(OrderPlanner.java:714)
at glog.business.consolidation.bulkplan.OrderPlanner. bulkPlan(OrderPlanner.java:306)
at glog.business.action.order.OrderActions.planUnassi gnedOrders(OrderActions.java:820)
at glog.business.action.order.BulkPlanActionExecutor. planOrders(BulkPlanActionExecutor.java:25
at glog.business.action.order.BulkPlanActionExecutor. planOrders(BulkPlanActionExecutor.java:113)
at glog.business.session.OrderActionSessionBean.planO rders(OrderActionSessionBean.java:947)
at glog.business.session.OrderActionSessionServerSide EJBWrapper.planOrders(OrderActionSessionServerSide EJBWrapper.java:1026)
at sun.reflect.GeneratedMethodAccessor299.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.evermind.server.ejb.interceptor.joinpoint.EJBJ oinPointImpl.invoke(EJBJoinPointImpl.java:35)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.TxNotSu pportedInterceptor.invoke(TxNotSupportedIntercepto r.java:43)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.Securit yRoleInterceptor.invoke(SecurityRoleInterceptor.ja va:47)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.interceptor.system.DMSInte rceptor.invoke(DMSInterceptor.java:52)
at com.evermind.server.ejb.interceptor.InvocationCont extImpl.proceed(InvocationContextImpl.java:119)
at com.evermind.server.ejb.InvocationContextPool.invo ke(InvocationContextPool.java:55)
at com.evermind.server.ejb.StatelessSessionEJBObject. OC4J_invokeMethod(StatelessSessionEJBObject.java:8 7)
at OrderActionSessionHome_RemoteProxy_6iid3ag.planOrd ers(Unknown Source)
at