Cumulative Update 3 for SQL Server 2014 Service Pack 1

This article describes cumulative update package 3 (Build number: 12.0.4427.24) for Microsoft SQL Server 2014 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2014 SP1.

How to get 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
56189763092704Improvements for Distribution Agent telemetry for Azure subscribers are available in SQL Server 2014 SQL service
56667443094865FIX: "The process could not initialize ''" error occurs when you use merge publication in SQL Server 2014 SQL service
57045123096617FIX: Can’t backup in-memory OLTP database that is restored by using full and differential restore in SQL Server 2014 In-Memory OLTP
55756493097073FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool SQL service
55443133097970FIX: Sp_describe_undeclared_parameters returns incorrect result when undeclared parameter targets a decimal column SQL service
51819223068359FIX: "Cannot find the OLAP cube Model" error when you update the pivot table in a SharePoint document in SQL Server 2012 or SQL Server 2014 Analysis Services
51819413066299FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
57150803087114FIX: PowerPivot for SharePoint doesn't run automatic data refresh on the first day of each month Analysis Services
57150823088307FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014 High Availability
57150873077273FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014 SQL service
57150903080209FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014 SQL performance
57151123080856FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014 Analysis Services
57151233089687FIX: Can't export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014 Reporting Services
57151313087872FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014 SQL service
57151933097114FIX: Queries take longer time to compile in SQL Server 2014 than in earlier versions SQL performance
47452983035737FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time Analysis Services
54897043099487FIX: 100% CPU usage occurs when in-memory OLTP database is in recovery state in SQL Server 2014 In-Memory OLTP
56875183095958FIX: Metadata inconsistency error occurs after you switch table partitions and drop corresponding files and filegroups SQL service
58089233099323FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014 SQL service
56670703096400FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014 High Availability
51819493075669FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions Analysis Services
51819613073530FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 or SQL Server 2014 Analysis Services
51819663073907FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding Analysis Services
57150733095156FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014 High Availability
57151003081580FIX: "String or binary data would be truncated" error when you use peer-to-peer replication in SQL Server 2012 or SQL Server 2014 SQL service
57151083087094FIX: It takes longer than expected when you run a query with non-admin user role in SSAS 2012 or SSAS 2014 in Tabular model Analysis Services
57151103088480FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct SQL performance
55220172682488FIX: Backup operation fails in a SQL Server database after you enable change tracking SQL service
55360233090141FIX: Offline checkpoint thread shuts down without providing detailed exception information in SQL Server 2014 In-Memory OLTP
55235823072814FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014 SQL connectivity
55235903080155FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014 SQL service
55235993082860FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014 SQL performance
55236003082005FIX: Case-sensitive does not work in MDS database in SQL Server 2014 MDS
57151023091643FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014 SQL security
58291793100361FIX: DBCC CHECKDB doesn't report metadata inconsistency of invalid filegroups in its summary in SQL Server 2014 SQL service
50382653092702FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012 SQL service
5285700321185This update introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:
SELECT @@VERSION
SELECT SERVERPROPERTY('PRODUCTUPDATELEVEL')
Additionally, this update also adds the CU number information to the first line of the SQL Server error log.
For more information, review Methods 2 through Method 4 under the section How to determine which version and edition of SQL Server Database Engine is running in How to determine the version and edition of SQL Server and its components.



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, and cluster), we recommend that you go and refer to the following articles before you deploy them:
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 SP1.

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 don't have to make any changes to the registry.
Cumulative update package file information
Proprietăți

ID articol: 3094221 - Ultima examinare: 4 nov. 2015 - Revizie: 1

Feedback