• Replies 8 replies
  • Subscribers 247 subscribers
  • Views 152 views
  • Users 0 members are here
Related

PrintAtHome - Tessitura.WebAPI.Tessitura.GetOrdersForDelivery is timing out.

Neal Pandey
$organization

Hi There,

Is there way to search forums? I did not find it and so I am creating new post.

Our PrintAtHome suddenly stopped working. I checked ETicket service, WebAPI and SMTP Server; and they all look good. Our website www.ocpac.org is selling tickets but only PrintAtHome tickets delivery via email is down. I think it is a data or database issue based on below PAH log error. We are still investigating but I wonder if anybody had similar issue or know solution. Thanks in advance for help.

10.01.26 10:51:53.774 0006 [Verbose, 1000] +++ Send Complete
10.01.26 10:51:53.774 0006 [Verbose, 1000] keepGoing = False
10.01.26 10:51:53.774 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:51:53.821 0005 [Information, 1002] Email status updated for order 2501452
10.01.26 10:51:53.821 0005 [Information, 1002] Processing Order 2 of 2 Orders. Order #2501452 Succeeded
10.01.26 10:51:53.821 0005 [Verbose, 1001] sleeping: 00:02:00
10.01.26 10:52:53.774 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:53:53.773 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:53:53.820 0005 [Verbose, 1001] Getting orders for delivery, days=1, delivery=21, maxorders=0
10.01.26 10:54:23.820 0005 [Warning, 1001] Exception occurred while processing batch.System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at Tessitura.WebAPI.Tessitura.GetOrdersForDelivery(String sMos, String dPerformanceStartDate, String dPerformanceEndDate, String dOrderStartDate, String dOrderEndDate, Int32 iOrderDaysPast, String sDeliveryMethod, Int32 iMaxOrdersReturned, String cPrimaryEmail)
   --- End of inner exception stack trace ---
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at ETicketServerLibrary.API.Tessitura.GetOrdersForDelivery(String sMos, String dPerformanceStartDate, String dPerformanceEndDate, String dOrderStartDate, String dOrderEndDate, Int32 iOrderDaysPast, String sDeliveryMethod, Int32 iMaxOrdersReturned, String cPrimaryEmail)
   at Tessitura.ETicket.WindowsService.Orders.Execute(String receipt)
   at Tessitura.ETicket.WindowsService.Scheduler.StartETicket()
10.01.26 10:54:53.773 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:55:53.773 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:56:53.772 0006 [Verbose, 1000] Beginning of EmailThread loop
10.01.26 10:57:23.850 0005 [Verbose, 1001] Getting orders for delivery, days=1, delivery=21, maxorders=0
10.01.26 10:57:53.772 0006 [Verbose, 1000] Beginning of EmailThread loop

  • $organization

    Hi Neal,

    Good day.

    That is a timeout issue.

    maybe should check something:

    1, the link between PHAT machine and WebAPI machine.

    Try to run web api manually from PHAT machine, whether it will show the Web API page or not.

    2, Check SQL server find out whether the "exec wp_get_orders_for_delivery @use_primary_email=default,@delivery_method=N''@your_method_numbers" is running or not. this is the call from PHAT windows service. 

    3, I don't know where I can set the PHAT timeout, maybe it is in TR_PAHT_CONFIGURATION"[email_send_timeout_ms]". in your log file, timeout is 30 seconds.

     

    have fun

    Ben

     

  • $organization in reply to Ben Gu

    Good Day Ben,

    Thanks for help. I did check

    #1. WebAPI and TPAHTS are on same server. I checked they are talking. I can also see that in TPAHTS log file.

    #2. Yes that is the problem. When I executed wp_get_orders_for_delivery it runs for ever without getting any data which I think is cause of timeout at API/TPAHTS level. I tried to @order_days_past = 1 but it stills run for ever.
    EXEC [dbo].[WP_GET_ORDERS_FOR_DELIVERY]
      @order_days_past = 1,
      @delivery_method = N'21',
      @use_primary_email = default

    #3. The only timeout key I see in ETicketServerServiceLive.exe.config is
      <add key="EmailSendTimeoutMsecs" value="120000" />
      
      
    Why would suddenly WP_GET_ORDERS_FOR_DELIVERY timeout is mystery to me? We haven't changed anything in the system recently. Is it a bad data or order causing it? I can't think of anything at this moment. We checked recent orders and they look good.

  • $organization in reply to Neal Pandey

    Hi Neal,

    Good day.

    I have a way to debug stored procedure. you can do it in test only.( Tessitura does not allow us to do it in LIVE.)

    you can modify the WP_GET_ORDERS_FOR_DELIVERY.

    put "

    Print 'I am here'

    "

    inside the stored procedure.

    when you run WP_GET_ORDERS_FOR_DELIVERY in management studio ,

    you can see them "I am here" in the Messages window.

    it does not modify the logic, it just sends out messages.

    so if you put a lot of such "Print",

    you can figure out where it starts falling.

     

    have fun

    Ben



    [edited by: Ben Gu at 6:01 PM (GMT -6) on 27 Jan 2010]
  • $organization in reply to Ben Gu

    To answer your question about searching the forum.  There is a community search page: http://www.tessituranetwork.com/community/search/ which looks only at forums, blogs and groups.

    I believe there is a shortcut to this in the right sidebar of the main forum page as well as a link to it at the top of the search results page after you enter a search term in the main "Search Site" box at the top of the site.

  • $organization in reply to Levi Sauerbrei

    Thanks Ben and Levi for help and hints.

    We have opened support ticket to look into the timeout issue.

    Regards,
    Neal

  • $organization in reply to Neal Pandey

    Hi Neal,


    Did you ever find out what the issue was with this?


    Caryl

  • $organization

    This is really odd...

    I've been seeing this issue all afternoon, and wasn't able to resolve straight away so stopped the service to prevent the annoying emails.  Came back to it for about half an hour, and while investigating it just went away.  I didn't do anything at all really, just ran a trace, execute the procedure in SQL Management Studio, noticed it took about 5 minutes.  Then everything just started working...

    Very odd.  But pleased its working now :)

  • $organization in reply to Caryl Jones

    Hi Caryl,

         Neal left our organization later that same year that he posted.  I hate to be presumptuous, but I have not heard of us having this issue in the past two years, so I believe it was resolved.  Whether it was fixed by Neal or our new Web Developer, Nicholas, is unknown.

    - Michael