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:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates 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.
