Problem w/Web Orders in Single Sale Order Listing

Within the time-frame in which this report has stopped working properly, have you either changed the name or IP address of your Web API server or have those services been moved to different servers?

I’ve experienced orders not showing up in the Single Sale Order Listing (particularly for the Web user) when there’s a discrepancy between the create_loc in T_ORDER and the machine_name in TX_MACHINE_LOCATION_HIST – specifically, when TX_MACHINE_LOCATION_HIST doesn’t contain the ID of the virtual “workstation” the web API uses as its create_loc for web orders.

To find all the machine names the web API has used, run the following query in SQL Management Studio (substitute your own web user name for ‘%webapi%’):

select min(create_dt),(create_loc),created_by

from t_order

  where created_by like '%webapi%'

   group by create_loc,created_by

Then check to see that all of the locations from that query exist in TX_MACHINE_LOCATION_HIST:

select create_loc, from TX_MACHINE_LOCATION_HIST

where machine_name in (select distinct(create_loc)

from t_order

  where created_by like '%webapi%')

There are two situations that can cause the problem:

1.       There’s a value in T_ORDER for create_loc that doesn’t exist at all in TX_MACHINE_LOCATION_HIST.

2.       There’s a value in T_ORDER for create_loc that does exist in TX_MACHINE_LOCATION_HIST, but the start_dt in the latter table is later than the create_dt in T_ORDER.

To fix either problem, update or manually edit TX_MACHINE_LOCATION_HIST so that there is a row in the table for the machine_name, and the start_dt is /before/ the create_dt from t_order. Once those rows exist and have valid start_dt entries, the orders should show up in the Single Sale Order Listing.

Normal 0 false false false MicrosoftInternetExplorer4

I run the single sales order listing report so that we can get the web orders that requested tickets to be mailed. This was working prior to the new year, and this week is the first time I have tried running it in 2012. The only parameter I change when I run the report is the ‘performance date start’ as we don’t mail tickets that are less than 10 days out.

When I run it with the parameters below I receive no results, but I know that there are orders that fit this parameter, as we have manually printed them when folks have called to complain that they haven’t received them yet.

If I clear out the ‘delivery’ option from being selected as US Mail(2) to having nothing selected, then I get some results but still none of the orders that do show up are the US Mail delivery method.

Normal 0 false false false MicrosoftInternetExplorer4

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!