Hi, all! I am having an issue where we have seats donated for resale in our Test system, but the ReserveTicketsSpecifiedSeats API call refuses to let me purchase them, giving the following error:
Tessitura.WebAPI.TessituraSeatServerErrorException: TESSITURA_SEATSERVER_EXCEPTION:Error 50000: {One or more of the selected seats is not available}
at Tessitura.WebAPI.SeatServer.SeatServerConnectionImp.ReceiveResponse(String sessionKey, UInt32 requestId, StatelessCommand command, MessageHeader& header, Byte[]& messageData)
at Tessitura.WebAPI.SeatServer.SeatServerConnectionImp.ExecuteSqlInternal(String sessionKey, Boolean forceEstablish, String command, SeatServerPool pool, Boolean preBroadcast)
at Tessitura.WebAPI.SeatServer.SeatServerConnectionImp.ExecuteSql(String sessionKey, String command, SeatServerPool pool, Boolean preBroadcast)
at Tessitura.WebAPI.SeatServer.SeatServerConnection.ExecuteSql(String sessionKey, String command, SeatServerPool pool, Boolean preBroadcast)
at Tessitura.WebAPI.SeatServerTicketer.FindSeats(SeatRequest oSeatRequest)
at Tessitura.WebAPI.Tessitura.FindSeats(SeatRequest oSeatRequest)
at Tessitura.WebAPI.Tessitura.ProcessSeatRequest(SeatRequest seatRequest)
at Tessitura.WebAPI.Tessitura.ReserveTicketsDirect(String sWebSessionID, String sPriceType, Int32 iPerformanceNumber, Int32 iNumberOfSeats, Int32 iZone, String sSpecialRequests, String RequestedSeats)
at Tessitura.WebAPI.Tessitura.ReserveTicketsSpecifiedSeats(String sWebSessionID, String sPriceType, Int32 iPerformanceNumber, Int32 iNumberOfSeats, Int32 iZone, String sSpecialRequests, String RequestedSeats)
Any ideas on what I may be missing here?
Thanks in advance!
Hey Ryan,
Did you find a solution for this? I'm experiencing the same issue.
Thanks!
Janelle
I would review this setting in the T_DEFAULTS system table. This is from the help system:
BEST SEAT DONATED SEATS
When set to Yes, seats previously donated for resale can be reserved by the best seat function. When set to No (or the entry does not exist) the best seat function ignores seats previously donated for resale.
We are able to reserve a donated seat via best available without a hitch but would like the seat to appear on our select your own seat map to make it easier for our patrons to purchase. Is best available the only way to reserve a donated seat for resale?
Thanks for the help!
Janelle - Did you ever get an answer to your question? We're having the same issue with donated seats not showing up on our SYOS map. We have a custom website.
I must have missed the previous post. Sorry that no one chimed in here!
The answer is that you need to make a modification to the TR_SEAT_STATUS system table. Here's the relevant bit from the documentation for the table:
If the desired behavior for Donated for Resale seats is that they should be able to be held, then it is allowed to change the Status Priority value for ID 18 (Donated for Resale) to 15.
have you ever resolved the issue? I got the same issue here!
Unknown said:Janelle - Did you ever get an answer to your question? We're having the same issue with donated seats not showing up on our SYOS map. We have a custom website.
Christina,
I found the solution here.
Because when you choose a seat that will leave an Orphan seat. That means you leave single seats parameter in either empty or N on ReserveTicketSpecifiedSeats method. Here how I set up on this parameter
$var = array(...., 'SpecialRequests'=>"LeaveSingleSeats=Y", ...);
I am using PHP to call this method. Now, you can select your own seats.
http://www.tessituranetwork.com/Community/forums/t/4204.aspx
Hope it helps.