AbleCommerce Shopping Cart Software

I'm splitting this off from the USAePay thread as is does not seem related to the payment gateway. I can replicate this error with the USAePay gateway or other options like Purchase Orders.

We are getting the "String or binary data would be truncated. The statement has been terminated." error any time an international order is placed and shipping uses an online tool. We get a blank order, no payment, no nothing. If we were live with Able, this would affect roughly 30% of our business. This is creating a significant barrier in our deployment schedule.

I can create a flat rate shipping method and process international orders consistently. However, when I switch to shipping via the UPS online tools, the order crashes. For test data, we've used address information from long time customers in Australia and Switzerland. These are known good addresses.

Here's the error message from our most recent test:
ERROR 2008-07-16 09:37:36,099 772910ms Object a - Unhandled exception during checkout.
System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command)
at CommerceBuilder.Orders.OrderShipment.Save()
at CommerceBuilder.Orders.Basket.Checkout(CheckoutRequest checkoutRequest, Boolean validate, Boolean triggerEvents)

Any suggestions folks? How many people here are using the online rating tools?

Anyone? Can anyone replicate this issue or are we alone?


FYI, here's our build info:
PLATFORM: ASP.NET
VERSION: 7.0
BUILD: 9879

AjaxControlToolkit: 1.0.10301.0
AxInterop.ZRush_ShipRush5: 1.0.0.0
CommerceBuilder: 7.0.9876.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.CCH: 7.0.0.0
CommerceBuilder.Configuration: 7.0.9842.0
CommerceBuilder.CyberSource: 7.0.9764.0
CommerceBuilder.DataClient.Api: 1.0.0.19
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.9632.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.9764.0
CommerceBuilder.PayJunction: 7.0.9764.0
CommerceBuilder.PayPal: 7.0.9877.0
CommerceBuilder.Services: 7.0.9733.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.8695.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.0.9777.0
ComponentArt.Web.UI: 2007.1.1566.3
ConfiguredItems: 1.0.0.0
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
DevExpress.Data.v6.3: 6.3.3.0
DevExpress.Utils.v6.3: 6.3.3.0
DevExpress.XtraBars.v6.3: 6.3.3.0
DevExpress.XtraEditors.v6.3: 6.3.3.0
DevExpress.XtraGrid.v6.3: 6.3.3.0
edtFTPnet: 1.2.4.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.1.271
Interop.ZRush_ShipRush5: 1.0.0.0
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_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
skmMenu: 2.2.2991.25093
UPSOnlineInterface: 1.0.0.0
UsaEpay: 1.0.0.0
USAePayAPI: 1.5.2818.15473
Validators: 1.0.0.0
WarmothBody: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0