Cannot seat new packages

Are you using a new mode of sale? If so, you have to make sure that all allocations associated with the facility being used are also associated with that MOS.

Chris Cuhel, Lyric Opera of Kansas City

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Steven Jirjis
Sent: Thursday, September 18, 2014 2:10 PM
To: Chris Cuhel
Subject: [Tessitura Ticketing Forum] Cannot seat new packages

Hello - I have just finished creating a new season and am unable to seat package line items.

• When using 'best seat', the error message received is: “Seat Reservation Failed: Could not find seats for specified criteria”
• When manually seating, the error message received is: “Error in uf_allot_satno_to_sli. Seat Details not retrieved properly.”

Strangely however, I am able to seat and sell the contents (performances) of that package without a problem. Being able to do this indicates that at the performance level:

• 1) price types are valid
• 2) MOS is valid
• 3) facility is valid

I have verified the package setup to make sure the appropriate price types & MOS are included and valid (which shouldn't be necessary to do anyway considering the error is seating related). 

I have also run the following scripts just to be safe:

• exec UP_POPULATE_TX_PERF_SEAT @season = 58
• exec UP_UPDATE_ZONE_NO @season = 58
• exec UP_UPDATE_LOGICAL_NOS @season = 58
• exec UP_REBUILD_ALL_BSMAPS
• exec UP_UPDATE_COMP_MAPS @season = 58
•  
• exec TP_CHECK_SEAT_STATUS @season = 58, @fix_problems = 'Y'
• exec TP_CHECK_BASE_STATUS @season = 58, @fix_problems = 'Y'

 I took a gander in tx_perf_seat to ensure seats exist in this table for said packages and they do indeed.

I am at a loss as to why I can seat and sell all performances individually but not a package of the same contents. 

Thoughts or ideas? Thanks

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. 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!

That’s a good thought but unfortunately isn’t the issue. We’ve been using this MOS for years and haven’t made changes to it. Also, the same MOS (and price type for that matter) was used when testing selling the performances individually.

I should have noted we are on v11 btw.

Hi Louise – I’m glad you found a fix!

I had built my packages (super, sub and perf groups) from the backend. Building the super packages on the front end resolved the issue for me. The sub pkg’s and & perf groups built on the backend worked fine, but something about the super pkg’s wouldn’t take. I followed the SQL profiler but it just wouldn’t work. I was in a time crunch then so I went ahead on the front end, never did get to the bottom of it though.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Louise Mie Larsen
Sent: Thursday, February 26, 2015 12:21 AM
To: Steven Jirjis
Subject: RE: [Tessitura Ticketing Forum] Cannot seat new packages

Hi again

I found the problem. I associated the "Unassigned(*)" allocation code to the MOS and that solved the problem.