Commit Changes Tab: Lock request time out period exceeded.

sccuser

I get this error while trying to load/refresh the commit changes tab in SQL Source Control 3 (latest version: 3.1). Is there a way to increase the time out period?

System.Data.SqlClient.SqlException: Lock request time out period exceeded.
   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(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#qWEc()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser..ctor(IDatabaseConnection serverConnection, IDatabasePollingSettings databasePollingSettings, Int32 matchCountLimit)
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser..ctor(IDatabaseConnection serverConnection, IDatabasePollingSettings databasePollingSettings)
   at DynamicInjector17754b3bcd5c41b8b82340f616d7df79(Object[] )
   at Ninject.Activation.Providers.StandardProvider.Create(IContext context)
   at Ninject.Activation.Context.Resolve()
   at Ninject.KernelBase.<>c__DisplayClasse.<Resolve>b__a(IBinding binding)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.<CastIterator>d__aa`1.MoveNext()
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Ninject.ResolutionExtensions.Get[T](IResolutionRoot root, IParameter[] parameters)
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.#sZe.#jii()
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.#21e[#NrPb](Func`1 )
   at RedGate.SQLSourceControl.Engine.ObjectFactoryShared.Get[T](Arg[] ctorArgs)
   at RedGate.SQLSourceControl.Engine.Diff.ObjectFactory.Get[T](Arg[] args)
   at #mlhb.#ny2b.#jiUc()
   at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func`1 func)
   at #GWeb.#WXM.#P6Uc(Func`1 )
   at #mlhb.#ny2b.#xFV()
   at #mlhb.#ny2b.#aQU(ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
   at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
   at #mlhb.#ry2b.#zYM(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
   at #GWeb.#VXM.#mYM[#NrPb](Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
   at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
   at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f()
   at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
   at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
   at #eEc.#Qlg.Invoke()
   at #JLc.#PLc.#Jfb.#EJf()
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
   at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
   at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
   at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )

Eddie D

Hi sccuser,

Thank you for your forum post.

To resolve this problem you could try reducing the polling time of SQL Source Control. You can do this by editing the RedGate_SQLSourceControl_Engine_EngineOptions.xml file in C:\Users\<username>\Appdata\Local\Red Gate\SQL Source Control 3.

Set the trace interval time as follows:

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

(you may need to add that line if it's not already there).

Once done, ensure you restart SSMS; also, you will need to perform this change on each PC / for each user.

I hope this helps.

Many Thanks
Eddie

jvcampbell

Hi

I tried the suggestion by adding the trace interval line, but when I restart SSMS the line is automatically removed.

How do I get around this?

fredendrix

Same problem here. That post describe the same issue, but no more answer...

http://www.red-gate.com/MessageBoard/vi ... hp?t=17454

Anyone could help please ?

fredendrix

Ok, that worked for me :

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

Thanks!