Hi Guys,
We have a DW solution where we want to include some Product category fields. But when saving the productgroup with the new product category it crashes.
It returns with the following .net error:
[SqlException (0x80131904): The UPDATE statement conflicted with the FOREIGN KEY constraint "EcomGroups$CategoryID". The conflict occurred in database "Dynamicweb-ply", table "dbo.EcomProductCategories", column 'CategoryID'. The statement has been terminated.] System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +1661008 System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +53 System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +2415 System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +57 System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +188 Dynamicweb.Ecommerce.Products.Group.Save(String groupId, String groupLanguageId) +3703 Dynamicweb.Ecommerce.Products.Group.set_Category(Category Value) +169 Dynamicweb.Admin.eComBackend.EcomGroupEdit.Save(String languageId) in E:\Agent\_work\94\s\01 - Applications\Dynamicweb.Admin\DW92\Dynamicweb.Admin\Admin\Module\eCom_Catalog\dw7\edit\EcomGroup_Edit.aspx.vb:597 Dynamicweb.Admin.eComBackend.EcomGroupEdit.RBSave_Click(Object sender, EventArgs e) in E:\Agent\_work\94\s\01 - Applications\Dynamicweb.Admin\DW92\Dynamicweb.Admin\Admin\Module\eCom_Catalog\dw7\edit\EcomGroup_Edit.aspx.vb:824 Dynamicweb.Controls.RibbonBarButton.RaisePostBackEvent(String eventArgument) +46 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5062
It's on 9.2.16, and recently upgraded coming from 8.9.
Any suggestions?
BR, Jesse
