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_)))). > >
