Cumulative update package 6 for SQL Server 2014

Summary

This article describes cumulative update package 6 (Build number: 12.0.2480.0) for Microsoft SQL Server 2014. This update contains hotfixes for issues that were fixed after the release of SQL Server 2014.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page doesn't appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
37206412840657FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014 Master Data Services (MDS)
37206322994082FIX: Error when you edit models for some groups or users in MDS for SQL Server 2012 or SQL Server 2014 MDS
37206672995211FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 or 2014 report Reporting Services
40672942995622FIX: "Specified cast is not valid" when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration Services
37206452997020FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012 or 2014 Reporting Services
37206523000494The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode Reporting Services
37206733000562FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file Reporting Services
37206743001713FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012 or SSRS 2014 Reporting Services
37206793003102FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012 or SSRS 2014 Reporting Services
40672783006838FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services
37206923008135FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report SQL service
37206933008416FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 or SSRS 2014 Reporting Services
40672793010148FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Analysis Services
37206913010773FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode SQL service
40672803011465FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 is under memory pressure SQL service
37206613013551FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update SQL service
37206683013553FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014 Integration Services
40672653016165FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server SQL service
40672853016384FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014 Analysis Services
40672893017544FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently Analysis Services
40672913019110FIX: "Duplicate names are not allowed" error when you add multiple filters to the Power View report in SharePoint 2013 SQL service
40673003021757FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function SQL service
3989801 3023634FIX: Conversion error occurs when you use a business rule in SQL Server 2012 or SQL Server 2014 MDS MDS
40673013024790FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version Setup & Install
39864653024815Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014 SQL performance
40673053025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014 Analysis Services
39154023025845FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014 SQL service
40672603026082FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
40672633026083FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
40673103027214FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014 Management Tools
39671053027847FIX: Date conversion error when you use German SQL Server 2014 MDS in a German Windows operating system MDS
39168943027860Error 17066 or 17310 during SQL Server startup SQL service
40673133028216FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014 Analysis Services
40673023028226FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 or SSRS 2014 Reporting Services
40672753028322FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014 Reporting Services
40672963029126FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube Analysis Services
38564393029762FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014 SQL service
40673123029825FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014 SQL performance
40015833029977FIX: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014 SQL service
38853663030041FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014 Setup & Install
39215213030325FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh Analysis Services
38914073030326FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013 Analysis Services
37499613030619FIX: Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014 SQL service
37456453032067FIX: Access denied when a newly added user browses to an MDS website in SQL Server 2014 MDS
38917623032068FIX: No MDSTrace.log file is generated after you enable tracing in the MDS 2014 web.config file MDS
40984623032087FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014 Management Tools
38593993034297FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days Management Tools
40722353034615FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014 SQL service
40457763034679FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING High Availability
40843803035071FIX: Error when you run a query that contains "Use database_name" or "Execute Stored_Procedure_name" command Management Tools
40844133035077FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking Management Tools
40507363035165FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014 SQL service
38949423036328FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014 SQL service
39889423036330FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • We recommend that you apply the most recent update release .
    • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
    • The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2014 update release.
  • We recommend that you upgrade your SQL Server to the next SQL Server 2014 service pack .

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, mirroring, or cluster), we recommend that you see the following articles before you deploy the hotfixes:
Language support
Components updated
Support for this update
How to uninstall this update

Cumulative update package information

Prerequisites

To apply this cumulative update package, you must be running SQL Server 2014.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Cumulative update package file information
Properties

Article ID: 3031047 - Last Review: Feb 16, 2015 - Revision: 1

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, SQL Server 2014 Reporting Services, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence

Feedback