Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-13276

Event Driven Task polling queue Timeout error

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: CFA 2021R2
    • Component/s: None
    • Labels:
      None
    • Root cause - Reason:
      Code defect
    • Root Cause:
      code defect

      Description

      It appears that a query is timing out causing the Task queue to rise.

      Title: Enterprise Library Exception Handling
      Timestamp: 1/30/2021 1:10:08 AM
      Message: HandlingInstanceID: c1104a08-3cdc-470f-8af2-7048687f26ac
      An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
      ----------------------------------------------------------------------------------
      01/29/2021 20:10:08
      Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
      Message : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
      Source : .Net SqlClient Data Provider
      Help link :
      Errors : System.Data.SqlClient.SqlErrorCollection
      Class : 11
      LineNumber : 0
      Number : -2
      Procedure :
      Server : ATL2CFASQLV001
      State : 0
      ErrorCode : -2146232060
      Data : System.Collections.ListDictionaryInternal
      TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
      Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
      at Mx.Data.EntityItemData.qryMMSEntityItem_CalculateUPTonStockCountApplied(Int64 entityId, Int64 daysInCalculation, Int64 transactionStockCountLocationId, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey)
      at Mx.Services.EntityItemService.CalculateAndUpdateUPTQuantityFromDailyStockBalanceOnStockCountApplied(Int64 entityId, Int64 transactionStockCountLocationId)
      Additional Info:
      MachineName : ATL2CFAAPPV001
      TimeStamp : 1/30/2021 1:10:08 AM
      FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
      AppDomainName : eStruxure Manager.exe
      ThreadIdentity :
      WindowsIdentity : CFA\administrator
      Activity Token: 00000000-0000-0000-0000-000000000000
      Category: General
      Priority: 0
      EventId: 100
      Severity: Error
      HelpLink.ProdName: Microsoft SQL Server
      HelpLink.ProdVer: 13.00.4466
      HelpLink.EvtSrc: MSSQLServer
      HelpLink.EvtID: -2
      HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
      HelpLink.LinkId: 20476
      Machine: ATL2CFAAPPV001
      Application Domain: eStruxure Manager.exe
      Process Id: 7188
      Process Name: H:\Macromatix\ServerManager\Chick-fil-A - Instance 1\eStruxure Manager.exe
      Win32 Thread Id: 4784
      Thread Name: Event Driven Task Polling Queue

      Title: Enterprise Library Exception Handling
      Timestamp: 1/31/2021 2:40:10 AM
      Message: HandlingInstanceID: d4c11086-b355-4f96-a425-ad3efea087af
      An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
      ----------------------------------------------------------------------------------
      01/30/2021 21:40:10
      Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
      Message : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
      Source : .Net SqlClient Data Provider
      Help link :
      Errors : System.Data.SqlClient.SqlErrorCollection
      Class : 11
      LineNumber : 0
      Number : -2
      Procedure :
      Server : ATL2CFASQLV001
      State : 0
      ErrorCode : -2146232060
      Data : System.Collections.ListDictionaryInternal
      TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
      Stack Trace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
      at Mx.Data.EntityItemData.qryMMSEntityItem_CalculateUPTonStockCountApplied(Int64 entityId, Int64 daysInCalculation, Int64 transactionStockCountLocationId, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey)
      at Mx.Services.EntityItemService.CalculateAndUpdateUPTQuantityFromDailyStockBalanceOnStockCountApplied(Int64 entityId, Int64 transactionStockCountLocationId)

      Additional Info:

      MachineName : ATL2CFAAPPV001
      TimeStamp : 1/31/2021 2:40:10 AM
      FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
      AppDomainName : eStruxure Manager.exe
      ThreadIdentity :
      WindowsIdentity : CFA\administrator

      Activity Token: 00000000-0000-0000-0000-000000000000
      Category: General
      Priority: 0
      EventId: 100
      Severity: Error
      HelpLink.ProdName: Microsoft SQL Server
      HelpLink.ProdVer: 13.00.4466
      HelpLink.EvtSrc: MSSQLServer
      HelpLink.EvtID: -2
      HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
      HelpLink.LinkId: 20476
      Machine: ATL2CFAAPPV001
      Application Domain: eStruxure Manager.exe
      Process Id: 7188
      Process Name: H:\Macromatix\ServerManager\Chick-fil-A - Instance 1\eStruxure Manager.exe
      Win32 Thread Id: 5904
      Thread Name: Event Driven Task Polling Queue

        Attachments

          Activity

            People

            • Assignee:
              Cherlyn.Thomas Cherlyn Thomas
              Reporter:
              Cherlyn.Thomas Cherlyn Thomas
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.