hello,
so i've added a new screen to an existing seatmap. the completeness report doesn't show any errors. when clicking through to the seatmap in season manager or ticket orders, however, the only thing that appears is the new screen's name. the new screen is recognized in season maintenance by green asterisks, which obviously you can't apply holds to. i am very confused at this point.
pointers would be met with gratitude,
m-c
Hi M-C
When you make changes to an existing seatmap, there are a couple of Utility procs you need to run in SQL to update TX_Perf_seat, which is the table that holds the performance seat map details for display purposes.
This below is some details from the guide to system utility procs, which is here. You may need to run others, depending on whether you have existing packages built on the facility, etc. I haven't done this for a while myself, so you should check the doc.
UP_POPULATE_TX_PERF_SEAT will ensure that all necessary rows have been populated into Tx_Perf_Seat and Tx_Composite_Seat. Normally this takes places when you build a performance or a fixed seat package, but this procedure needs to be be run if seats are added to a facility after performances or packages have been built. This procedure has an optional parameter of Season. If that parameter is not passed, then all performances and packages are reviewed. This procedure will also update any row or seat numbers that have been changed in Facility Manager since the performance or package was built.
UP_REBUILD_ALL_BSMAPS rebuilds the Best Seat maps. This procedure should be needed only if seats have been added to a house after performances have been built. It is usually run in conjunction with UP_UPDATE_BSMAP_SEQUENCE (see below). This procedure has no parameters.
Ken
wow ken, thanks so much for your response. my organization sub-licenses so we don't have control access to the full tables. hopefully your advice helps a great deal.
thanks so much!