• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 40 views
  • Users 0 members are here
Related

Seats are paid for but no attached to an order

Former Member
Former Member $organization

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

Parents
  • $organization

    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

     

Reply
  • $organization

    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

     

Children
No Data