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:
SELECT DIMENSION_NAME, DIMENSION_TYPE FROM $SYSTEM.MDSCHEMA_DIMENSIONS
In this scenario, you receive the following error message when you run the MDX query:
Internal error: An unexpected exception occurred.
This problem fix is fixed in the following updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.