Order Import Utility Error

Hi All,

Good day.

I think [dbo].[TP_ORDER_IMPORT_MAIN] has a bug in it.

 -- Loop through each ticket and mark as printed

Line 2508 code should be:While @ticket_no < @last_ticket_no

Line 2494-2522

===========================

-- PRINT TICKETS for order if specified for the import set
If @print_tickets_ind = 'Y'
Begin
Select @print_count = count(sli_no) From [dbo].T_SUB_LINEITEM
Where order_no = @order_no and sli_status = @sli_seated_paid and perf_no > 0

-- Get a batch of ticket numbers
Execute @ticket_no = [dbo].AP_Get_NextID_function 'TN', @increment = @print_count
Select @last_ticket_no = @ticket_no + @print_count

Insert Into @print_set (sli_no, ticket_no)
Select sli_no,
@ticket_no + row_number() over (order by sli_no) - 1
From [dbo].T_SUB_LINEITEM
Where order_no = @order_no
and sli_status = @sli_seated_paid

-- Loop through each ticket and mark as printed
While @ticket_no <= @last_ticket_no
Begin
Select @sli_no = sli_no
From @print_set
Where ticket_no = @ticket_no

EXEC [dbo].TP_UPDATE_SLI_WITH_TICKET
@sli_no = @sli_no,
@new_tkt_no = @ticket_no,
@session_id = @ticket_session_no

Select @ticket_no = @ticket_no + 1

End
End -- If @print_tickets_ind = 'Y'

======================= 

Have fun

Ben

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

Hi All,

Good day.

I think [dbo].[TP_ORDER_IMPORT_MAIN] has a bug in it.

 -- Loop through each ticket and mark as printed

Line 2508 code should be:While @ticket_no < @last_ticket_no

Line 2494-2522

===========================

-- PRINT TICKETS for order if specified for the import set
If @print_tickets_ind = 'Y'
Begin
Select @print_count = count(sli_no) From [dbo].T_SUB_LINEITEM
Where order_no = @order_no and sli_status = @sli_seated_paid and perf_no > 0

-- Get a batch of ticket numbers
Execute @ticket_no = [dbo].AP_Get_NextID_function 'TN', @increment = @print_count
Select @last_ticket_no = @ticket_no + @print_count

Insert Into @print_set (sli_no, ticket_no)
Select sli_no,
@ticket_no + row_number() over (order by sli_no) - 1
From [dbo].T_SUB_LINEITEM
Where order_no = @order_no
and sli_status = @sli_seated_paid

-- Loop through each ticket and mark as printed
While @ticket_no <= @last_ticket_no
Begin
Select @sli_no = sli_no
From @print_set
Where ticket_no = @ticket_no

EXEC [dbo].TP_UPDATE_SLI_WITH_TICKET
@sli_no = @sli_no,
@new_tkt_no = @ticket_no,
@session_id = @ticket_session_no

Select @ticket_no = @ticket_no + 1

End
End -- If @print_tickets_ind = 'Y'

======================= 

Have fun

Ben

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

Thank you very much Bob, I have raised a helpdesk ticket.

Ben