Report Portal

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

 

2007-2015 VidasSoft Systems Inc.