Getting errors with certain functions

[Brewhaus]

We are getting errors when we try to perform certain functions, such as deleting a product. The product may delete, but we get an error page, and when we check the error log we receive the following error:

An error has occured at https://www.hotsaucedepot.com/Admin/Cat ... goryId=119
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.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.admin_catalog_browse_aspx.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._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at CommerceBuilder.DomainModel.EntityWithTypedId`1.Delete() at AbleCommerce.Admin.Catalog.Browse.DoDelete(CatalogNodeType catalogNodeType, Int32 catalogNodeId) at AbleCommerce.Admin.Catalog.Browse.CGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.OnRowCommand(GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) 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.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 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._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at CommerceBuilder.DomainModel.EntityWithTypedId`1.Delete() at AbleCommerce.Admin.Catalog.Browse.DoDelete(CatalogNodeType catalogNodeType, Int32 catalogNodeId) at AbleCommerce.Admin.Catalog.Browse.CGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.OnRowCommand(GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) 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.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 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._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at CommerceBuilder.DomainModel.EntityWithTypedId`1.Delete() at AbleCommerce.Admin.Catalog.Browse.DoDelete(CatalogNodeType catalogNodeType, Int32 catalogNodeId) at AbleCommerce.Admin.Catalog.Browse.CGrid_RowCommand(Object sender, GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.OnRowCommand(GridViewCommandEventArgs e) at System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) at System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) 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.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


I believe that it is a permissions issue, but nowhere can we find the correct permission settings for AC. We are getting a couple of other errors, but I am sure that they will also be corrected by setting the permissions correctly. Can anyone help with this?

[compunerdy]

AC does have a file for testing permissions but the last time I ran it I got false positives so not sure if it would work for you or not..

It is discussed and linked to at the bottom of this page.. http://help.ablecommerce.com/installati ... erce_7.htm

Not sure it is the same for Gold and like I said it did not work correctly for me last time I used it..

[Katie]

The permissions are checked before the installation will continue, and it's always worked for me. I recently tested an install on GoDaddy, and the permissions failed until I manually set them up using the Godaddy hosting system.

Did you change the permissions after installing AbleCommerce? If not, could this be related to the customization where you have 2 installs using the same database?

[Brewhaus]

I have not changed anything since the upgrades. When moving to Gold we had to split onto separate DBs (which has resulted in some processing hassles), but the two sites are now completely independent, with their own DB. I am guessing that it is a permissions issue as we can delete items on brewhaus.com, but have the issue stated above when trying to delete on hotsaucedepot.com.

[Brewhaus]

After giving this more thought, I am able to add products, alter product information, etc., but deleting products or categories is an issue. We also had problems deleting the UPS shipping methods (after upgrading we had to completely remove the UPS instance and re-integrate it in order for it to work). Does that help at all?

[Katie]

Deleting products and categories is a database function. If the database didn't have permissions, then it wouldn't work at all. This must be something specific to your one installation, so check over the files carefully and make sure that they are stock for the version you are using. I could be wrong, but the error message doesn't make much sense to me. Hopefully a developer can take a look and provide better feedback.

[ForumsAdmin]

Check if someone has mistakenly set db_denydatawriter role for the db user in the database.

[Brewhaus]

Nope:

db_accessadmin
db_datareader
db_datawriter
db_ddladmin
db_securityadmin

We have had a couple of items that did not give us an error when we deleted them, so it is odd.

As for the version of the files, we created a completely new installation by downloading the Gold R6 trial into a new folder, and setting up our layout, etc., so if the files in the download were correct then the files in our folder would have to be.

[Brewhaus]

We are now even finding items that we are unable to delete. When we try to delete them we immediately get the error page, and the item remains in the system. Any thoughts?

Also, we tried creating another Gold R6 site using the DEV key, and gave the web folder Modify permissions for both the USER and Network Service, hoping that maybe it was just a permissions issue to a folder. The hope was that we could delete the products and then turn the DEV site back off. We had the same issue, so I have to assume that it is not a permissions issue, at least not to any of the AC folders.

[compunerdy]

Have you tried using a different browser?

[Brewhaus]

Just tried another browser- no luck.

AC is checking into it now, so if we find out the problem I will post it so that if someone else has the same issue the can find the answer.

[compunerdy]

Using IE 11 I cannot log into my test site that has R6.. It might be fixed by doing the .net patch. When I click sign in or enter after putting in my password it does nothing..

I did try using firefox and was able to delete items though.

[Brewhaus]

I have tried with IE9, IE10, and FF25. All gave the same error.

I think that the only reason I still use IE is because it is familiar. I curse FF every time I open it, as it invariably has some update to do so it takes forever to open. Chrome may be my next option...

[Katie]

I was able to confirm this as a bug when deleting a product that had been assigned to a Product Accessory that was already deleted.

[jmestep]

Katie, that is good info. We are having trouble deleting products on an R6 site and I think it's the same issue. I just hadn't started troubleshooting yet because it wasn't a show-stopper.

[Brewhaus]

Has there been an updated on this? There are items that will not delete at all, and we would like to clear them from the list.

[Katie]

We have fixed this so it won't happen in future versions, however, it wasn't possible to provide a patch after the situation occurs. What we are planning is to write something into the upgrade script that will remove orphaned product accessory associations. I will try to get one of the developers to post the SQL query here, but it will need to be manually run for now. Otherwise, you'll need to wait for the next release to do it automatically.

[Brewhaus]

We literally have only eight products within three sub-categories that need to be deleted, so for us at least, manually running a query will not be an issue. I can't speak for others.

[ForumsAdmin]

The following query if run on the database will eliminate the orphaned accessory associations.

Code: Select all

delete from ac_UpsellProducts where ChildProductId not in (select ProductId from ac_Products)

[Brewhaus]

Perfect! Thank you.

[ForumsAdmin]

Note for reference : The query above is added for upcoming R7.