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

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