Profile Picture

SQL Timeout - DataStorage

Posted By alpha23 3 Years Ago
Message
Posted Saturday March 22 2014
As of today, I'm receiving the error below and I'm unable to use RightEdge via SQL at this point. Other suggestions on SQL timeouts do not work or are unclear as to how to change the DataStorage plugin.

Please advise ASAP. Note, my SQL db is over 1 TB so I'm not sure if that is an issue. All indexes except TickData have been rebuilt and do not require rebuilding. I did create a new db and there are no problems with it's usage.

Thanks, Duane


An exception of type System.Data.SqlClient.SqlException was thrown.
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.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.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.LongCount[TSource](IQueryable`1 source)
at RightEdge.DataStorage.LinqToSQLDataAccessor`2.GetCount(DateTime start, DateTime end) in C:\RightEdgePlugins\DataStorage\LinqToSQLStorage.cs:line 537
at RightEdge.Common.Internal.BarDataStreamer..ctor(IDataStore dataStorage, IEnumerable`1 symbols, DateTime dataStartDate, DateTime tradeStartDate, Int32 leadBars, DateTime endDate, Boolean liveMode, Boolean useTicks)
at RightEdge.Shared.SystemWrapper.CreateNewSystem(SharedSystemRunData data, IDataStore dataStore)
at RightEdge.Shared.SystemWrapper.RunSystem(String filename, ServiceFactory brokerFactory, PluginSettings dataStoreSettings)
at RightEdge.Shared.SystemWrapper.RunSystem(String filename, ServiceFactory brokerFactory, PluginSettings dataStoreSettings)
at RightEdge.Shared.TradingModuleWrapper.Run(String filename)
at RightEdge.Shared.TradingModuleWrapper.RunSystem(SharedSystemRunData systemRunData)
at RightEdge.SystemProgress.InitAndRunSystem()

Edited: Saturday March 22 2014 by alpha23
Posted Sunday March 23 2014
Answered here: http://www.rightedgesystems.com/forums/Topic13394-7-1.aspx

Thanks,
Daniel
Posted Sunday March 23 2014
That did not work. I tried that before posting. I commented in the linked thread.

Thanks, Duane

Edited: Sunday March 23 2014 by alpha23


Similar Topics


Reading This Topic


2005-2017 © RightEdge Systems