London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
CartHelper AddEntry INSERT statement conflicted with the FOREIGN KEY constraint FK_OrderForm_OrderGroup in table dbo.OrderGroup column OrderGroupId
As this can't be reproduced in our standard environment, I suspect this your site-related. I'd suggest you to contact our developer support service so we can reproduce the issue and take further actions.
Regards,
/Q
Mar 27, 2017 10:04
We solved this by modifying the stored procedure mdpsp_avto_LineItemEx_Update - by removing parameters @f1, @f2, etc, which seem to be orphaned after we removed some Meta Fields associations from the LineItemEx Meta Class in the Commerce Manager UI?
Are the stored procedures not updated when Meta Class / Field associations are updated from the Commerce Manager UI?
This might be something originating from the Commerce Starter Kit if it can not be reproduced in a clean Commerce site.
Steps to reproduce:
- Extend LineItemEx with custom meta fields
- In code, when adding something to cart (using CartHelper), populated the meta fields using something something similar to AddCustomProperties (see below)
- Remove meta field associations
- Add to cart (using CartHelper), now without setting the meta fields
- Fails with exception where the mentioned stored procedure expects a parameter which is not supplied
The LineItem parameter is a custom class
Snippet
private void AddCustomProperties(LineItem lineItem, Cart cart) { var item = cart.OrderForms[0].LineItems.FindItemByCatalogEntryId(lineItem.Code); // Make sure we have all available data on the item before // we proceed lineItem.UpdateData(item); //TODO: Let specific model implementation populate these fields, we need to know too much about the model here item["SomeCustomMetaField"] = lineItem.SomeProperty; cart.AcceptChanges(); }
Mar 28, 2017 11:53
Hi,
It should (update the stored procedures when you change the metaclasses). I would suggest you to check if [mdpsp_sys_CreateMetaClassProcedure] and [mdpsp_sys_CreateMetaClassProcedureAll] are correct (match with the same vanilla version), then run [mdpsp_sys_CreateMetaClassProcedureAll] to make sure all of metaclass stored procedures are update-to-date with their metaclasses
Mar 28, 2017 12:02
<p>I have installed a vanilla Commerce site, and comparing to our site, the procedures are identical (using WinMerge)</p>
<p>I ran <span> [mdpsp_sys_CreateMetaClassProcedureAll], which gave return value = 0</span></p>
<p><span>Hope that solves it!</span></p>
#176823
Mar 28, 2017 14:13
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Hello
In Episerver Commerce 10.3.0 when executing the following code:
we get an exception:
There has not been added items to any carts and tables OrderGroup, OrderForm OrderGroupNote, LineItems or any other table having todo with orders or line items are empty except OrderNoteType and OrderStatus.
The entries/variants being added have valid price and inventory set.
The OrderGroupId and OrderFormId in cartHelper.OrderForm keep getting incremented every time we call AddEntry. The previouse line items that has been attempted to add earlier can be found in cartHelper.LineItems, but nothing is showing up in the db.
Is there some way to resolve this?