How can we help you today? How can we help you today?

SQL Prompt version 11.3.8 constantly crashes SSMS (both v 22.3.3 and 22.4.1)

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?

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)
 

Rossen
0

Comments

1 comment

  • Rossen

    Update: After uninstalling all RedGate tools and doing a clean install, the SSMS and the RedGate extension are working again. Perhaps some cache cleanup or update is needed during the SQL Prompt update?

    Rossen
    0

Add comment

Please sign in to leave a comment.