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 More

Symptoms


Consider the following scenario:

  • You have SQL Server Analysis Services (SSAS) installed on Microsoft SQL Server 2016 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:
         SELECT DIMENSION_NAME, DIMENSION_TYPE FROM $SYSTEM.MDSCHEMA_DIMENSIONS

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

Resolution


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

Cumulative Update 11 for SQL Server 2016 Service Pack 1

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.