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
Avatar
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
Avatar
re: tyronefrance Thursday, February 13, 2014
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
Avatar
re: tyronefrance Thursday, February 13, 2014

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
Avatar
re: pgrill1 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
Avatar
re: pgrill1 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
Avatar
re: a_shotton 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

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, February 13, 2014
  • Last Reply: Wednesday, July 23, 2014
  • Replies: 5
  • Views: 16214