Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 10687757
KB4022753 - FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy - Microsoft Support
Last update date:
7/21/2023
Affected products:
SQL Server 2014 Developer - duplicate (do not use)
SQL Server 2014 Enterprise - duplicate (do not use)
SQL Server 2014 Enterprise Core - duplicate (do not use)
SQL Server 2014 Standard - duplicate (do not use)
SQL Server 2014 Service Pack 2 - duplicate (do not use)
SQL Server 2016 Developer - duplicate (do not use)
SQL Server 2016 Enterprise - duplicate (do not use)
SQL Server 2016 Enterprise Core - duplicate (do not use)
SQL Server 2016 Standard - duplicate (do not use)
SQL Server 2016 Service Pack 1
SQL Server 2017 on Windows (all editions)
SQL Server 2017 on Linux (all editions)
Affected releases:
build lower than 14.0.3006.16
Fixed releases:
14.0.3006.16
Description:
Symptoms
Assume that you use Microsoft SQL Server 2014, SQL Server 2016, or SQL Server 2017 Analysis Services (SSAS). When you run a Multidimensional Expressions (MDX) query that refers to a calculated member, and when the referenced calculated member is a child member of another hierarchy in SQL Server, SSAS may crash.
Resolution
This issue is fixed in the following cumulative updates for SQL Server: Cumulative Update 1 for SQL Server 2017 Cumulative Update 8 for SQL Server 2016 RTM Cumulative Update 5 for SQL Server 2016 SP1 Cumulative Update 6 for SQL Server 2014 SP2
