How can we help you today? How can we help you today?
DROP_TABLE_Students
@Dan_J - Thanks for the reply. I have added "C:\Users\my_user_name\AppData\Local\Red Gate\SQL Source Control 7" to my Microsoft Defender exclusions.  I'll monitor and see if the issue comes up again - if so, I'll send logs. / comments
@Dan_J - Thanks for the reply.I have added "C:\Users\my_user_name\AppData\Local\Red Gate\SQL Source Control 7" to my Microsoft Defender exclusions.  I'll monitor and see if the issue comes up again...
0 votes
@Dan_J - Got an error after adding the exclusion.  Following is the applicable error message from the logs: <div>2021-09-15 07:35:56.989 -07:00|Error|RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2[[RedGate.SQLSourceControl.Engine.Diff.IChangeSetWithWorkspace, RedGate.SQLSourceControl.Engine, Version=7.2.35.13078, Culture=neutral, PublicKeyToken=7f465a1c156d4d57],[RedGate.SQLSourceControl.CommonUI.Controls.DifferencesViewerControl, RedGate.SQLSourceControl.CommonUI, Version=7.2.35.13078, Culture=neutral, PublicKeyToken=7f465a1c156d4d57]]|77| An exception occurred whilst performing an operation</div><div>System.TimeoutException: Couldn't get write lock</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.PersistentWorkspace.UpgradeToWriteLock(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.PersistentWorkspace.<>c__DisplayClass9_0.<UpgradeAll>b__0(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.NamedOperation.Operation(ICancellableOperationStatus cancellableOperation)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.<Invoke>b__9_0()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.Invoke()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithStatus(ICancellableOperationStatus status, ICancellable cancellable, Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperation`1.ExecuteAsOnOperation(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperationWithPostTask`1.ExecuteAsOnOperation(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuilding.NoOpsResolver.ResolveNoOps(IFilterConfigDiffCreator filterConfigDiffCreator, Boolean compareConfigIsNoOp, Boolean isPreScriptNoOp, Boolean isPostScriptNoOp, DatabaseObjectIdSet dataNoOpIds, DatabaseObjectIdSet schemaNoOps, IThreeWayDiffSession threeWayDiffSession, List`1 changes, ITransientWorkspace transientWorkspace)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuilding.ToCommitAndRetrieveChangeSetCreator.RetrieveNoOpChanges(DatabaseObjectIdSet schemaNoOpIds, DatabaseObjectIdSet dataNoOpIds, Boolean preScriptNoOp, Boolean postScriptNoOp)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuilding.ToCommitAndRetrieveChangeSetCreator.ResolveTheseNoOps(Boolean isCompareConfigNoOp, Boolean isPreScriptNoOp, Boolean isPostScriptNoOp, DatabaseObjectIdSet schemaNoOpIds, DatabaseObjectIdSet dataNoOpIds)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuilding.ToCommitAndRetrieveChangeSetCreator.ResolveAnyNoOps(ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.GetChangeSetResolvingNoOps[T](String source, IBoundDatabase boundDatabase, IChangeSetFactory`1 changeSetFactory, ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.BuildToCommitChangeSet(IBoundDatabase boundDatabase, ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.GetNewCommitableChanges(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.<>c__DisplayClass25_0.<GetCancellableCommitableChanges>b__0(ICancellableOperationStatus status)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.<>c__DisplayClass7_0.<Invoke>b__0()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.Invoke()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationTypeConverter`2.Invoke()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.<>c__DisplayClass30_0.<InvokeOperation>b__1()</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.Engine.Utils.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isFatalPredicate, Boolean rethrow)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.CommonUI.ErrorHandling.SaErrorReporter.DoWithObviousExceptionsRethrowAll(Action action)</div><div>&nbsp; &nbsp;at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.InvokeOperation(ICancellableOperation`1 operation, Object token)</div> / comments
@Dan_J - Got an error after adding the exclusion.  Following is the applicable error message from the logs:<div>2021-09-15 07:35:56.989 -07:00|Error|RedGate.SQLSourceControl.CommonUI.Controls.Cance...
0 votes
Excellent @David Atkinson.  I've been looking forward to this and will try to test it out soon.  Thank you for the preview. / comments
Excellent @David Atkinson.  I've been looking forward to this and will try to test it out soon.  Thank you for the preview.
0 votes