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
Hi- You may want to check with some dba types, but I believe you'll need to run a script to update the zone numbers (p_update_zone_no...might be it).
Best of luck with this.
Kindly,
Mark