Seats are paid for but no attached to an order

Hi Naomi,

good day.

we have a scheduled SQL job running every night.

here is the script:

declare @season_str varchar(1000)
set @season_str = ''
select @season_str = @season_str + cast(id as varchar(10)) + ',' from dbo.TR_SEASON
WHERE     (end_dt > GETDATE() - 365) AND (inactive = 'N')

Execute TP_CHECK_SEAT_STATUS @season = null, @fix_problems = 'Y', @season_str =@season_str

If this script does not fix the problem, I think you need to raise a help desk ticket.

 

have fun.

Ben

 

also you can check the t_order_seat_hist.

select  * from t_order_seat_hist where seat_no in (weirdness_seat_numbers) and perf_no=one_of_our_shows_perf_no

Hello, we have found some weirdness on one of our shows. We have 2 seats that are paid on the map, but not printed and are not attached to an order. Any ideas what would cause this and how to fix it?

Naomi

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!