Commit Changes Tab: Lock request time out period exceeded.

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

sccuser January 25, 2013 10:37

Comments

4 comments

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

Eddie D January 28, 2013 10:37

0
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?

jvcampbell May 15, 2013 09:07

0
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 July 18, 2013 09:32

0
Ok, that worked for me :

<DefaultTraceMinimumInterQueryTimeInMillis>60000</DefaultTraceMinimumInterQueryTimeInMillis>

Thanks!

fredendrix July 18, 2013 10:10

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Commit Changes Tab: Lock request time out period exceeded.

Comments

Add comment