Have plugged our test website into our v12 test installation. The site was originally built on v11 and uses CheckoutEx3 for handling the checkout process in Tessitura. Since upgrading to v12 if try to put an order through the website we get the following error:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated.
Error Inserting to T_BATCH table
Error getting batch_no
The statement has been terminated.
at Tessitura.WebAPI.Tessitura.CheckoutEx3Direct(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Boolean bAuthorize, String sAuthorizationCode, String s3DSecureValues)
at Tessitura.WebAPI.Tessitura.CheckoutEx3(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Boolean bAuthorize, String sAuthorizationCode, String s3DSecureValues)
--- End of inner exception stack trace ---
Any ideas as to why this might be happening and more importantly how to fix it.
Thanks
Huw
I recommend you open a TASK ticket on this issue so a member of the support team can take a look at it for you.
Best wishes
Tony
Tony Barnes
EU Operations Manager