FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core


Consider the following scenario:

  • You have SQL Server Analysis Services (SSAS) installed on Microsoft SQL Server 2016 or 2017 in Multidimensional mode.
  • You use an XML for Analysis (XMLA) query to process a dimension two times.
  • You run the following Multidimensional Expressions (MDX) query:

In this scenario, you receive the following error message when you run the MDX query:


This problem fix is fixed in the following updates for SQL Server:

          Cumulative Update 13 for SQL Server 2017

          Cumulative Update 5 for SQL Server 2016 Service Pack 2

Cumulative Update 11 for SQL Server 2016 Service Pack 1


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.