-
Bug
-
Resolution: Fixed
-
High
-
11.3.1
-
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
- Select and Open a Portfolio
- Go to Portfolio Room
- Switch to Financials tab on the top right
- Scroll down to "Work Spend" list
- Click "View more" to load more work spend items
- 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
- relates to
-
JIRAALIGN-6313 Portfolio Room - Accepted Spend Panel is not working
- Closed
- is related to
-
ACE-6182 Loading...