Order Releases Fail To Plan To Shipment In SCA Activated System Due To ORA-00001: unique constraint (Doc ID 805838.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:

Planning a shipment failed in a system where SCA is turned on, logs show the following error



2009-03-10 14:47:51.398 214172 Error Exception Cannot add the SHIPMENT record. SHIPMENT_GID must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT) violated


java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
at glog.util.jdbc.SqlUpdate.executeUpdate(SqlUpdate.java:133)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:111)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:60)
at glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:793)
at glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:195)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1066)
at glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:191)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:455)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:798)
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:453)
at glog.ejb.shipment.db.ShipmentBeanDB.ejbCreate(ShipmentBeanDB.java:215)
at glog.ejb.shipment.ejb_Shipment_2ujudi_Impl.ejbCreate(ejb_Shipment_2ujudi_Impl.java:555)
at sun.reflect.GeneratedMethodAccessor368.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at weblogic.ejb20.manager.ExclusiveEntityManager.create(ExclusiveEntityManager.java:750)
at weblogic.ejb20.manager.ExclusiveEntityManager.remoteCreate(ExclusiveEntityManager.java:721)
at weblogic.ejb20.internal.EntityEJBHome.create(EntityEJBHome.java:249)
at glog.ejb.shipment.ejb_Shipment_2ujudi_HomeImpl.create(ejb_Shipment_2ujudi_HomeImpl.java:458)
at
glog.business.shipment.ShipmentUpdateSessionBean.commitTShipment(ShipmentUpdateSessionBean.java:1637
)
at
glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentNode(ShipmentUpdateSessionBean.java:1
372)
at
glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:
3788)
at
glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateS
essionServerSideEJBWrapper.java:292)
at
glog.business.shipment.ShipmentUpdateSessionBean.commitShipmentGraph(ShipmentUpdateSessionBean.java:
3992)
at
glog.business.shipment.ShipmentUpdateSessionServerSideEJBWrapper.commitShipmentGraph(ShipmentUpdateS
essionServerSideEJBWrapper.java:260)
at
glog.business.shipment.ShipmentUpdateSessionHome_qj7mtr_EOImpl.commitShipmentGraph(ShipmentUpdateSes
sionHome_qj7mtr_EOImpl.java:748)
at glog.business.action.OrderActionExecutor.buildShipmentGraph(OrderActionExecutor.java:408)
at glog.business.action.OrderActionExecutor.buildShipments(OrderActionExecutor.java:316)
at glog.business.session.OrderActionSessionBean.buildShipments(OrderActionSessionBean.java:190)
at
glog.business.session.OrderActionSessionServerSideEJBWrapper.buildShipments(OrderActionSessionServer
SideEJBWrapper.java:130)
at
glog.business.session.OrderActionSessionHome_likuwd_EOImpl.buildShipments(OrderActionSessionHome_lik
uwd_EOImpl.java:2314)
at glog.server.agent.business.order.BuildShipment.execute(BuildShipment.java:51)
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(WorkflowSessionServer
SideEJBWrapper_61kh96_EOImpl.java:208)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:341)
at glog.server.workflow.Trigger.trigger(Trigger.java:123)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:141)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96)
at glog.util.event.EventThread.run(EventThread.java:82)
at java.lang.Thread.run(Thread.java:534)
[agentPlanning - 5]


-- Steps To Reproduce:

Bulk plan a shipment in a system where SCA is turned on

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