Hello Tessy Folks!
I'm relatively new to Tessitura, but did take a ticketing class. In the class we learned about facility manager. I'm attempting to adjust my "Price zone" map. It looks correct in facility manager but the old (non-updated) price zone map shows within the order screen.
Any ideas why my changes are not showing up in the best seat map tab, when I try to place an order?
Thank you!
Hi, Morgan:
I believe you (need to have access through Microsoft SQL Server Management Studio) need to run utility procedures when you update and want to extend the changed onto existing performances. Look at the Tessitura Database Utilities document to see which ones apply in your situation.
http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx
Here’s what I’ve saved to use for myself to fix seat map issues:
----------------
declare @season_no int
set @season_no = 96
--exec UP_POPULATE_TX_PERF_SEAT @season = @season_no
--exec UP_UPDATE_ZONE_NO @season = @season_no
--exec UP_UPDATE_LOGICAL_NOS @season = @season_no
--exec UP_REBUILD_ALL_BSMAPS --(no parameter--takes a couple of minutes)
--exec UP_UPDATE_BSMAP_SEQUENCE @season = @season_no
--exec UP_UPDATE_COMP_MAPS @season = @season_no
--exec TP_CHECK_SEAT_STATUS @season = @season_no, @fix_problems = 'Y'
--exec TP_CHECK_BASE_STATUS @season = @season_no, @fix_problems = 'Y'
-------------
Lucie
__________________________________________
Lucie Spieler
IT Development and Training Manager FLORIDA GRAND opera
Thanks so much!