SOLVED: Problem creating Purchase Order

[Nathan C Hampton]

That's it!  The 'No Shipping' entry was missing.  Apparently I'd been  
staring at it too long to see what was apparently staring me in the  
face.

Thanks BJ!
On Dec 2, 2008, at 10:34 AM, BJ Freeman wrote:

looks like you don't have the _NA_ in your tables.
might sift through the demo data to see what table _NA_ is put in.
_NA_ is so the relationships don't break.

Nathan C Hampton sent the following on 12/2/2008 9:33 AM:
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_)))).