11,568,494 Anonymous User's (Maintenance Error)

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
xplosi0n1
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Mon Nov 30, 2009 10:54 am
Location: Dayton, OH
Contact:

11,568,494 Anonymous User's (Maintenance Error)

Post by xplosi0n1 » Fri Jul 28, 2017 11:43 am

Hello All,

Our Anonymous User Maintenance is not working. We have it set to 360 days but when you click the Current Anonymous User Status we are returning 731 days and a crazy amount of anonymous users 11,568,494.

I know we have the maintenance set high at 360 days but we were having trouble helping customers who didn't remember their order #'s and we could not find them in our system.

Today I tried to clear out some of the anonymous users and it returned an error and nothing was removed. I have tried the manual option on the maintenance page and also tried lowering the Maintenance Interval to 5 from 360 as one post suggested.

Here is my error code can someone please point me in the right direction to solve it.

An error has occured at https://www.cheapbowlingballs.com/Admin ... nance.aspx
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.admin_store_maintenance_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\5ab52502\441f059a\App_Web_tcthfjhy.2.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: could not execute query [ SELECT TOP (@p0) this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.IsAnonymous = @p1 and this_.AffiliateId is not null and this_.LastActivityDate is not null ORDER BY this_.LastActivityDate asc ] Name:cp0 - Value:True [SQL: SELECT TOP (@p0) this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.IsAnonymous = @p1 and this_.AffiliateId is not null and this_.LastActivityDate is not null ORDER BY this_.LastActivityDate asc] Inner Exception Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.LoadForCriteria(ICriteria criteria) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.LoadForCriteria(ICriteria criteria) at AbleCommerce.Admin._Store.Maintenance.InitAnonUserStatus() in d:\inetpub\wwwroot\www.cheapbowlingballs.com - R10\Admin\Store\Maintenance.aspx.cs:line 94 at AbleCommerce.Admin._Store.Maintenance.ManualCleanupButton_Click(Object sender, EventArgs e) in d:\inetpub\wwwroot\www.cheapbowlingballs.com - R10\Admin\Store\Maintenance.aspx.cs:line 189 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not execute query [ SELECT TOP (@p0) this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.IsAnonymous = @p1 and this_.AffiliateId is not null and this_.LastActivityDate is not null ORDER BY this_.LastActivityDate asc ] Name:cp0 - Value:True [SQL: SELECT TOP (@p0) this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.IsAnonymous = @p1 and this_.AffiliateId is not null and this_.LastActivityDate is not null ORDER BY this_.LastActivityDate asc] Inner Exception Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.LoadForCriteria(ICriteria criteria) at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.LoadForCriteria(ICriteria criteria) at AbleCommerce.Admin._Store.Maintenance.InitAnonUserStatus() in d:\inetpub\wwwroot\www.cheapbowlingballs.com - R10\Admin\Store\Maintenance.aspx.cs:line 94 at AbleCommerce.Admin._Store.Maintenance.ManualCleanupButton_Click(Object sender, EventArgs e) in d:\inetpub\wwwroot\www.cheapbowlingballs.com - R10\Admin\Store\Maintenance.aspx.cs:line 189 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Thanks,
Mike

CheapBowlingBalls.com
3204 Woodman Drive
Kettering, OH 45420
937.559.1541
mikeh@cheapbowlingballs.com
www.cheapbowlingballs.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: 11,568,494 Anonymous User's (Maintenance Error)

Post by AbleMods » Thu Aug 03, 2017 2:26 am

360 days for anonymous maintenance is way too high. Anonymous maintenance does not purge orders, it only purges users and their related (abandoned) baskets. The majority of my clients use 30 days.

At this point your ac_Users table is too large for Able maintenance routines to handle. You're going to have to get your hosting provider or programmer involved to run some manual SQL queries against the store database. That's the only way to clean out that many anonymous user records.

I created a blog post a few years ago to remind me how to do it manually. These commands have to be performed from SQL Management Studio connected to the database server hosting your store database. Hope it helps!

https://ablemods.com/blog/post/2014/04/ ... users.aspx
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
xplosi0n1
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 30
Joined: Mon Nov 30, 2009 10:54 am
Location: Dayton, OH
Contact:

Re: 11,568,494 Anonymous User's (Maintenance Error)

Post by xplosi0n1 » Thu Aug 03, 2017 5:38 am

Joe,

Thank you for the help. I will give it to our developers.
Thanks,
Mike

CheapBowlingBalls.com
3204 Woodman Drive
Kettering, OH 45420
937.559.1541
mikeh@cheapbowlingballs.com
www.cheapbowlingballs.com

Post Reply