Announcement

Collapse
No announcement yet.

Change Shipment External Status

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Change Shipment External Status

    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

  • #2
    Re: Change Shipment External Status

    Hi,
    After creating the new customised status is this the first time you are trying that status. I think there could have been some error while uploading the Status thru CSV or while creating of the status.
    Regards,


    Raveendranath Thalapalli

    Comment


    • #3
      Re: Change Shipment External Status

      I am working in a barcode producing company.We have a requirement to prevent the status change once the status reached the final stage (e.g. Ship confirmed) with in that status type. But our action check prevents change of statuses belong all external status types. Change of external status can't be made post check as well. Is there a way we can achieve this? Appreciate your help on this.

      Comment


      • #4
        Re: Change Shipment External Status

        I am working in a barcode producing company.We have a requirement to prevent the status change once the status reached the final stage (e.g. Ship confirmed) with in that status type. But our action check prevents change of statuses belong all external status types. Change of external status can't be made post check as well. Is there a way we can achieve this? Appreciate your help on this.

        Comment

        Working...
        X
        😀
        🥰
        🤢
        😎
        😡
        👍
        👎