You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Nathan C Hampton <of...@nhampton.net> on 2008/12/02 18:33:46 UTC
Problem creating Purchase Order
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_)))).
SOLVED: Problem creating Purchase Order
Posted by Nathan C Hampton <of...@nhampton.net>.
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_)))).
>>
>>
>
Re: Problem creating Purchase Order
Posted by BJ Freeman <bj...@free-man.net>.
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_)))).
>
>