-
Type:
Testing Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Bad Data
-
Affects Version/s: CFA 2020R2
-
Fix Version/s: None
-
Component/s: Item Activity
-
Labels:
-
SCRUM Team:Globogym Purple Cobras
-
Sprint:CFAMX 2020R3 SA Sprint 5
When trying to run the Item Activity in Staging, for the default date range, 7 days, and Chicken Filet, the page is timing out.
It appears to be running in Testing.
The wait operation timed out Errors Help About System.ComponentModel.Win32Exception: The wait operation timed out NHibernate.Exceptions.GenericADOException: could not execute query [ Exec dbo.qryMMSInventory_ItemActivityDetails @p0, @p1, @p2, @p3, @p4 ] Name:EntityId - Value:1041 Name:ItemId - Value:16 Name:StartDate - Value:5/21/2020 12:00:00 AM Name:EndDate - Value:5/28/2020 1:58:28 PM Name:IncludeGiveaways - Value:True [SQL: Exec dbo.qryMMSInventory_ItemActivityDetails @p0, @p1, @p2, @p3, @p4] ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
