We have created new zones in an existing map mid season. We ran the SQL database utilities for:
UP_POPULATE_TX_PERF_SEAT
UP_UPDATE_COMP_MAPS
UP_UPDATE_ZONE_NO
Seats were not deleted from the seat map and contiguity was not changed.
I am finding that when I run a list based off of these new zones I am generating a list of zero because I don't think Tessitura is recognizing the new zones for existing packages since this was done mid season.
Any help would be greatly appreciated. If this is not enough information, please let me know and I will be happy to elaborate.
Thank you,
Jena Tunnell, Dallas Symphony Orchestra
It's my understanding that when you change facilities after sales you should run
EXEC UP_REBUILD_ALL_BSMAPS
EXEC UP_UPDATE_BSMAP_SEQUENCE
EXEC UP_UPDATE_LOGICAL_NOS
in addition to the three you mentioned. Might be one of those will fix whatever the problem is.