Thread

Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > System.Data.SqlClient.Sql...

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 RSS Feed

Thursday, February 13, 2014
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
Tyrone R FranceTyrone R France
re: Tyrone R France on Thursday, February 13, 2014
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)
Patrik GrillPatrik Grill
re: Tyrone R France on Thursday, February 13, 2014
Wednesday, February 26, 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

Patrik GrillPatrik Grill
re: Patrik Grill on Wednesday, February 26, 2014
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)

Andrew ShottonAndrew Shotton
re: Patrik Grill on Wednesday, February 26, 2014
Tuesday, July 15, 2014
Did you ever find a solution to your issue? We are having a similar problem with our Spira Test configuration.
Adam SAdam S
re: Andrew Shotton on Tuesday, July 15, 2014
Wednesday, July 23, 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: 2/13/2014
  • Last Reply: 7/23/2014
  • Replies: 5
  • Views: 4232
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.