I was using SSMS v 22.3.3 and got an update notification for SQL Prompt (updating from 11.3.7 to 11.3.8).
After updating SQL Prompt to 11.3.8, SSMS started crashing every time I attempt to use the Object Explorer (either expanding any node or connecting to a server which leads to the Object Explorer refresh).
Updated SSMS to the latest version 22.4.1 but the issue remains - SQL Prompt still crashes the SSMS. The error below is logged in Windows Event Viewer.
Application: SSMS.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.ConvertServerNode(Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.INodeInformation)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus+<get_ServerNodes>d__19.MoveNext()
at System.Linq.Enumerable+WhereSelectEnumerableIterator`2[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MoveNext()
at System.Collections.Generic.List`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.Collections.Generic.IEnumerable`1<System.__Canon>)
at System.Linq.Enumerable.ToList[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Collections.Generic.IEnumerable`1<System.__Canon>)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.HaveServerConnectionsChanged()
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.OnObjectExplorerContextChanged(System.Object, Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NodesChangedEventArgs)
Exception Info: System.Reflection.TargetInvocationException
at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(System.Object, System.Object[], System.Object[])
at System.Delegate.DynamicInvokeImpl(System.Object[])
at Microsoft.SqlServer.Management.SqlStudio.Explorer.BufferedNotification.Fire()
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.NetCore.TimerQueueTimer.CallCallback()
at System.Threading.NetCore.TimerQueueTimer.Fire()
at System.Threading.NetCore.TimerQueue.FireNextTimers()
at System.Threading.TimerQueue.AppDomainTimerCallback(Int32)
I was using SSMS v 22.3.3 and got an update notification for SQL Prompt (updating from 11.3.7 to 11.3.8).
After updating SQL Prompt to 11.3.8, SSMS started crashing every time I attempt to use the Object Explorer (either expanding any node or connecting to a server which leads to the Object Explorer refresh).
Updated SSMS to the latest version 22.4.1 but the issue remains - SQL Prompt still crashes the SSMS. The error below is logged in Windows Event Viewer.
Is there any solution to this issue?