SCA is unreliabe

pkettlew

I get this error , randomly , now consistently

RedGate.Versioning.Client.VsShell.Ssms.Models.Observable.UnhandledObserverException: A subscribed observable threw an unhandled exception: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.

   at RedGate.Versioning.Client.VsShell.Ssms.Ui.Utilities.ObjectFilterer.<>c__DisplayClass0_0`1.<Filter>b__0(T x)

   at System.Linq.Enumerable.WhereArrayIterator`1.MoveNext()

   at System.Collections.ObjectModel.CollectionExtensions.AddRange[T](Collection`1 collection, IEnumerable`1 items)

   at RedGate.Versioning.Client.VsShell.Ssms.Ui.Views.GenerateMigrations.GenerateMigrationsViewModel.UpdateFilteredDifferences()

   at RedGate.Versioning.Client.VsShell.Ssms.Ui.Views.GenerateMigrations.GenerateMigrationsViewModel.OnComparisonModelUpdated(ProjectComparisonModel comparisonModel)

   at RedGate.Versioning.Client.VsShell.Ssms.Models.Observable.ActionObserver`1.OnNext(T value)

   at RedGate.Versioning.Client.VsShell.Ssms.Models.Observable.Subject`1.Next(T value)

   --- End of inner exception stack trace ---=

There seems to be no information to help 

Where do we go to get help, what does this error mean ?

pkettlew

Where do we go to get help, what does this error mean ? I consistently get it on SSMS 18 , SCA 4.3 . Everytime I click Generate Migrations , can I get help on how to solve this .

pkettlew

Any update on my issue .  At the end of every generate migrations I get the above error . Am I asking in the wrong forum ?

MyUniqueSelf

I experience the same issue.
I think that using the Visual Studio plugin instead. works most of the time.
I think that only the SSMS plugin has this problem, on my machine at least.

pkettlew

why has this been changed to solved in the forum ? It is not

Jessica R

Hi both,

So sorry for this issue, it seems to be related to the new filter option on the Generate Migrations page.

We are looking into this and will post here once we have an update. In the meantime, however, you can likely get around this by installing this version which doesn't have the filtering feature:
https://download.red-gate.com/checkforupdates/SQLChangeAutomation/SQLChangeAutomation_4.3.20336.23358.exe