FIX: SSAS 2016 processing fails in a Multidimensional dimension that has Proactive Caching feature enabled

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

Symptoms


Consider the following scenarios:
 
  • You have a Multidimensional model in Microsoft SQL Server 2016 Analysis Service (SSAS 2016).
  • You enable Proactive Caching feature of dimension.
  • The dimension is referenced by a cube that has a Relational OLAP (ROLAP) partition. 
When you deploy database or process the cube with partitions, it may fail and minidump file is created repeatedly until SSAS is restarted.

Resolution


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

       Cumulative Update 12 for SQL Server 2016 SP1 

Workaround


To work around this issue, use Hybrid OLAP (HOLAP) mode instead of Relational OLAP (ROLAP) mode in SSAS 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.