Apr 25, 2017 - Microsoft released CU5 for SQL Server 2014 SP2
On Apr 25, 2017 Microsoft released Cumulative Update package 5 (CU5) for SQL Server 2014 SP2.
This update contains hotfixes for issues that were fixed after the release of SQL Server 2014 SP2. This build number of this cumulative update package is 12.0.5546.0. SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
List of fixes related to SQL Server Analysis Services / Power Pivot 2014 SP2:
|
Release |
SQL Bug Number |
KB Article Number |
Description |
| CU5 | 9479441 | 4013585 | FIX: SQL Server 2014 Analysis Service proactive caching processes a partition but does not run an SQL query which causes stale data |
| CU5 | 9731371 | 4017063 | FIX: Runaway MDX query that uses Value() function in SSAS 2014 can rapidly and completely consume all the server memory and cause the server to hang |
| CU4 | 9367851 | 3206912 | FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks |
| CU4 | 9237360 | 3208179 | FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server 2014 Analysis Services |
| CU4 | 9367860 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU4 | 8981327 | 4009839 | FIX: An MDX query returns incorrect results in SSAS 2014 Tabular mode |
| CU3 | 8850766 | 3183686 | FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS 2012 or 2014 |
| CU3 | 8850836 | 3198826 | FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services |
| CU3 | 8898351 | 3208179 | FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server 2014 Analysis Services |
| CU3 | 8850785 | 3188670 | FIX: Error when you select a KPI in a Power View report that consumes a BISM connection in a PowerPivot Gallery |
| CU3 | 8850833 | 3198827 | FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members |
| CU2 | 8198037 | 3181260 | SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014 |
| CU2 | 8198023 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU2 | 8198033 | 3180263 | FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 Analysis Services |
| CU1 | 7990673 | 3178541 | PivotTable connects to incorrect data source in SQL Server 2012 or 2014 PowerPivot for SharePoint |
| CU1 | 7990684 | 3150432 | Performance of Analysis Services in Multidimensional mode degrades over time |
| CU1 | 7990668 | 3171516 | Update to add a security warning message when you schedule data refresh for PowerPivot workbooks |
| CU1 | 7520685 | 3151526 | FIX: Incremental deployment of an Analysis Services project to SQL Server 2014 Service Pack 1 causes unexpected shutdown |
| CU1 | 7694336 | 3160874 | FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition |
Tags: news