Problem creating Purchase Order

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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_)))).
Reply | Threaded
Open this post in threaded view
|

Re: Problem creating Purchase Order

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_)))).
>
>
Reply | Threaded
Open this post in threaded view
|

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