Live site broken after development site updated - Tax calcs

[WylieE]

Hello all,

We have a development site and live site on one of our servers. (Different web services, pools, etc...) Both are at 7.0.4.

We just upgraded the development site to 7.0.5 and are now experiencing tax problems on our live site. Not sure how this could have happened, but we're seeing several errors.

ERRORS
1.) I'm getting slammed with this error in our error log at the rate of one a second:
Could not calculate with the configured tax provider:
CommerceBuilder.Taxes.Providers.AbleCommerce.AbleCommerceTax,
CommerceBuilder.AbleCommerceTax

Invalid column name 'CountryCode'. Invalid column name 'ProvinceId'.
Invalid column name 'PostalCodeFilter'.

2.) Our sales tax calculations are not working.

3.) Navigating to Configure\Taxes\Tax Rules generates an error.


We see the following versions on the live site:
AbleCommerce for ASP.NET
VERSION: 7.0.4.13424
MSSQL v2005
AC SCHEMA v2005
ASP.NET TRUST: Unrestricted

AjaxControlToolkit: 3.0.20229.20843
AxInterop.ZRush_ShipRush5: 1.0.0.0
CommerceBuilder: 7.4.13416.0
CommerceBuilder.AbleCommerceTax: 7.4.13043.0

We've looked at the CommerceBuilder.AbleCommerceTax file and it still shows an old build date.



Help?????

[plugables]

I suspect some mix-up during database upgrade...

[jmestep]

Here is what I am showing for a 7.0.5 SR1 build 14135 site:
AbleCommerce for ASP.NET
VERSION: 7.0.5.14135
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.4206
ASP.NET TRUST: Unrestricted

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.5.14053.0
CommerceBuilder.AbleCommerceTax: 7.4.13043.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.3.12625.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.5.14053.0
CommerceBuilder.CyberSource: 7.5.13718.0
CommerceBuilder.Data: 7.5.14053.0
CommerceBuilder.DataClient.Api: 7.5.14053.0
CommerceBuilder.DataClient.Csv: 1.0.0.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.3.12468.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.3.12625.0
CommerceBuilder.PaymentechOrbital: 7.5.14028.0
CommerceBuilder.PayPal: 7.4.13453.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.5.14053.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.4.13441.0
CommerceBuilder.WATax: 7.5.13942.0
CommerceBuilder.Web: 7.5.14053.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
DataPort.Framework: 7.4.221.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.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

[WylieE]

Thanks. The beta site is running at 7.0.5 and versioning matches your list Judy. However, the problems we're experiencing are on the live site, which was *not* the subject of the upgrade and is still at 7.0.4.

Here's what we've since found:

- When the beta site was created, we updated the license and URL but *missed* the connection string. It was still connected to the live site. Fixed that, but it is too late. Changes have been made and I don't know what the changes are.

- The fields were missing from the ac_TaxRules table. Adding the fields to the live site db eliminated the errors and the tax calcs are working again. As shown above, I see the the Commercebuilder.AbleCommerceTax version to be the same in 7.0.4 as 7.0.5. Can anyone confirm this as correct?

Good news is the live site has not blown up.
Bad news is I don't know what else has been changed in the live site.

I need to get more information on table/code changes from AC, but I'm not quite sure how to formulate that request. I'm presuming it would be a paid support request. We need a prognosis on our sites. I'm wondering if a clean install of 7.0.5 would be best for the beta site, but not sure what the heck to do with the live site.