Visual Studio Throws Exception and Restarts when using SQL Database Project Schema Compare

[Terry Clancy]

I use a Visual Studio SQL Database Project, for the purpose of Schema and Data Compare and Copy, when deploying from my Umbraco / uCommerce development environment to test and production servers.

This has worked in the past but with Microsoft Visual Studio 2019 Version 16.5.4 the VS SQL Database Project Schema Compare causes Visual Studio to Throws Exception and Restart.

Looking at the Windows Event Viewer focused on Windows Logs/Application I see the following exception:

=================================================================

Application: devenv.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: System.OutOfMemoryException

at System.Windows.Media.Composition.DUCE+Channel.SyncFlush()

at System.Windows.Interop.HwndTarget.UpdateWindowSettings(Boolean, System.Nullable`1<ChannelSet>)

at System.Windows.Interop.HwndTarget.UpdateWindowPos(IntPtr)

at System.Windows.Interop.HwndTarget.HandleMessage(MS.Internal.Interop.WindowMessage, IntPtr, IntPtr)

at System.Windows.Interop.HwndSource.HwndTargetFilterMessage(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)

at MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)

at MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)

at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)

at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)

at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)

at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)

=================================================================

followed immediately by

=================================================================

Faulting application name: devenv.exe, version: 16.5.30011.22, time stamp: 0x5e928a4c

Faulting module name: KERNELBASE.dll, version: 10.0.18362.778, time stamp: 0x692cf0ab

Exception code: 0xe0434352

Fault offset: 0x00114192

Faulting process id: 0xde4

Faulting application start time: 0x01d62177a3085c54

Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\devenv.exe

Faulting module path: C:\windows\System32\KERNELBASE.dll

Report Id: 7af8f243-da6d-490d-bd73-a49dff9a3aa4

Faulting package full name:

Faulting package-relative application ID:

=================================================================


This is an urgent issue for me as it is preventing deployment. Any assistance would be appreciated.

Terry Clancy

ClanceZ


Terry Clancy

Continue reading...