System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. when opening TESTING > TEST SETS v.4.1.0.2

Thursday, February 13, 2014 3:04:01 PM
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
5 Replies
Thursday, February 13, 2014 3:07:10 PM
Avatar
re: tyronefrance on Thursday, February 13, 2014 3:04:01 PM
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)
Wednesday, February 26, 2014 8:53:31 AM
Avatar
re: tyronefrance on Thursday, February 13, 2014 3:04:01 PM

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

Wednesday, February 26, 2014 8:57:14 AM
Avatar
re: pgrill1 on Wednesday, February 26, 2014

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)

Tuesday, July 15, 2014 6:37:42 PM
Avatar
re: pgrill1 on Wednesday, February 26, 2014
Did you ever find a solution to your issue? We are having a similar problem with our Spira Test configuration.
Wednesday, July 23, 2014 8:40:48 PM
Avatar
re: a_shotton on Tuesday, July 15, 2014

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

Statistics
  • Started: Thursday, February 13, 2014 3:04:01 PM
  • Last Reply: Wednesday, July 23, 2014 8:40:48 PM
  • Replies: 5
  • Views: 5257