Portfolio Room - Error while getting Accepted Spend

XMLWordPrintable

    • 1
    • Severity 2 - Major
    • No
    • None

      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

            Assignee:
            Bhanu Vanjaku
            Reporter:
            Joe Win
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: