You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Gurcharan Singh <gu...@gmail.com> on 2007/08/13 09:01:27 UTC
Fwd: Service Error [To: itanium@itaniumdubaiinternetcity.com, Cc: null, Bcc: null]

Hello,

On packaging a sales order I'm getting the error - No inventory reservations
available. Could anyone pls see where I'm making the mistake.

---- My ERROR LOG----

The service : updateShipment

The Context :
      primaryShipGroupSeqId --> 00001
      handlingInstructions -->
      originFacilityId -->
      partyIdTo -->
      destinationTelecomNumberId -->
      picklistBinId -->
      currencyUomId -->
      locale --> en_US
      originContactMechId -->
      estimatedArrivalDate -->
      userLogin --> [GenericEntity:UserLogin][createdStamp,2007-08-12
17:11:48.782(java.sql.Timestamp)][createdTxStamp,2007-08-12
17:11:47.968(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2007-08-12
17:11:48.921(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-12
17:11:48.796(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][successiveFailedLogins,null()][userLoginId,admin(java.lang.String)]
      partyIdFrom --> 10012
      primaryOrderId --> WS10003
      statusId --> PURCH_SHIP_CREATED
      shipmentTypeId --> DROP_SHIPMENT
      additionalShippingCharge -->
      originTelecomNumberId -->
      estimatedReadyDate -->
      shipmentId --> 10005
      destinationFacilityId -->
      estimatedShipDate -->
      estimatedShipCost --> 0
      latestCancelDate -->
      destinationContactMechId --> MyRetailStore

The Result :
      errorMessage --> ERROR: Could not complete the Update Shipment
[file:/C:/ERPDev/opentaps/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#updateShipment]
process [problem storing the lookedUpValue value: Exception while
updating the following entity:
[GenericEntity:Shipment][additionalShippingCharge,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-08-13
10:10:35.875(java.sql.Timestamp)][createdStamp,2007-08-13
10:10:37.532(java.sql.Timestamp)][createdTxStamp,2007-08-13
10:10:35.875(java.sql.Timestamp)][currencyUomId,null()][destinationContactMechId,MyRetailStore(java.lang.String)][destinationFacilityId,null()][destinationTelecomNumberId,null()][estimatedArrivalDate,null()][estimatedArrivalWorkEffId,10011(java.lang.String)][estimatedReadyDate,null()][estimatedShipCost,0.0(java.lang.Double)][estimatedShipDate,null()][estimatedShipWorkEffId,10010(java.lang.String)][handlingInstructions,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-08-13
10:11:05.687(java.sql.Timestamp)][lastUpdatedStamp,2007-08-13
10:11:05.687(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-13
10:11:05.671(java.sql.Timestamp)][latestCancelDate,null()][originContactMechId,null()][originFacilityId,null()][originTelecomNumberId,null()][partyIdFrom,10012(java.lang.String)][partyIdTo,null()][picklistBinId,null()][primaryOrderId,WS10003(java.lang.String)][primaryShipGroupSeqId,00001(java.lang.String)][shipmentId,10005(java.lang.String)][shipmentTypeId,DROP_SHIPMENT(java.lang.String)][statusId,PURCH_SHIP_CREATED(java.lang.String)]
(while updating:
[GenericEntity:Shipment][additionalShippingCharge,null()][createdByUserLogin,admin(java.lang.String)][createdDate,2007-08-13
10:10:35.875(java.sql.Timestamp)][createdStamp,2007-08-13
10:10:37.532(java.sql.Timestamp)][createdTxStamp,2007-08-13
10:10:35.875(java.sql.Timestamp)][currencyUomId,null()][destinationContactMechId,MyRetailStore(java.lang.String)][destinationFacilityId,null()][destinationTelecomNumberId,null()][estimatedArrivalDate,null()][estimatedArrivalWorkEffId,10011(java.lang.String)][estimatedReadyDate,null()][estimatedShipCost,0.0(java.lang.Double)][estimatedShipDate,null()][estimatedShipWorkEffId,10010(java.lang.String)][handlingInstructions,null()][lastModifiedByUserLogin,admin(java.lang.String)][lastModifiedDate,2007-08-13
10:11:05.687(java.sql.Timestamp)][lastUpdatedStamp,2007-08-13
10:11:05.687(java.sql.Timestamp)][lastUpdatedTxStamp,2007-08-13
10:11:05.671(java.sql.Timestamp)][latestCancelDate,null()][originContactMechId,null()][originFacilityId,null()][originTelecomNumberId,null()][partyIdFrom,10012(java.lang.String)][partyIdTo,null()][picklistBinId,null()][primaryOrderId,WS10003(java.lang.String)][primaryShipGroupSeqId,00001(java.lang.String)][shipmentId,10005(java.lang.String)][shipmentTypeId,DROP_SHIPMENT(java.lang.String)][statusId,PURCH_SHIP_CREATED(java.lang.String)]
(SQL Exception while executing the following:UPDATE public.SHIPMENT
SET SHIPMENT_TYPE_ID=?, STATUS_ID=?, PRIMARY_ORDER_ID=?,
PRIMARY_SHIP_GROUP_SEQ_ID=?, PICKLIST_BIN_ID=?,
ESTIMATED_READY_DATE=?, ESTIMATED_SHIP_DATE=?,
ESTIMATED_SHIP_WORK_EFF_ID=?, ESTIMATED_ARRIVAL_DATE=?,
ESTIMATED_ARRIVAL_WORK_EFF_ID=?, LATEST_CANCEL_DATE=?,
ESTIMATED_SHIP_COST=?, CURRENCY_UOM_ID=?, HANDLING_INSTRUCTIONS=?,
ORIGIN_FACILITY_ID=?, DESTINATION_FACILITY_ID=?,
ORIGIN_CONTACT_MECH_ID=?, ORIGIN_TELECOM_NUMBER_ID=?,
DESTINATION_CONTACT_MECH_ID=?, DESTINATION_TELECOM_NUMBER_ID=?,
PARTY_ID_TO=?, PARTY_ID_FROM=?, ADDITIONAL_SHIPPING_CHARGE=?,
CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?,
LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
SHIPMENT_ID=? (ERROR: insert or update on table "shipment" violates
foreign key constraint "shpmnt_dpad"
  Detail: Key (destination_contact_mech_id)=(MyRetailStore) is not
present in table "postal_address".)))]
      oldPrimaryOrderId --> WS10003
      responseMessage --> error
      shipmentTypeId --> DROP_SHIPMENT
      oldStatusId --> PURCH_SHIP_CREATED


Thanking you,
Gurcharan

--