AbleCommerce Shopping Cart Software

I am trying to upgrade to gold from 7.0.2 This weekend I upgraded to 7.0.3 seemed to go well. Now I am reviewing the gold upgrade, the first thing it recommends is to install a patch and clean up the anonymous users. Which I have done by downloading the new Maintenance.aspx When I try to open that page I now get the following error;

d:\Domains\cameojewelrysupply.com\wwwroot\Admin\Store\Maintenance.aspx.cs(129): error CS0117: 'CommerceBuilder.Search.KeywordSearchHelper' does not contain a definition for 'RebuildCatalog'

Can someone help on that?

Thanks
Chris

Hello Chris,

Can you go to the Help > About page and copy the information here? I want to look at the version information for the DLL's. Also, did you reboot or restart the application pool after upgrading? If yes, then did you recycled the application pool after apply the maintenance.aspx patch?

Thanks
Katie

Well I am not even sure what the "application pool" is but sounds like something my web host would do. Before I uploaded the 7.0.3 upgrade I called my host and asked them to stop the server. Loaded the files then asked them to start the server, which took 3 tries before it came on line and seemed to work.

In terms of the maintenance patch all I did was overwrite the two old files via ftp. I did not ask for anything else to be done.

Here is the info in about

PLATFORM: ASP.NET
VERSION: 7.0.3
BUILD: 12458
MSSQL v2005
AC SCHEMA v2005

AjaxControlToolkit: 1.0.20229.20821
CommerceBuilder: 7.3.12065.0
CommerceBuilder.AbleCommerceTax: 7.3.12396.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.3.12065.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.3.12065.0
CommerceBuilder.DataClient.Api: 7.0.3.1
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.0.10052.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.2.11284.0
CommerceBuilder.PayPal: 7.3.12238.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.3.12065.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.3.12065.0
ComponentArt.Web.UI: 2008.2.1267.3
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Practices.EnterpriseLibrary.Common: 2.0.0.0
Microsoft.Practices.EnterpriseLibrary.Data: 2.0.0.0
Microsoft.Practices.ObjectBuilder: 1.0.51205.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0

Also noticing some errors cropping up in the log

Exception of type 'System.Web.HttpUnhandledException' was thrown.; The INSERT statement conflicted with the FOREIGN KEY constraint "ac_Baskets_ac_BasketItems_FK1". The conflict occurred in database "cameosupplydatabase", table "chadden.ac_Baskets", column 'BasketId'. The statement has been terminated.


The file '/AboutUs.aspx' does not exist.



A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Hello Chris,

The DLL version is correct for 7.0.3, so either the application pool needs to be recycled, or something went wrong with the maintenance files that were uploaded.

It can be very difficult to troubleshoot these errors unless we had access to the server. The constraint error might be fixed if you run the patch under "Fix User Constraints" (same document), but I can't be sure since the error is slightly different.

Another idea is to apply the service patch for this release. You can download and install a few files which may also fix the constraint error (and possibly others). The link is - http://help.ablecommerce.com/index.htm# ... _7.0.3.htm

The trouble I'm having is that 5 years have passed since this version was released, so it's difficult to remember all the solutions.

Here is what I would do -

1) Apply Service Release 1 for 7.0.3
2) Recycle the application (ask host to do this)
3) Clear the error log
4) Access the maintenance page to see if the error still exists.

Thanks
Katie

Ok I will try that, thanks

Ok i have followed the steps you suggested and I am still unable to view the maintenance page, throws the same error:

d:\Domains\cameojewelrysupply.com\wwwroot\Admin\Store\Maintenance.aspx.cs(129): error CS0117: 'CommerceBuilder.Search.KeywordSearchHelper' does not contain a definition for 'RebuildCatalog'


What would be my next option?

Thanks
Chris

Sorry Chris. I have run out of ideas....

Either you can try to run the database maintenance manually by using the scripts provided on the help page, or you can try upgrading to Gold. It might work, but there is no way of knowing because we don't have any details about the size of the tables where activity logging and anonymous user data.

The only other option would be to purchase some support time and we can access your installation via FTP or by Remote Access, and try to figure out what is going on with these errors.

Thanks
Katie

Hmmm...well I suppose there is no harm in trying to upgrade, other then wasting my time. I have a development site up so I won't screw up the current site. I'll give it a shot.

Chris, where did you get the maintenance.aspx? The version included in 7.0.3 does not have that method and your dlls are version 7.0.3, which do not have the method that is throwing an error.

These came from ........... The Anonymous User Maintenance patch for all versions 7.0.6 and below only...... If I read correctly I was supposed to install that .. it is this patch that is the issue.

I wanted to make sure that the patch wasn't the issue, so I installed the original stock version 7.0.3 and applied the patch. The error you have been getting appeared. Then I realized that version 7.0.3 has a service pack 1 update. Once I applied this (a few files) and then re-applied the maintenance.aspx files, it worked fine.

You can download the 7.0.3 SR1 update here - http://help.ablecommerce.com/index.htm# ... _7.0.3.htm

Then make sure you re-apply the 2 maintenance files.

Thanks
Katie

Ok well that was the issue, thanks so much. It says I have 831,000 Anonymous users going back 2000 days. Do you have any recomendations on how I might step that down time wise. My site is really not that busy but that does sound like a lot to me.

It's a lot, but I've seen worse.

Reference back to the Maintenance document here - http://help.ablecommerce.com/index.htm# ... enance.htm

Follow the instructions which start with:

If you have a large number of records, you may want to manually cleanup the database by following the steps below.

You can enter values into the field (eg. 1500) and click the DELETE ANONYMOUS USERS button to start removing the records.