Location Gid - unique constraint (GLOGOWNER.PK_LOCATION) violated During Shipment Integration. (Doc ID 1343697.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 6.1.0 version,

When attempting to process incoming shipments XMLs coming from external system at the same time with the same location with a transaction code of IU, the transmission errors with the following exception.

ERROR
-----------------------
Cannot add the LOCATION record. LOCATION_GID must be unique.
java.sql.BatchUpdateException: ORA-00001: unique constraint (GLOGOWNER.PK_LOCATION) 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:191)
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.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:171)
at glog.util.persistence.BeanDataPersistenceExecutor.insertPerformed(BeanDataPersistenceExecutor.java:97)
at glog.util.persistence.BeanDataPersistenceExecutor.insertUpdatePerformed(BeanDataPersistenceExecutor.java:116)
at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:93)
at glog.util.persistence.InsertUpdate.doPersist(InsertUpdate.java:100)
at glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:54)
at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:122)
at glog.server.compareengine.TopicPublisher.persist(TopicPublisher.java:161)
at glog.server.compareengine.TopicPublisher.publish(TopicPublisher.java:64)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:110)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:71)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compare(GenericContainerUtilSessionBean.java:139)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compareAndStore(GenericContainerUtilSessionBean.java:76)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:157)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.java:286)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persist(XmlBaseWrapper.java:250)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:333)
at glog.integration.application.location.LocationInterface.persistIndivXML(LocationInterface.java:97)
at glog.integration.application.location.LocationInterface.persistXML(LocationInterface.java:85)
at glog.integration.application.shipment.ShipmentWrapper.map(ShipmentWrapper.java:217)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:313)
at glog.integration.application.shipment.ShipmentWrapper.persistViaContainer(ShipmentWrapper.java:1115)
at glog.integration.application.shipment.ShipmentInterface.persistIndivXML(ShipmentInterface.java:269)
at glog.integration.application.shipment.ShipmentInterface.persistXML(ShipmentInterface.java:208)
at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:195)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:224)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:363)
at glog.server.workflow.transproc.TransProc.execute(TransProc.java:106)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:353)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:353)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
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:619)

Cause

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