Hi,
We have created a shipment and we have tried to change an external status. The status we are trying to change is a customize status. We are getting an error. It looks like
OTM is trying to do an insert instead of an update for the status.
Does anyone know how to solve this?
Thanks in advance.
The log error:
insert into shipment_status (shipment_gid,status_type_gid,status_value_gid,dom ain_name) values (?,?,?,?); [FED.VI080515082, FED.XX_SH_LOAD_PRIO_CN, FED.LOAD_NOP_DIMOD, FED] [RMICallHandler-109]
Cannot add the SHIPMENT_STATUS record. [SHIPMENT_GID, STATUS_TYPE_GID] must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STATUS) violated
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STATUS) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TT C7Protocol.java:1114)
at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:2181)
at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:2063)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2922)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:644)
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.jdbc.SqlUpdate.execute(SqlUpdate.java:81 )
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:94 )
at glog.server.status.ObjectStatus.doInsert(ObjectSta tus.java:261)
at glog.server.status.ObjectStatus.write(ObjectStatus .java:159)
at glog.ejb.shipment.db.ShipmentBeanDB.postStore(Ship mentBeanDB.java:314
at glog.ejb.shipment.ShipmentBean.postStore(ShipmentB ean.java:412)
at glog.util.remote.BaseEntityBean$3.post(BaseEntityB ean.java:523)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:804)
at glog.util.remote.BaseEntityBean.ejbStore(BaseEntit yBean.java:520)
at glog.util.remote.BeanManagedEntityBean.ejbStore(Be anManagedEntityBean.java:50
We have created a shipment and we have tried to change an external status. The status we are trying to change is a customize status. We are getting an error. It looks like
OTM is trying to do an insert instead of an update for the status.
Does anyone know how to solve this?
Thanks in advance.
The log error:
insert into shipment_status (shipment_gid,status_type_gid,status_value_gid,dom ain_name) values (?,?,?,?); [FED.VI080515082, FED.XX_SH_LOAD_PRIO_CN, FED.LOAD_NOP_DIMOD, FED] [RMICallHandler-109]
Cannot add the SHIPMENT_STATUS record. [SHIPMENT_GID, STATUS_TYPE_GID] must be unique.
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STATUS) violated
java.sql.SQLException: ORA-00001: unique constraint (GLOGOWNER.PK_SHIPMENT_STATUS) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1957)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TT C7Protocol.java:1114)
at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:2181)
at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:2063)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2922)
at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:644)
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.jdbc.SqlUpdate.execute(SqlUpdate.java:81 )
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:94 )
at glog.server.status.ObjectStatus.doInsert(ObjectSta tus.java:261)
at glog.server.status.ObjectStatus.write(ObjectStatus .java:159)
at glog.ejb.shipment.db.ShipmentBeanDB.postStore(Ship mentBeanDB.java:314

at glog.ejb.shipment.ShipmentBean.postStore(ShipmentB ean.java:412)
at glog.util.remote.BaseEntityBean$3.post(BaseEntityB ean.java:523)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean .java:804)
at glog.util.remote.BaseEntityBean.ejbStore(BaseEntit yBean.java:520)
at glog.util.remote.BeanManagedEntityBean.ejbStore(Be anManagedEntityBean.java:50

Comment