T_batch error

Monic – if you haven’t already, can you open a support ticket for this.

Thanks

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Monic Verma
Sent: Friday, 10 August 2012 4:40 PM
To: Sandra Ashby
Subject: [Tessitura Web Forum] T_batch error

Hey Guys,

We deployed v11 on our Development server and we are now getting following error during checkout process

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.Order.CheckOut(Payment payment)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Tessitura tessituraAPI, Boolean bAuthorize, String sAuthorizationCode, ThreeDSecureData data3D)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Tessitura tessituraAPI)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Tessitura oTessitura)

    at Tessitura.WebAPI.Tessitura.CheckoutDirect(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear)

    at Tessitura.WebAPI.Tessitura.Checkout(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear)




Could it be that web can't open batch? We thought first transaction of the day would open batch automatically but its surely not the case.
Has anyone seen this error before? Any Ideas?

 


Thanks,
--Monic

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Monic – if you haven’t already, can you open a support ticket for this.

Thanks

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Monic Verma
Sent: Friday, 10 August 2012 4:40 PM
To: Sandra Ashby
Subject: [Tessitura Web Forum] T_batch error

Hey Guys,

We deployed v11 on our Development server and we are now getting following error during checkout process

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.Order.CheckOut(Payment payment)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Tessitura tessituraAPI, Boolean bAuthorize, String sAuthorizationCode, ThreeDSecureData data3D)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear, Tessitura tessituraAPI)

    at Tessitura.WebAPI.Order.CheckOut(String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Tessitura oTessitura)

    at Tessitura.WebAPI.Tessitura.CheckoutDirect(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear)

    at Tessitura.WebAPI.Tessitura.Checkout(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear)




Could it be that web can't open batch? We thought first transaction of the day would open batch automatically but its surely not the case.
Has anyone seen this error before? Any Ideas?

 


Thanks,
--Monic

You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!