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_)))). |
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_)))). > > |
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_)))). >> >> > |
Free forum by Nabble | Edit this page |