Problem creating Purchase Order

[Nathan C Hampton]

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

[BJ Freeman]

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

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