violation of foreign key constraint ORDER_ITSG_CSHM

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

violation of foreign key constraint ORDER_ITSG_CSHM

ofbiz-noob
I am trying to enter an order, and I receive when creating the order:
ERROR: Could not create order (problem invoking the service: could not commit transaction for service [checkCreateDropShipPurchaseOrders]
..
Failure in create operation for entity [OrderItemShipGroup]
...
INSERT on table ORDER_ITEM_SHIP_GROUP caused a violation of foreign key constraint ORDER_ITSG_CSHM for key(NO_SHIPPING,_NA_,CARRIER)

I do not know why the shipping method is being specified as NO_SHIPPING, since I selected a different method type earlier on in the order.

I am using ofbiz 13.07.01, but I'm sure my configuration is the problem, as I setup my stores and shipment types manually.

Any assistance would be greatly appreciated!

Reply | Threaded
Open this post in threaded view
|

Re: violation of foreign key constraint ORDER_ITSG_CSHM

ofbiz-noob
I had create and import an xml Party entry for partyId="_NA_"... and then give it the role of carrier, add it to the shipment methods, etc. I am still not sure why, when I selected a different method, this was the data being search for in the database.

I am building my site form scratch, instead of modifying the example data.
Reply | Threaded
Open this post in threaded view
|

Re: violation of foreign key constraint ORDER_ITSG_CSHM

Christian Carlow-OFBizzer
I think this issue will solve this problem once resolved:
https://issues.apache.org/jira/browse/OFBIZ-6093

On Tue, 2015-04-14 at 11:10 -0700, ofbiz-noob wrote:

> I had create and import an xml Party entry for partyId="_NA_"... and then
> give it the role of carrier, add it to the shipment methods, etc. I am still
> not sure why, when I selected a different method, this was the data being
> search for in the database.
>
> I am building my site form scratch, instead of modifying the example data.
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/violation-of-foreign-key-constraint-ORDER-ITSG-CSHM-tp4666547p4666595.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.