Mar 20, 2018 - Microsoft released CU8 for SQL Server 2016 SP1
On Mar 20, 2018 Microsoft released Cumulative Update package 8 (CU8) fro Service Pack 1 (SP1) for SQL Server 2016
This update contains hotfixes for issues that were fixed after the release of SQL Server 2016 Service Pack 1. This build number of this cumulative update package is 13.0.4474.0.
List of fixes related to SQL Server Analysis Services / PowerPivot 2016 (since SP1):
| CU# | VSTS bug number | KB article number | Description |
| CU8 | 11190572 | 4074696 | FIX: Drillthrough operation fails and returns an error for row-level non-administrators in SSAS 2016 (Tabular model) |
| CU8 | 11455726 | 4074862 | FIX: Unexpected error when you create a subcube in SQL Server 2016 Analysis Services (Multidimensional model) |
| CU8 | 11396933 | 2932559 | FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS |
| CU8 | 11455724 | 4082865 | FIX: SSAS crashes when a query is executed on a large partitioned table in SQL Server 2016 |
| CU8 | 11456360 | 4083949 | FIX: SSAS may crash when you execute a DAX query by using a non-admin Windows user in SQL Server 2016 |
| CU8 | 11511973 | 4057307 | FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 |
| CU8 | 11509590 | 4086136 | FIX: SSAS stops responding when you execute an MDX query in SQL Server 2016 Analysis Services (Multidimensional model) |
| CU8 | 11529110 | 4089623 | FIX: Out of memory occurs and query fails when you run MDX query with NON EMPTY option in SSAS 2016 and SSAS 2014 |
| CU8 | 11456072 | 4090032 | FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2016 multidimensional mode |
| CU8 | 11447600 | 4038881 | FIX: Unexpected exception occurs when you process dimensions by using Process Update in SSAS 2016 |
| CU7 | 11091931 | 4055674 | FIX: Missing logs for Analysis Services Processing tasks in SQL Server 2016 Integration Services |
| CU7 | 11296783 | 4057307 | FIX: Multidimensional mode randomly crashes and an access violation occurs in SSAS 2016 or in SSAS 2014 |
| CU7 | 11295738 | 4057759 | FIX: Internal error when you drill down hierarchy members in SSAS 2016 in multidimensional mode |
| CU6 | 10868753 | 4033789 | FIX: A memory leak may occur when you perform Process Update operations in SSAS |
| CU6 | 10868738 | 4039509 | FIX: SSAS crashes when you process an SSAS database or cube in SQL Server |
| CU6 | 10864945 | 3010148 | FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS |
| CU6 | 10965956 | 4034789 | FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 or 2017 |
| CU6 | 10864854 | 4052572 | FIX: SSAS 2016 crashes intermittently when you rename multi-dimensional database using script |
| CU6 | 10868776 | 3208545 | FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation |
| CU5 | 10665155 | 4033789 | FIX: A memory leak may occur when you perform Process Update operations in SSAS 2014 or 2016 |
| CU5 | 10365499 | 4040085 | FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 |
| CU5 | 10682272 | 4022753 | FIX: SSAS 2014 or 2016 crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy |
| CU4 | 10052301 | 4021994 | FIX: SSAS crashes when a measure is added that refers to null values in Power BI |
| CU4 | 10049124 | 4013585 | FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data |
| CU4 | 10195260 | 3212541 | FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase |
| CU4 | 10162127 | 4024548 | FIX: It takes a long time to perform Process Update operations on SSAS databases in SQL Server 2016 |
| CU4 | 9876036 | 4018908 | FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) |
| CU4 | 10017583 | 4022594 | FIX: MDX query returns incorrect results if the table has a table attribute cross-join with the same attribute in a table hierarchy in SSAS 2016 |
| CU4 | 10106167 | 4024023 | FIX: SSAS crashes when you access .vmp files in SQL Server 2016 |
| CU4 | 10049128 | 4019603 | FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 |
| CU4 | 10331381 | 4032543 | FIX: SSAS crashes when you run a DAX or MDX query in SSAS 2016 in Tabular mode |
| CU4 | 10296144 | 4025402 | FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2016 |
| CU3 | 9730123 | 4016805 | FIX: The SQL Server Analysis Service encounters an internal error when it processes a Tabular model |
| CU3 | 9646715 | 4018741 | FIX: MDX query returns an error in SQL Server Analysis Service if the dimension table contains members that do not exist in the fact table |
| CU3 | 9690463 | 4019988 | FIX: SSAS 2016 crashes with an access violation when many partitions and their aggregations/indexes are processed together concurrently |
| CU3 | 9367899 | 3198827 | FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members |
| CU3 | 9813872 | 4013208 | FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model |
| CU3 | 9782406 | 4018955 | FIX: Error when you process a calculated column on a database with compatibility level 1200 in SSAS 2016 tabular mode |
| CU3 | 9782644 | 4019511 | FIX: SSAS fails to start if the MemoryHeapType and HeapTypeForObjects properties are set to -1 |
| CU3 | 9875165 | 4019048 | FIX: SSAS crashes when you retrieve KPIs as hidden members by using schema rowsets in SQL Server |
| CU2 | 9503252 | 4009839 | FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode |
| CU2 | 9287975 | 4014013 | FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 |
| CU2 | 9237364 | 3208179 | FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services |
| CU2 | 9367901 | 3198826 | FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services |
| CU2 | 9456824 | 4013122 | Improvement: Performance improvement for the "sequence point algorithm" step in an SSAS 2016 Tabular Model transaction |
| CU2 | 9367862 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU2 | 9367872 | 3198356 | FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services |
| CU2 | 9367911 | 3211605 | FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode |
| CU2 | 9367868 | 3212916 | FIX: SSAS may crash on query execution if a predefined role is specified in the connection string |
| CU2 | 9367925 | 3209520 | FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly |
| CU2 | 9467732 | 4013206 | FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance |
| CU1 | 8198025 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU1 | 9100068 | 3211605 | FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode |
| CU1 | 9097248 | 3198827 | FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members |
| CU1 | 9099937 | 3208178 | FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services |
| CU1 | 9100139 | 3212541 | FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase |
| CU1 | 9100261 | 3198356 | FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services |
| CU1 | 9097256 | 3198826 | FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services |
| CU1 | 8986617 | 3209520 | FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly |
| CU1 | 8808992 | 3209426 | FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state |
| CU1 | 9098036 | 3206912 | FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks |
| CU1 | 9078847 | 3213709 | FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services |
| CU1 | 9098040 | 3212916 | FIX: SSAS may crash on query execution if a predefined role is specified in the connection string |
| CU1 | 9097254 | 3183686 | FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS |
Tags: news