FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase

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

Symptoms


Consider the following scenario:
  • You use SQL Server 2017 or SQL Server 2016 Analysis Services (SSAS) in Tabular mode.
  • Your model contains tables that include multiple partitions.
  • You have a table that contains at least two calculated columns.
  • At least one of those calculated columns is numeric. This includes the data types decimal number, currency, or whole number.
  • You start a processing transaction that includes the ProcessRecalc phase, such as ProcessFull, ProcessDefault, or ProcessRecalc.

In this scenario the SSAS instance crashes during the ProcessRecalc phase of the processing transaction.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 1 for SQL Server 2017

       Cumulative Update 4 for SQL Server 2016 SP1

       Cumulative Update 4 for SQL Server 2016

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 that Microsoft uses to describe software updates.