Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Timeout Expired in ...Tes...
Hello Inflectra support team, Recently a significant amount of timeout errors have been registered in the Spirateam log.
An error occurred while executing the command definition. See the inner exception for details.In APPLICATION.Web.Services.Ajax.Json.SpiraErrorHandler::ProvideFault:
Messages:An error occurred while executing the command definition. See the inner exception for details. [System.Data.EntityCommandExecutionException]Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. [System.Data.SqlClient.SqlException]The wait operation timed out [System.ComponentModel.Win32Exception]
Stack Trace:at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)at System.Data.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyMetadataCollection`1 entitySets, EdmType[] edmTypes, MergeOption mergeOption)at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters)at APPLICATION.Business.SpiraTestEntities.TestCase_RetrieveParentFolders(Nullable`1 projectId, Nullable`1 folderId, Nullable`1 isIncludeSelf)at APPLICATION.Business.TestCaseManager.TestCaseFolder_GetParents(Int32 projectId, Int32 testFolderId, Boolean includeSelf)at APPLICATION.Web.Services.Ajax.TestSetTestCaseService.RetrieveNameDesc(Nullable`1 projectId, Int32 testSetTestCaseId, Nullable`1 displayTypeId)at SyncInvokeRetrieveNameDesc(Object , Object[] , Object[] )at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
I tried to fix the problem by rebuilding indexes, but it had no effect.
Spirateam version 6.2.0.1 MS SQL Server 2014 Standard (64)Windows Server 2019 Standard edition, 24 GB, processors 6, Intel Xeon 4216 2.1 GHz
We have added significant performance improvements in test case folder caching in newer versions of Spira, I would upgrade to 7.11 when you get a chance.
Also check to make sure that you have no self-nested test case folders, that can cause an infinite loop and timeout.
For more assistance, please log a support ticket.
[TST_TEST_CASE_FOLDER] has been checked for self-nested folders and none were found.
Unfortunately our MS SQL Server is 2014 standard and I think we can't upgrade to Spira 7.x?
To isolate which SQL query is causing the delay:
Use SQL Server Profiler or Extended Events to capture:
Long-running queries
Blocking sessions
Wait types (look for CXPACKET, LCK_M_, PAGEIOLATCH_)
This will help confirm if:
A specific stored procedure is taking too long
A query is being blocked or scanning a massive result set
Escape Road
The timeout errors you're encountering suggest that some database queries are taking too long to execute, possibly due to large data volumes or inefficient query paths. Since rebuilding indexes didn’t resolve the issue, we recommend checking for:
Agario
And if you have any questions, please email or call us at +1 (202) 558-6885
