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!
I've noticed that when I return tickets it takes a while for them to become available again for the seat server.
They have been in the system for over a week now, so I don't think that's it.
Unfortunately, they are not locked...
Could it be that the seats are locked? You can check by running the Web Current Seats Locked report under Ticketing Reports.
From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Ryan Huber Sent: Monday, September 14, 2015 3:21 PM To: Gloria Ormsby Subject: [Tessitura Web Forum] Trouble with ReserveTicketsSpecifiedSeats and Seats Donated for Resale
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!
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.