Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-7552

Portfolio Room - Error while getting Accepted Spend

XMLWordPrintable

    • 1
    • Severity 2 - Major
    • No

      Issue Summary

      An error occurs when trying to load Work Spend items list on Portfolio Room > Financial tab.
      " Error while getting Accepted Spend"

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Select and Open a Portfolio
      2. Go to Portfolio Room
      3. Switch to Financials tab on the top right
      4. Scroll down to "Work Spend" list
      5. Click "View more" to load more work spend items
      6. After clicking "View more" 3+ times, an "Error while getting Accepted Spend" ERROR occurred.

      Expected Results

      Accepted Spend value load properly

      Actual Results

      Received an "Error while getting Accepted Spend" ERROR

      The below exception is thrown in the log file:

      9/16/24
      3:22:25.455 PM	
      { [-]
         Exception: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
         at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result)
         at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
         at System.Threading.Tasks.Task.Execute()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at Dapper.SqlMapper.<QueryAsync>d__33`1.MoveNext() in /_/Dapper/SqlMapper.Async.cs:line 419
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.DataAccess.UnitOfWork.<FromSqlAsyncCustom>d__25`1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.Services.FinancialService.<>c__DisplayClass16_0.<<GetThemeCost>b__0>d.MoveNext() in C:\projects\alignapi\AgileCraft.Services\FinancialService.cs:line 186
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.Common.Core.Telemetry.FunctionRecorder.<TimeFunctionCall>d__11`1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.Services.FinancialService.<GetThemeCost>d__16.MoveNext() in C:\projects\alignapi\AgileCraft.Services\FinancialService.cs:line 185
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at Website.Api.Controllers.FinancialController.<>c__DisplayClass8_0.<<GetThemeCost>b__0>d.MoveNext() in C:\projects\alignweb\Website\Api\Controllers\FinancialController.cs:line 210
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at AgileCraft.Common.Core.Telemetry.FunctionRecorder.<TimeFunctionCall>d__11`1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at Website.Api.Controllers.FinancialController.<GetThemeCost>d__8.MoveNext() in C:\projects\alignweb\Website\Api\Controllers\FinancialController.cs:line 184
      ClientConnectionId:15f577f4-422a-4c7f-b877-b21f33b9ff27
      Error Number:-2,State:0,Class:11
         Level: Fatal
         MessageTemplate: GET:/api/financial/themes/cost
         Properties: { [-]
           ExceptionDetail: { [-]
             Class: 11
             ClientConnectionId: 15f577f4-422a-4c7f-b877-b21f33b9ff27
             Data: { [+]
             }
             Errors: [ [-]
               { [-]
                 Class: 11
                 LineNumber: 0
                 Message: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
                 Number: -2
                 Procedure:
                 Server: ue2-rds-m5-v00.c2tgadrdv5di.us-east-2.rds.amazonaws.com
                 Source: .Net SqlClient Data Provider
                 State: 0
                 _typeTag: SqlError
               }
             ]
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              9430c2193c41 Bhanu Vanjaku
              d5e5bcff7211 Joe Win
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: