Hi Guys, Please can someone help me... I have just finished upgrading SpiraTeam v4.0.0.16 to v4.1.0.2 and the the entire upgrade when smooth with no exceptions... I have now logged into Spirateam and all seems to be fine apart from one thing... When I select TESTING and then TEST SETS i am getting the following error : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Does anyone know what I can do you fix this ? Kind Regards Tyrone en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/831.aspxthreadId=831Tyrone R France (tyrone.france@mirada.tv)timeout Hi Guys, Please can someone help me... I have just finished upgrading SpiraTeam v4.0.0.16 to v4.1.0.2 and the the entire upgrade when smooth with no exceptions... I have now logged into Spirateam and all seems to be fine apart from one thing... When I select TESTING and then TEST SETS i am getting the following error : System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Does anyone know what I can do you fix this ? Kind Regards Tyrone Thu, 13 Feb 2014 15:04:01 -05002014-07-23T20:40:48-04:00/Support/Forum/spiratest/issues-questions/831.aspxmessageId=1515Tyrone R France (tyrone.france@mirada.tv) This is the Error log within the Admin Panel. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Inflectra.SpiraTest.Business.DataAccess.Fill(DataSet dataSet, String srcTable) at Inflectra.SpiraTest.Business.TestSet.Retrieve(Int32 userId, Int32 projectId, Int32 startRow, Int32 numberOfRows, Hashtable filters, Double utcOffset, Nullable`1 releaseId, Boolean includeExecutionData, Boolean includeDeleted) at Inflectra.SpiraTest.Web.Services.Ajax.TestSetService.HierarchicalList_Retrieve(Int32 projectId, JsonDictionaryOfStrings standardFilters, Boolean updatedRecordsOnly) at SyncInvokeHierarchicalList_Retrieve(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at Inflectra.SpiraTest.Web.Services.Utils.LocalizationOperationInvoker.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.ProcessMessage41(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet) Thu, 13 Feb 2014 15:07:10 -05002014-02-13T15:07:10-05:00/Support/Forum/spiratest/issues-questions/831.aspx#reply1515messageId=1550Patrik Grill (patrik.grill@juliusbaer.com) Hello all together, we are facing exactly the same issue - we migrated from 3.1 to 4.1.0.2 and also get the error message if we go to the testset view! Any ideas ? Thanks in advance and best regards, Patrik Wed, 26 Feb 2014 08:53:31 -05002014-02-26T08:53:31-05:00/Support/Forum/spiratest/issues-questions/831.aspx#reply1550messageId=1551Patrik Grill (patrik.grill@juliusbaer.com) we also tried to execute the rebuild index script ( http://inflectra.com/Support/KnowledgeBase/KB10.aspx ) but it has no effect - we still receive the error message! (we alse have restarted the IIS and DB server) Wed, 26 Feb 2014 08:57:14 -05002014-02-26T08:57:14-05:00/Support/Forum/spiratest/issues-questions/831.aspx#reply1551messageId=1737Andrew Shotton (andrew.shotton@mindgeek.com) Did you ever find a solution to your issue? We are having a similar problem with our Spira Test configuration. Tue, 15 Jul 2014 18:37:42 -04002014-07-15T18:37:42-04:00/Support/Forum/spiratest/issues-questions/831.aspx#reply1737messageId=1746David J (adam.sandman+support@inflectra.com) There was a specific issue with v4.1.0.2 that was fixed a while back, if you're running the most recent version (v4.1.0.6) and getting an error, please log a help desk ticket with us. Regards Adam Wed, 23 Jul 2014 20:40:48 -04002014-07-23T20:40:48-04:00/Support/Forum/spiratest/issues-questions/831.aspx#reply1746