R8 Delete Product Problem

[abradley]

We saw this issue come up in different forms on R6. Now that we are on R8 I want to start a conversation on this issue since I cant pinpoint it yet.

Today, one of our employees was on the products page in lets say category A. She went to delete a product from that category by clicking the red X icon. It showed the white error page and generated the below error message. On hitting "back", the "deleted product" was indeed gone. This was reproducible on a delete on several other products that were already existing when we upgraded to R8. Note: One weird thing that happened during this, was that a unrelated product in a different category somehow got deleted. Only reason we caught it was we happened to be checking in merchandise for that product and that product was completely gone from the product catalog.

However, if I create a new product, then try to delete it, everything works properly. This suggests it only affects products that were existing pre-upgrade. The delete did properly work on a product that has been existing for years however, so that ruins the theory of affecting all pre-upgrade products.

At this point I suspect we may have inconsistencies between our db and the R8 db schema. Anyone share my suspicion? Any guidance?


Error:

An error has occured at https://www.siteroot.com/Admin/Products ... ducts.aspx
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.ManageProducts.ProductsGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.ManageProducts.ProductsGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.ManageProducts.ProductsGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[mazhar]

Do you happen remember any special configurations with product?
- Custom URL
- up-sell products
- Does product have kitting configured

[abradley]

Hi Mazhar, I have some of the affected products left in that category that I can still delete and reproduce the issue. None of them have any custom urls, are upsell, or have kitting.

Is there anything I can look for to help, I have at least three more products I can delete and reproduce the issue.

[jmestep]

abradley, there was a bug in R6 where you couldn't delete a product if it was assigned to a product accessory that had been deleted. I think they fixed that one but this sounds similar. I just don't have an R6 upgrade to R8 project I can test with. Maybe you can tell something by looking at the table in the database.

[abradley]

Thanks Judy, I think by accessory, you meant product upsells, right? If so, the affected products were never an upsell for any other products nor had an upsells attached to them.

I have looked through the db at these products, I cant find anything unusual to my eye. Any other ideas of how to hunt this problem down?

Thanks

[jmestep]

I'm not all that adept at reading the detailed errors, but this one looks like it occurred on the manage products page- Catalog-->Products
AbleCommerce.Admin.Products.ManageProducts.ProductsGrid_RowCommand(

Are you able to delete them on the Catalog-->Categories page or the Delete button on the edit product page? That might give some clue as to whether there are some data anomalies.
Do the products or the category have anything weird in the names, like apostrophes, html tags?

[abradley]

Do the products or the category have anything weird in the names, like apostrophes, html tags?

Nothing funky here.

Are you able to delete them on the Catalog-->Categories page

This worked like a charm, could remove from the categories fine (this only removes the product from the category of course)

or the Delete button on the edit product page?

So this had the same behavior as the error in the original post. It took me to the white error screen. When navigating "back" though, the product is indeed deleted succesfully just like the original post error.

Here is the error from deleting from the edit product page:

n error has occured at https://www.siteroot.com/Admin/Products ... uctId=2452
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.EditProduct.DeleteButton_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.EditProduct.DeleteButton_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Exception has been thrown by the target of an invocation. Inner Exception Stack Trace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at AbleCommerce.Admin.Products.EditProduct.DeleteButton_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[jmestep]

I don't have the answer to it, but maybe someone at Able could spot the problem since it works in one place, but not in others.
What are you using for your search setting? Lucene, Sql search, Sql FTS? There was a problem with Lucene in an older build where if a product was in more than one category, it would show up as 2 listings on the manage products page. I think that is fixed, though. I'm just grasping at straws here.

[Katie]

This may be very difficult to track down and reproduce, especially if it only happens to products that are pre-upgrade. If the product is actually removed, we might just have to live with the error. You indicated that you only have a few more products left to delete, so maybe this is no longer an issue for you. No one else has reported a delete error, so I don't have a good answer why this is happening on your install.

[abradley]

Ok, thanks for the help Judy and Katie! As of now, yea this doesn't have any real consequences, so I agree, we can just punt and see if it presents itself again.