Jan 24, 2019 - Microsoft released CU5 for SQL Server 2016 SP2
On Jan 24, 2019 Microsoft released Cumulative Update package 5 (CU5) for Service Pack 2 (SP2) for SQL Server 2016
This update contains hotfixes for issues that were fixed after the release of SQL Server 2016 Service Pack 2. This build number of this cumulative update package is 13.0.5264.0.
List of fixes related to SQL Server Analysis Services / PowerPivot 2016 (since SP2):
| CU# | VSTS bug number | KB article number | Description |
| CU5 | 12491219 | 4055674 | FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 and 2017 Integration Services |
| CU5 | 12488511 | 4090032 | FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode |
| CU5 | 12488523 | 4463328 | FIX: “An unexpected exception occurred” when you run an MDX query after an XMLA query to process a dimension in SSAS |
| CU5 | 12559856 | 4465247 | FIX: Deadlock occurs in SSAS 2016 and 2017 when you run a DAX query with time intelligence calculation in parallel |
| CU5 | 12501413 | 4480795 | FIX: An unexpected error occurs when you run an MDX query against an Excel pivot table in SSAS 2016 |
| CU5 | 12599226 | 4486935 | FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019) |
| CU4 | 12458031 | 4459981 | FIX: Access violation occurs and SSAS crashes when you process an SSAS database in SQL Server 2014 |
| CU4 | 12253702 | 4465249 | FIX: “ORA-01036: illegal variable name/number” when you query an Oracle database in SSAS 2016 |
| CU4 | 12408293 | 4465476 | FIX: Errors when changing filters in Excel or PBI reports after model is updated in SSAS |
| CU4 | 12427355 | 4466831 | FIX: “A connection cannot be made” error when SSIS package uses a parameterized connection manager in SQL Server 2016 |
| CU4 | 12399709 | 4468868 | FIX: Server may freeze when you send create session to call custom assembly in SSAS 2016 |
| CU4 | 12449923 | 4468869 | FIX: Relationships not working correctly on synchronized tabular database |
| CU3 | 12180194 | 4338204 | FIX: Circular dependency between column names for a calculated table that summarizes the partition query dataset in SQL Server |
| CU3 | 12250510 | 4456775 | FIX: Can't retrieve ConnectionID and SPID when running an SSAS Profiler trace in SQL Server |
| CU3 | 12245665 | 4340746 | FIX: No records are returned when you run an MDX query after restarting SSAS 2016 and 2017 |
| CU3 | 12302690 | 4458316 | FIX: "Internal error: An unexpected error occurred" when you run a MDX query that was generated by Excel in SSAS 2016 |
| CU3 | 12245673 | 4294660 | FIX: SSAS stops responding when you run MDX queries and DirectQuery mode is enabled in SQL Server |
| CU2 | 12089083 | 4337554 | FIX: SSAS service crashes when you use the "Connect live" option in Power BI desktop |
| CU2 | 12054640 | 4134601 | FIX: "Could not load file or assembly "Microsoft.AnalysisServices.AdomdClientUI" error when a “Process Full" operation is run in SQL Server |
| CU1 | 11983395 | 4086173 | FIX: Access violation occurs when executing a DAX query on a tabular model in SQL Server Analysis Services |
| CU1 | 11983376 | 3028216 | FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS |
| CU1 | 11983360 | 4094858 | FIX: "An unexpected error occurred" when you use DAX measures in Power BI table visualizations in SQL Server |
| CU1 | 11983373 | 4162814 | FIX: An internal exception access violation occurs and the SSAS server stops responding |
| CU1 | 11983369 | 4134175 | FIX: Processing a cube with many partitions generates lots of concurrent data source connections in SSAS |
| CU1 | 11983359 | 4132267 | FIX: Deploying a SSAS project in SSDT is frequently unsuccessful in SQL Server Analysis Services in Tabular mode |
2019-03-25: CU6 released, but there are no fixes related to Analysis Services.
Tags: news