FIX: Time-out error when you process multiple partitions in parallel in SQL Server 2016 Analysis Services (Tabular model)

Applies to: SQL Server 2016 StandardSQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


Assume that you use an instance of Microsoft SQL Server 2016 Analysis Services (Tabular model). When you process multiple partitions of a table in parallel, Analysis Services may crash. Additionally, the processing operation may fail with a time-out error.

Cause


This issue occurs because the number of partition processing operations may exceed the MaxActiveConnections setting on the Datasource object.

Note By default, the MaxActiveConnections equals 10.

Resolution


Cumulative update information

The fix for this issue is included in the following cumulative update for SQL Server:

Workaround


To work around this issue, use the following methods:
  • Reduce the parallelism of processing.
  • Increase the maximum active connections to the data source.

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.