I'm trying to create a purchase order, and keep getting the error
below. I'm not completely certain, but I suspect a configuration
problem (the demo site doesn't have this issue). I've tried tracing
the execution through the source code (which is how I solved my last
problem), but I can't even figure out where things are going wrong. I
checked the JIRA on the off chance it was a bug, but didn't see
anything. I'm not sure where to go next, so any assistance would be
appreciated!
--Nathan
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,
10007(java.lang.String)][createdStamp,2008-11-26
14:04:36.077(java.sql.Timestamp)][createdTxStamp,2008-11-26
14:04:35.736(java.sql.Timestamp)][facilityId,null()]
[giftMessage,null()][isGift,N(java.lang.String)][lastUpdatedStamp,
2008-11-26 14:04:36.077(java.sql.Timestamp)][lastUpdatedTxStamp,
2008-11-26 14:04:35.736(java.sql.Timestamp)]
[maySplit,Y(java.lang.String)][orderId,F10013(java.lang.String)]
[shipAfterDate,null()][shipByDate,null()][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, 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`
(`SHIPMENT_)))).
