Prize Zone Map not updating within order screen

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

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!