AbleCommerce Shopping Cart Software

We are getting this error when customers are checking out of our client's store: String or binary data would be truncated. The statement has been terminated. Our client did not receive notification that they had a new order.

Here is the version information:

PLATFORM: ASP.NET
VERSION: 7.0
BUILD: 10125

AjaxControlToolkit: 1.0.10301.0
CommerceBuilder: 7.0.10139.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.CCH: 7.0.0.0
CommerceBuilder.Configuration: 7.0.10102.0
CommerceBuilder.CyberSource: 7.0.9764.0
CommerceBuilder.DataClient.Api: 1.0.0.21
CommerceBuilder.DataClient.Csv: 1.0.0.0
CommerceBuilder.DHL: 7.0.8825.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.FRBNY: 7.0.0.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.0.9764.0
CommerceBuilder.PayPal: 7.0.10071.0
CommerceBuilder.Services: 7.0.9733.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.0.9777.0
ComponentArt.Web.UI: 2007.1.1566.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
edtFTPnet: 1.2.4.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.1.271
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.0.8530.0
PaygatewayNET: 3.0.0.0
PayPal.Web.Controls: 1.0.22.18680
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

I have seen others getting this error, but I have verified that I have updated to the most recent build correctly.

Any assistance would be greatly appreciated!

Thanks!

Dave

Hello Dave,

Confirm the post upgrade steps were completed:

http://help.ablecommerce.com/upgrades/a ... _final.htm

Mike,

I have checked and the global.asax and web.config have been updated per your instructions. However, the validation of credit cards prior to order completion has been updated as well but I am beginning to think that these changes may be related my problem. I did notice that the update was optional, but I believe I need to remove these changes because the most recent error did not have any credit card information on the order.

Please advise.

Thanks!

Dave

Mike,

I have found that at the time of the error our client's customer was in the receipt.aspx page. It appears that the problem occurred in this page. I have now removed the changes related to issue id 6692.

Dave

Mike,

I have placed a test order entering a valid credit card number but an incorrect expiration month & year. I received an unhandled exception during checkout. Our client is not happy; they have lost the order from the earlier error. I have verified that the installation of the SR 1A was completed correctly and completely. We need to get this error fixed pronto.

Any assistance would be greatly appreciated!

Thanks!

Dave

I have finally resolved this issue. The problem lies with a product name that is greater than 100 characters. Modifying the product table resolved our problem. The following fields are limited to 100 characters: ThumbnailAltText, ImageAltText and IconAltText. These fields need to increased to match the product name field which stands at 255 characters. However, the basket may need to be cleared before these changes work.