Site suddenly slowing down and dying every few minutes

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 7:35 am

Our AC sites (http://www.brewhaus.com and http://www.hotsaucedepot.com) have been rock solid for months. Both are running R8, both on the same server, and nothing changed. This morning the Brewhaus website started responding slowly, and given that it has been a while since we rebooted the server we tried that. Everything was normal for a couple of minutes, and then the Brewhaus website started slowing down again, until it became unresponsive and would throw a server error. A couple of times when trying to access from the front end we would get the following error:

This file is required by IIS so that your website can be accessed without a file name specified.
To edit your home page, log in to the merchant administration and go to Website > Webpages.
If you are seeing this message from the browser, you either haven't completed the web based installation for the application or something has been misconfigured.

If we restart Brewhaus in IIS then everything is fine again for a few minutes, then the issue repeats- the site starts slowing down until it hits the point of crashing. Through all of this the Hot Sauce Depot site runs perfectly.

Something else that seems odd is that the wswp.exe process for Brewhaus is using 25-50% of the CPU (nothing else registers over 0%, spiking to 2% briefly). It is also taking 750,000K to over 1,200,000K.

The error log is showing the following error repeatedly:

3/24/2015 11:10:38 AM Error
An error has occured at http://www.brewhaus.com/category.aspx?categoryid=196
Exception: Request timed out. Stack Trace:

3/24/2015 11:10:38 AM Error
Could not calculate with the configured tax provider: CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax, CommerceBuilder
Exception: Thread was being aborted. 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 CommerceBuilder.DomainModel.PersistentBag`1.Save() at CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax.Calculate(Basket basket) at CommerceBuilder.Taxes.TaxCalculator.Calculate(Basket basket)

UPDATE: every one of the errors noted above come in pairs, and all reference categoryid 196

Can anyone shed light on this? We have made no changes on the server or in the site's folder, so it is odd that this is suddenly happening. If a file somehow became corrupt then we can replace it, but we need to know what file.

We are desperate- please help!
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Katie » Tue Mar 24, 2015 8:01 am

I checked both sites and they seem to be running good now. I very much doubt this is a code problem since you said nothing has changed. I've never heard of files all-of-a-sudden becoming corrupt, but I guess anything is possible. I would check your server event logs and see if you can find some clues. It's pretty much impossible to guess without something to go on. It could be anything from low disk space to a DOS attack. If you are worried about the tax error, then try disabling the tax to see if that helps. What version are you using?
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 8:21 am

AC version is 7.0.88.7345.

I have had to restart the site on IIS every five or so minutes just to keep it running. Based on the AC error log this started at around 4am.

Because all of the errors were on category 196 I have removed the items from that category and deleted the category. That is nearly 15 minutes ago, and there has not been another error thrown on the site, and it has not slowed down on us again (yet, at least). CPU usage is still a bit high at 10-20%, with spikes in the mid to upper 20s, but that is still a big drop from where it was.

It seems like something went funky with that single category. Is that possible?? We have automatic backups of the DB every night at 2am. The time is off by a couple of hours, but it is in the right range. It seems very strange that this could have caused such an issue.

Just looked and a new error came in We just had the following error show up 30 times in 30 seconds:
An error has occured at http://www.brewhaus.com/thermometer-sle ... ''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

This did not slow the site or take is back down.

Thoughts?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Katie » Tue Mar 24, 2015 9:24 am

The URL in your error has some funky characters in it, and the error message says "Illegal characters in path". What do you see in the admin for the URL on this page?

There are only two issues that I've ever seen to make a site go down -

1) Changing the visibility of the home page (default.aspx) so it can't be accessed (results in an infinite redirect loop)
2) Invalid redirect rule under Configure -> SEO -> Dynamic Redirects

Thanks
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 9:43 am

Sorry, Katie, but you lost me with
What do you see in the admin for the URL on this page?
Are you asking what the product details are (from the product details page)?

These errors happened within 30 seconds, and covered a few items. There has not been another error since.

Also, since deleting the ON SALE!! category (category 196) we have not had a problem with the site slowing down, have not had to restart the site, and there have been no more errors in the log. The CPU draw is still higher than normal (15-20% for wswp.exe for the user Brewhaus), but deleting the category and setting it up fresh definitely made a difference. Any thoughts on what would cause this? Also, any thoughts on what could be drawing so much CPU power? Even when I stopped both the Brewhaus website and Application Pool the Brewhaus user was accessing this much CPU, so there must be something else that needs to be cycled.

Rick
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Katie » Tue Mar 24, 2015 10:04 am

Rick,

I really don't know. All I can do is look at the error message you provided and try to make sense of it. I was asking that you look at the thermometer product in your admin and see if there are any illegal characters in the URL field, product title or anywhere else.
Also, any thoughts on what could be drawing so much CPU power?
Have you looked at task manager? Without access to the server, I would only be guessing at the problem. I can say this. If the server has been stable for a long time, and this just started happening early this morning, then try to identify what has changed. Something has to have changed!

Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 10:13 am

The product title for that particular product is Thermometer Sleeve- 1/8" hole
The URL that AC auto-created is http://www.brewhaus.com/Thermometer-Sle ... P1221.aspx, so it does not appear to have any illegal characters.
Strange...

Task manager is where I see the CPU usage. I have not looked at the CPU usage in quite some time as everything has flowed along so smoothly. With the current usage of 10-20% the site is running fine, but I don't like seeing one service use such a high percentage of the CPU- especially when it likely shouldn't be. The other AC site runs at 0%, and all of our other non-AC sites also run at 0%. Even sqlservr is only running at 2-3%.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 11:16 am

We just had the site go down again. Below is the first page of errors. Thoughts? This seems crazy, as it is isolated to the Brewhaus website. We must get this fixed, though- we obviously cannot have our site going down like this. CPU is also back up to ~40%. :-(

3/24/2015 2:43:15 PM Error
An error has occured at http://www.brewhaus.com/product.aspx?productid=1432
Exception: Request timed out. Stack Trace:

3/24/2015 2:43:15 PM Error
Could not calculate with the configured tax provider: CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax, CommerceBuilder
Exception: Thread was being aborted. 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 CommerceBuilder.DomainModel.PersistentBag`1.Save() at CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax.Calculate(Basket basket) at CommerceBuilder.Taxes.TaxCalculator.Calculate(Basket basket)

3/24/2015 2:41:30 PM Error
An error has occured at http://www.brewhaus.com/product.aspx?productid=1432
Exception: Request timed out. Stack Trace:

3/24/2015 2:41:30 PM Error
Could not calculate with the configured tax provider: CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax, CommerceBuilder
Exception: Thread was being aborted. 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 CommerceBuilder.DomainModel.PersistentBag`1.Save() at CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax.Calculate(Basket basket) at CommerceBuilder.Taxes.TaxCalculator.Calculate(Basket basket)

3/24/2015 2:39:30 PM Error
An error has occured at http://www.brewhaus.com/product.aspx?productid=1432
Exception: Request timed out. Stack Trace:

3/24/2015 2:39:30 PM Error
Could not calculate with the configured tax provider: CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax, CommerceBuilder
Exception: Thread was being aborted. 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 CommerceBuilder.DomainModel.PersistentBag`1.Save() at CommerceBuilder.Services.Taxes.AbleCommerce.AbleCommerceTax.Calculate(Basket basket) at CommerceBuilder.Taxes.TaxCalculator.Calculate(Basket basket)

3/24/2015 2:31:02 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... ''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:31:02 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... 4¿'¿".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:31:01 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... -41'".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:56 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... ''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:56 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... 3¿'¿".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:55 PM Error
An error has occured at http://www.brewhaus.com/clearing-agent- ... 131'".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:46 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... ''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:46 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... 2¿'¿".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:45 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... -21'".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:41 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... ''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:41 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... 2¿'¿".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:39 PM Error
An error has occured at http://www.brewhaus.com/brewhaus-equipm ... -21'".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:36 PM Error
An error has occured at http://www.brewhaus.com/anti-foam-agent-2ð''ð"".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

3/24/2015 2:30:36 PM Error
An error has occured at http://www.brewhaus.com/anti-foam-agent-2¿'¿".aspx
Exception: Illegal characters in path. Stack Trace: at System.IO.Path.Combine(String path1, String path2) at System.Web.Compilation.DiskBuildResultCache.GetBuildResult(String cacheKey, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp) at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 11:53 am

Analytics showed hit from "...hulfingtonpost.com", which is NOT "huffingtonpost.com". It is similar to Semalt (which we already blocked). We blocked it using Request Filtering.

The CPU usage for the Brewhaus w3wp.exe got up to 90%+, so I got a bit creative and created a new application pool for the Brewhaus website and stopped the old application pool. It is now running at 5-10% CPU usage.

There was one of the 'product' errors after shutting the old application pool down, but it took a couple of minutes to disappear from the Task Manager, so I believe that it was during this 'limbo' time that the error occurred.

Is it reasonable to believe that this bad website was sending bots that were causing the errors and taking down our site, and that they had invaded the application pool (or just overwhelmed it)? Any thoughts on this are appreciated.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Tue Mar 24, 2015 12:02 pm

Just looked and a new error came in We just had the following error show up 30 times in 30 seconds:
Check your IIS logs and block the IP source of this attack. Someone is intentionally bringing your site down if your seeing that many requests per minute.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 12:25 pm

Thanks, Mike. I am not sure if the Request Filtering or change of application pool cooled things off (I assume the Request filtering). When we check the IP addresses there are multiple, which I would expect, so IP filtering may be tough. Usually those places will run with a large number of IPs.

I noticed a sudden spike in the CPU usage for our forum website (different domain, but several direct links from the main Brewhaus site, so it stands to reason that it would be next), and when I checked the forum it had 1200 guests in the 10 minute history. I blocked the domain using Request Filtering and now it is falling quickly- down to 55, and lower each time I check.

So, my guess- this 'hulfingtonpost.com' is our new 'Semalt', and they were pounding our site with bots that were making tons of requests, some of which threw errors into our log.

Does that sound like a likely scenario?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Tue Mar 24, 2015 12:37 pm

Hi Rick,

Yes, it looks like the most likely theory to me. Anytime we see the request so close together...30 in 1/2 minute it's a sign of an attack/rogue bot.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Tue Mar 24, 2015 1:11 pm

Hopefully the filtering works. We have had a couple of blips since where the site stopped responding, but then it bounced right back without having to be restarted, so that could have even been a really brief outage on our Fios line (too common lately).

Thanks for all the help! :-)
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 6:17 am

Well, our site does not appear to have taken quite the hit that it did yesterday, but we are seeing a bunch of errors again this morning, and we cannot access the Who is Online, as the request times out. Thoughts?

Here are half of the errors that suddenly came in. The others are also at 9:49:30 AM.

3/25/2015 9:49:37 AM Error
An error has occured at http://www.brewhaus.com/product.aspx?productid=1432
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: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

3/25/2015 9:49:37 AM Error
An error has occured at http://www.brewhaus.com/category.aspx?categoryid=102
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: could not load an entity: [CommerceBuilder.Catalog.Category#102][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Catalog.Category#102][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Catalog.Category#102][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

3/25/2015 9:49:30 AM Error
An error has occured at http://www.brewhaus.com/category.aspx?categoryid=91
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: could not load an entity: [CommerceBuilder.Catalog.Category#91][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Catalog.Category#91][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Catalog.Category#91][SQL: SELECT category0_.CategoryId as CategoryId1_0_, category0_.StoreId as StoreId1_0_, category0_.ParentId as ParentId1_0_, category0_.Name as Name1_0_, category0_.Summary as Summary1_0_, category0_.Description as Descript6_1_0_, category0_.ThumbnailUrl as Thumbnai7_1_0_, category0_.ThumbnailAltText as Thumbnai8_1_0_, category0_.WebpageId as WebpageId1_0_, category0_.VisibilityId as Visibil10_1_0_, category0_.MetaDescription as MetaDes11_1_0_, category0_.MetaKeywords as MetaKey12_1_0_, category0_.Title as Title1_0_, category0_.HtmlHead as HtmlHead1_0_ FROM ac_Categories category0_ WHERE category0_.CategoryId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.Code.PageHelper.GetCategoryId() at AbleCommerce._Category.Page_PreInIt() at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

3/25/2015 9:49:30 AM Error
An error has occured at http://www.brewhaus.com/product.aspx?productid=1432
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: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not load an entity: [CommerceBuilder.Products.Product#1432][SQL: SELECT product0_.ProductId as ProductId61_2_, product0_.RowVersion as RowVersion61_2_, product0_.StoreId as StoreId61_2_, product0_.Name as Name61_2_, product0_.Price as Price61_2_, product0_.CostOfGoods as CostOfGo6_61_2_, product0_.MSRP as MSRP61_2_, product0_.Weight as Weight61_2_, product0_.Length as Length61_2_, product0_.Width as Width61_2_, product0_.Height as Height61_2_, product0_.ManufacturerId as Manufac12_61_2_, product0_.Sku as Sku61_2_, product0_.ModelNumber as ModelNu14_61_2_, product0_.WebpageId as WebpageId61_2_, product0_.TaxCodeId as TaxCodeId61_2_, product0_.ShippableId as Shippab17_61_2_, product0_.WarehouseId as Warehou18_61_2_, product0_.InventoryModeId as Invento19_61_2_, product0_.InStock as InStock61_2_, product0_.AvailabilityDate as Availab21_61_2_, product0_.InStockWarningLevel as InStock22_61_2_, product0_.ThumbnailUrl as Thumbna23_61_2_, product0_.ThumbnailAltText as Thumbna24_61_2_, product0_.ImageUrl as ImageUrl61_2_, product0_.ImageAltText as ImageAl26_61_2_, product0_.Summary as Summary61_2_, product0_.Description as Descrip28_61_2_, product0_.ExtendedDescription as Extende29_61_2_, product0_.VendorId as VendorId61_2_, product0_.CreatedDate as Created31_61_2_, product0_.LastModifiedDate as LastMod32_61_2_, product0_.IsFeatured as IsFeatured61_2_, product0_.IsProhibited as IsProhi34_61_2_, product0_.AllowReviews as AllowRe35_61_2_, product0_.AllowBackorder as AllowBa36_61_2_, product0_.WrapGroupId as WrapGro37_61_2_, product0_.ExcludeFromFeed as Exclude38_61_2_, product0_.DisablePurchase as Disable39_61_2_, product0_.MinQuantity as MinQuan40_61_2_, product0_.MaxQuantity as MaxQuan41_61_2_, product0_.VisibilityId as Visibil42_61_2_, product0_.IconUrl as IconUrl61_2_, product0_.IconAltText as IconAlt44_61_2_, product0_.IsGiftCertificate as IsGiftC45_61_2_, product0_.UseVariablePrice as UseVari46_61_2_, product0_.MinimumPrice as Minimum47_61_2_, product0_.MaximumPrice as Maximum48_61_2_, product0_.HidePrice as HidePrice61_2_, product0_.HandlingCharges as Handlin50_61_2_, product0_.EnableGroups as EnableG51_61_2_, product0_.Title as Title61_2_, product0_.MetaDescription as MetaDes53_61_2_, product0_.MetaKeywords as MetaKey54_61_2_, product0_.SearchKeywords as SearchK55_61_2_, product0_.HtmlHead as HtmlHead61_2_, product0_.GTIN as GTIN61_2_, product0_.GoogleCategory as GoogleC58_61_2_, product0_.Condition as Condition61_2_, product0_.Gender as Gender61_2_, product0_.AgeGroup as AgeGroup61_2_, product0_.Color as Color61_2_, product0_.Size as Size61_2_, product0_.AdwordsGrouping as Adwords64_61_2_, product0_.AdwordsLabels as Adwords65_61_2_, product0_.ExcludedDestination as Exclude66_61_2_, product0_.AdwordsRedirect as Adwords67_61_2_, product0_.PublishFeedAsVariants as Publish68_61_2_, product0_.OrderBy as OrderBy61_2_, kit1_.ProductId as ProductId55_0_, kit1_.ItemizeDisplay as ItemizeD2_55_0_, subscripti2_.ProductId as ProductId76_1_, subscripti2_.Name as Name76_1_, subscripti2_.IsOptional as IsOptional76_1_, subscripti2_.Description as Descript4_76_1_, subscripti2_.OneTimeCharge as OneTimeC5_76_1_, subscripti2_.OneTimeChargeModeId as OneTimeC6_76_1_, subscripti2_.OneTimeChargeTaxCodeId as OneTimeC7_76_1_, subscripti2_.OptionalPaymentFrequencies as Optional8_76_1_, subscripti2_.PaymentFrequencyTypeId as PaymentF9_76_1_, subscripti2_.NumberOfPayments as NumberO10_76_1_, subscripti2_.PaymentFrequency as Payment11_76_1_, subscripti2_.PaymentFrequencyUnitId as Payment12_76_1_, subscripti2_.RecurringCharge as Recurri13_76_1_, subscripti2_.RecurringChargeModeId as Recurri14_76_1_, subscripti2_.RepeatDiscounts as RepeatD15_76_1_, subscripti2_.RecurringChargeSpecified as Recurri16_76_1_, subscripti2_.GroupId as GroupId76_1_, subscripti2_.TaxCodeId as TaxCodeId76_1_ FROM ac_Products product0_ left outer join ac_Kits kit1_ on product0_.ProductId=kit1_.ProductId left outer join ac_SubscriptionPlans subscripti2_ on product0_.ProductId=subscripti2_.ProductId WHERE product0_.ProductId=?] Inner Exception Stack Trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id) at AbleCommerce.ProductPage.Page_PreInit(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Wed Mar 25, 2015 8:22 am

Hello Rick,

You likely need to manually clean up the anon users in the database after that attack yesterday.

http://help.ablecommerce.com/upgrades/a ... enance.htm
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 8:57 am

I tried, but it would not work. However, I think that we were still being attacked, just not quite as violently. When I checked the Page Tracking (I tried clearing the history of nearly 600,000 entries, but it timed out), I decided to click on View. There were many hits from a single ip address (46.146.78.30, in case anyone else is experiencing these issues), which was hitting literally 3-4 pages per second. I blocked that ip address at the server level and right away the w3wp.exe for Brewhaus dropped to 0-2%. So, I think that it is safe to say that this ip address was causing all of the problems.

My guess is that the sheer number of hits that this was creating is why I could not bring up the Who Is Online- there were so many that it would time out. Now that we blocked that ip I am able to bring up the Who Is Online. :-)

It seems like we were just one of many places hit yesterday. BBB was down part of the day, as was FitBit, a place that our web girl does a lot of her graphic compiling, Amazon for a while, and I am sure many others.

The attacks came from Russia (not surprisingly), so I think that I am just going to block the entire country. We do not get any business from there, anyway.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 9:04 am

Still throwing errors when trying to remove anonymous users (error below). Any advice? It would be nice to clean this up.

Error in user maintenance; could not delete user id 5381065
Exception: could not execute native bulk manipulation query:DELETE FROM ac_BasketItems WHERE BasketId IN (SELECT BasketId FROM ac_Baskets WHERE UserId = :userId)[SQL: DELETE FROM ac_BasketItems WHERE BasketId IN (SELECT BasketId FROM ac_Baskets WHERE UserId = @p0)] Stack Trace: at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at CommerceBuilder.Services.MaintenanceWorker.DeleteUsers(IList`1 idList) Inner Exception: Transaction (Process ID 51) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Inner Exception Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Wed Mar 25, 2015 9:11 am

Hello Rick,

If the queries are timing out try setting the rowcount before the query. 50k is np on most sql servers, I up it higher on faster SQL servers. Still run the queries in the order show in the help site. If you have a lot of old history, you can just adjust the dates in the queries to get less records as well

SET ROWCOUNT 50000
DELETE FROM ac_Users
WHERE StoreId = 1 AND IsAnonymous = 1
AND (AffiliateId IS NULL)
AND (LastActivityDate IS NULL OR LastActivityDate < '2013-01-01')
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 10:00 am

AC seems to be slowly clearing the anonymous users list, well after the function was manually run. Is this normal? I assume that I should wait for it to complete (at the rate it is going that will be quite some time) before I try to run a SQL Query?
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Wed Mar 25, 2015 10:20 am

Hello Rick,

So long as you're not seeing any timeout issues in the error log it's easiest to just let the maintenance routine continue.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 10:36 am

We are getting the error noted above (Error in user maintenance; could not delete user id 5381065) for a large number of users, but no 'timeout' errors as far as I can tell.

Is this normally a slow process? It took a couple of hours to knock of 10,000 anonymous users... leaving it 442,000 to go.
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Site suddenly slowing down and dying every few minutes

Post by Shopping Cart Admin » Wed Mar 25, 2015 11:13 am

Hi Rick,

BACKUP THE DB, BEFORE DOING ANYTHING MANUAL ON THE DB!

I'd recommend doing the manual cleanup it should just take a few minutes in blocks of 50k. Our routine is slow to keep the load off the server.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Brewhaus
Vice Admiral (VADM)
Vice Admiral (VADM)
Posts: 878
Joined: Sat Jan 19, 2008 4:30 pm

Re: Site suddenly slowing down and dying every few minutes

Post by Brewhaus » Wed Mar 25, 2015 11:25 am

I came back with the error below on the Delete from ac_Users query:

Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "ac_Users_ac_Baskets_FK1". The conflict occurred in database "Brewhaus", table "dbo.ac_Baskets", column 'UserId'.
The statement has been terminated.

Is this a problem?

Nevermind... I just added the time so that we were back a couple of hours and everything completed without any errors
Rick Morris
Brewhaus (America) Inc.
Hot Sauce Depot

Post Reply