Syntax error Online Purchases

Former Member
Former Member $organization

Hi All,

Apologies for the duplicate post - I did post this on Ticketing forum, too.  Please advise if you know something.

All of a sudden our patrons are unable to complete purchases through our website and receive the below error.  We have confirmed with our developer that this is on the Tessitura side.  The only recent changes within Tessie have been minor ticketing fee edits.  As we look into all API relating tables and stored procs, does anyone know what the syntax should be or why out of nowhere we would receive this error?

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'd'.
at Tessitura.WebAPI.Tessitura.CheckoutExDirect(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode,
Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear) at Tessitura.WebAPI.Tessitura.CheckoutEx(String sSessionKey, String sCCOwner, String sCCNumber, Int32 iCCType, Int32 iCCMonth, Int32 iCCYear, Decimal dAmount, Boolean bAllowUnderPayment, String sCardAuthenticationCode, Int32 iCCIssueNumber, Int32 iCCStartMonth, Int32 iCCStartYear) --- End of inner exception stack trace ---

Thanks in advance,

Beth Ann

Beth Ann Mencher
Application Specialist
Scottsdale Cultural Council
7380 E. 2nd Street
Scottsdale, AZ   85251
(p) (480) 874-4669
(f) (480) 874-4655
BMencher@sccarts.org