Errors during website checkout

Original Message -----
From: Tessitura Ticketing Forum
To: Kim Lee
Sent: Fri Apr 24 06:26:03 2009
Subject: RE: [Tessitura Ticketing Forum] Errors during website checkout

We have seen this error "Incorrect syntax near 'd'" several times on SQL Server 2005 installations that have not applied SQL Server Service Pack 2 (or 3). If you have not applied SP2 yet, I would suggest you arrange to install SP2 (or SP3). A workaround that has solved this problem temporarily is to recompile the triggers on the T_ORDER table. If you have questions about this I would suggest that you submit a help ticket so that Support can assist you.

Bob

________________________________

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beth Ann Mencher
Sent: Thursday, April 23, 2009 4:11 PM
To: Robert Bell
Subject: [Tessitura Ticketing Forum] Errors during website checkout



Hi All,

I am hoping that someone has seen this before. Our website is not processing tickets and patrons are receiving the below error. We have confirmed with our developer that this is a Tessitura issue and am looking into the various API relating tables and stored procs. The only changes to Tessitura and relating API that we can think of are minor fee changes. Nothing else has changed and now we have this error.

Please help if you can read into this:

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






This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums.



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums.
Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====