|
|
Hi,
I am getting an error when creating a Purchase Order. Can anyone tell me what I am doing wrong and how to fix it.
The Following Errors Occurred:
Did not complete the order, the following occurred:ERROR : Could not create order (write error :Error while inserting: [GenericEntity:OrderItemShipGroup][carrierPartyId,_NA_(java.lang.String)][carrierRoleTypeId,CARRIER(java.lang.String)][contactMechId,10020(java.lang.String)][createdStamp,2010-03-29 12:37:28.237(java.sql.Timestamp)][createdTxStamp,2010-03-29 12:37:28.0(java.sql.Timestamp)][facilityId,null()][giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,2010-03-29 12:37:28.237(java.sql.Timestamp)][lastUpdatedTxStamp,2010-03-29 12:37:28.0(java.sql.Timestamp)][maySplit,N(java.lang.String)][orderId,10012(java.lang.String)][shipAfterDate,2010-03-29 11:49:02.0(java.sql.Timestamp)][shipByDate,2010-03-31 11:49:09.0(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)][shipmentMethodTypeId,NO_SHIPPING(java.lang.String)][shippingInstructions,null()][supplierPartyId,null()][vendorPartyId,null()] (SQL Exception while executing the following:INSERT INTO ORDER_ITEM_SHIP_GROUP (ORDER_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_METHOD_TYPE_ID, SUPPLIER_PARTY_ID, VENDOR_PARTY_ID, CARRIER_PARTY_ID, CARRIER_ROLE_TYPE_ID, FACILITY_ID, CONTACT_MECH_ID, TELECOM_CONTACT_MECH_ID, TRACKING_NUMBER, SHIPPING_INSTRUCTIONS, MAY_SPLIT, GIFT_MESSAGE, IS_GIFT, SHIP_AFTER_DATE, SHIP_BY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_DELIVERY_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`order_item_ship_group`, CONSTRAINT `ORDER_ITSG_CSHM` FOREIGN KEY (`SHIPMENT_METHOD_TYPE_ID`, `CARRIER_PARTY_ID`, `CARRIER_ROLE_TYPE_ID`) REFERENCES `carrier_shipment_method` (`SHIPMEN)))).
Purchase Order : Order Confirmation
Create OrderReview OrderPartiesOptionsShippingOrder TermsOrder Items
Order Name pad
--------------------------------------------------------------------------------
Order Terms Term Type Term Value Term Days Description
--------------------------------------------------------------------------------
Payment (net days) 30
--------------------------------------------------------------------------------
Splitting Preference Please wait until the entire order is ready before shipping.
--------------------------------------------------------------------------------
Ship After Date 2010-03-29 11:49:02.000
Ship Before Date 2010-03-31 11:49:09.000
Shipping InformationDestination Supplier Shipment Method Item Quantity
--------------------------------------------------------------------------------
To: ABC Decorative Rugs
Attn: Farhan Qazi
1 Henry Adams St.
San Francisco CA , 94103 No Shipping 10000 - GRPPLU12X660 TAUPE Solid Plus 12x60 2
--------------------------------------------------------------------------------
Grand Total $680.00
|
Locked
