Generic "Scripts Folder Command" error when getting latest

Jives

I am receiving the following error when attempting to get latest on 1 of 5 databases. All other databases correctly return results.

Below is the full error message I'm receiving.

Scripts Folder Command
   at RedGate.SQLDataCompare.Engine.ComparisonSession.GetTableReaders(ITableReader& reader1, ITableReader& reader2, ISQLProvider provider1, ISQLProvider provider2, TableMapping mapping)
   at RedGate.SQLDataCompare.Engine.ComparisonSession.ComparePairOfTables(SessionSettings sessionSettings, TableMapping mapping, ProgressPercentageTracker progress, ITableReader& r1, ITableReader& r2)
   at RedGate.SQLDataCompare.Engine.ComparisonSession.CompareMapping(SessionSettings sessionSettings, TableMapping mapping, ProgressPercentageTracker progress)
   at RedGate.SQLDataCompare.Engine.ComparisonSession.CompareDatabases(IDatabase db1, IDatabase db2, TableMappings mappings, SessionSettings sessionSettings, Boolean doNotBeDefeated)
   at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DataCompare.DataCompareComparisonSession.CompareDatabases(ICompareDatabase db1, ICompareDatabase db2, IDataCompareSchemaMappings mappings)
   at RedGate.SQLSourceControl.Engine.Diff.SqlDataCompare.<>c__DisplayClass0_0.<CompareDatabasesWithCancel>b__0()
   at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)
   at RedGate.SQLSourceControl.Engine.Diff.SqlDataCompare.CompareDatabasesWithCancel(ICancellableOperationStatus status, ICompareDatabase db1, ICompareDatabase db2, IDataCompareSchemaMappings mappings)
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.HeadToWorkingBaseComparisonFactory.GetRegistered(ICompareDatabase head, ICompareDatabase workingBase, ICancellableOperationStatus status)
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DataCompareSessionWrapper.CompareData(IEnumerable`1 tableObjectIdsBeingDropped, ICancellableOperationStatus status)
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DataDifferencesGetter.GetDataDifferences()
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.GetDataDifferences(ThreeWorkspaceRegistrar registrar, DatabaseObjectIdDictionary`1 indexedDifferencesLiveToWorkingBase)
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.BuildCommon()
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.GetChangeSetResolvingNoOps[T](String source, IBoundDatabase boundDatabase, IChangeSetFactory`1 changeSetFactory, ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)
   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.BuildToRetrieveChangeSet(IBoundDatabase boundDatabase, ICancellableOperationStatus status)
   at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.GetNewRetrievableChanges(ICancellableOperationStatus status)
   at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.<>c__DisplayClass7_0.<Invoke>b__0()
   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)
   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)
   at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.Invoke()
   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationTypeConverter`2.Invoke()
   at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.<>c__DisplayClass30_0.<InvokeOperation>b__1()
   at RedGate.SQLSourceControl.Engine.Utils.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isFatalPredicate, Boolean rethrow)

Here are the comparison options I'm using.


I do not currently have any static data linked.

Let me know if there are any additional details I can provide. Any help would be greatly appreciated.

Jives

Going back to an older version of SSMS (2019 > 2016) resolved the issue.
Note: This is using SQL Source Control 7.

chrisqtran

Hi there,

Can you tell me the exact version of SQL Source Control that you are using?

The most up to date version is SQL Source Control 7.6.25.17749.