'Object reference not set to an instance of an object' error when trying to do a new query in DAX

Fra1978 126 Reputation points

This is very frustrating, I just installed SSMS 18.8 and when I try to do something extremely basic like opening a 'new query' for DAX, I get this error:


How can I fix this?

Detail of the error:

TITLE: Microsoft SQL Server Management Studio


Object reference not set to an instance of an object. ( at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextView.UnsubscribeFromEvents()
at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextView.Close()
at Microsoft.VisualStudio.Text.Editor.Implementation.WpfTextViewHost.Close()
at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseExistingWpfTextView()
at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseBufferRelatedResources()
at Microsoft.VisualStudio.Editor.Implementation.SimpleTextViewWindow.CloseView()
at Microsoft.VisualStudio.Editor.Implementation.CompoundTextViewWindow.Close()
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellCodeWindowControl.UnsinkEventsAndFreeInterfaces()
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextEditorControl.Dispose(Boolean disposing)
at System.ComponentModel.Component.Dispose()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptEditorControl.Dispose(Boolean bDisposing)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.Dispose(Boolean bDisposing)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.MdxScriptEditorControl.Dispose(Boolean bDisposing)
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.OnWindowPaneClose()
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellWindowPaneUserControl.ClosePane()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowPaneDocumentObject.<>c__DisplayClass19_0.<DisposeManagedResources>b__0()
at Microsoft.VisualStudio.ErrorHandler.CallWithCOMConvention(Action method, Boolean reportError))





SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,171 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,801 Reputation points


    For this issue , first of run an update to the system, patch the newest update, see if this fix your issue . If not, you could try :

    1. You could try the solution 1 in this : Solution 1 - Run Fixit tool for KB4074906
    2. You could try uninstalled the security patch KB 4055002 from .Net framework see if it works.


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November