Unique Constraint Violation When Adding a Shipment to a Shipment Group (Doc ID 1375772.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.2.0 to 6.2.4 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms


When trying to add a shipment to a shipment group that has a Secondary Charge, a unique constraint violation is thrown:

insert into s_ship_unit (s_ship_unit_gid,s_ship_unit_xid,transport_handling_unit_gid,unit_length,unit_width,unit_height,unit_weight,unit_volume,flex_commodity_code,flex_commodity_qual_gid,is_splitable,ship_unit_count,early_pickup_date,received_weight,received_volume,received_ship_unit_count,ship_unit_gid,unit_net_weight,unit_net_volume,received_net_weight,received_net_volume,core_diameter,unit_diameter,tag_1,tag_2,tag_3,tag_4,t_ship_unit_gid,is_count_splittable,total_gross_weight,total_gross_volume,range_start,range_end,domain_name,total_gross_volume_uom_code,total_gross_weight_uom_code,unit_diameter_uom_code,core_diameter_uom_code,received_net_volume_uom_code,received_net_weight_uom_code,unit_net_volume_uom_code,unit_net_weight_uom_code,received_volume_uom,received_weight_uom,unit_volume_uom_code,unit_weight_uom_code,unit_height_uom_code,unit_width_uom_code,unit_length_uom_code,total_gross_volume_base,total_gross_weight_base,unit_diameter_base,core_diameter_base,received_net_volume_base,received_net_weight_base,unit_net_volume_base,unit_net_weight_base,received_volume_base,received_weight_base,unit_volume_base,unit_weight_base,unit_height_base,unit_width_base,unit_length_base) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Cannot add the S_SHIP_UNIT record. S_SHIP_UNIT_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_S_SHIP_UNIT) violated

java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_S_SHIP_UNIT) violated

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9447)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:142)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:238)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:161)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:90)
at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:358)
at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:302)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:197)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:232)
at glog.business.util.EntitySaver.insert(EntitySaver.java:252)
at glog.business.util.Persistence.insertupdate(Persistence.java:336)
at glog.business.shipment.PlanningObjectCommitter.commitTSShipUnits(PlanningObjectCommitter.java:586)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraphUnlocked(ShipmentUpdateSessionBean.java:1483)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:1278)
at glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateSessionServerSideEJBWrapper.java:344)
at glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:1814)
at glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateSessionServerSideEJBWrapper.java:303)
at glog.business.shipment.ShipmentUpdateSessionHome_qj7mtr_EOImpl.commitShipmentGraph(ShipmentUpdateSessionHome_qj7mtr_EOImpl.java:1666)
at glog.business.action.SecondaryChargeActionExecutor.reassociateSCShipmentsForShipmentGroup(SecondaryChargeActionExecutor.java:493)
at glog.business.action.ShipmentGroupActionExecutor.addShipmentsToShipmentGroups(ShipmentGroupActionExecutor.java:307)
at glog.business.session.ShipmentGroupActionSessionBean.addShipmentsToShipmentGroups(ShipmentGroupActionSessionBean.java:80)
at glog.business.session.ShipmentGroupActionSessionServerSideEJBWrapper.addShipmentsToShipmentGroups(ShipmentGroupActionSessionServerSideEJBWrapper.java:95)
at glog.business.session.ShipmentGroupActionSessionServerSideEJBWrapper_9x5sd7_EOImpl.addShipmentsToShipmentGroups(ShipmentGroupActionSessionServerSideEJBWrapper_9x5sd7_EOImpl.java:71)
at glog.business.session.gen.ShipmentGroupActionSessionSkel.addShipmentsToShipmentGroups(ShipmentGroupActionSessionSkel.java:145)
at glog.business.session.gen.ShipmentGroupActionSessionSkel.exec(ShipmentGroupActionSessionSkel.java:50)
at glog.webserver.wrapper.SkelImpl.execDispatch(SkelImpl.java:15)
at glog.server.wrapper.WrapperSessionBean.execDispatch(WrapperSessionBean.java:62)
at glog.server.wrapper.WrapperSessionServerSideEJBWrapper.execDispatch(WrapperSessionServerSideEJBWrapper.java:48)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl.execDispatch(WrapperSessionHome_a06097_EOImpl.java:58)
at glog.server.wrapper.WrapperSessionHome_a06097_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

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