Cumulative update package 4 for SQL Server 2014

Applies to: SQL Server 2014 EnterpriseSQL Server 2014 EnterpriseSQL Server 2014 Developer

This article describes cumulative update package 4 (Build number: 12.0.2430.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 does not 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
32606162924996 FIX: Issues when you export a report to PDF that has Unicode fonts in SQL ServerReporting Services
29060812962767 FIX: "Cannot insert duplicate key" error occurs when you update a table by using a bitmap index that contains a partition key in SQL ServerSQL performance
29060842963137 FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012 or SSAS 2014Analysis Services
25782742963138 FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL ServerSQL service
29060932965069 FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 or SQL Server 2014SQL performance
29061032965654 FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computerReporting Services
29061012965922 FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013BI Azure
29060892967103 FIX: Service broker stops working when you unregister and remove a session in SQL ServerSQL service
29061072967594 FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL ServerSQL service
29061172970421 FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored databaseHigh Availability
29061192972411 FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014Reporting Services
29060972972463 FIX: Report cache is not cleaned up when you use SSRS 2012 or SSRS 2014 in SharePoint integrated modeReporting Services
29061242973921 FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS on SharePoint websiteReporting Services
32605862973961 FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL ServerSQL service
26278022974169 FIX: Cannot recover the In-Memory OLTP database after you enable and then disable TDE on it in SQL Server 2014In-Memory OLTP
29061542974948 FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012 or SQL Server 2014Management Tools
29060912975385 FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014Analysis Services
29061262975498 FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file nameReporting Services
32605882975743 FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSASAnalysis Services
29061512976172 FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSASAnalysis Services
29061492976861 FIX: The time is longer and longer to perform process full on an SSAS 2012 or SSAS 2014 tabular model databaseAnalysis Services
29061152976953 FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012 or in SSAS 2014Analysis Services
29061352979304 FIX: Error when you run RBS Maintainer in SQL Server 2012 or SQL Server 2014SQL service
29061532980208 FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL ServerSQL service
29061332980395 FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL ServerSQL performance
32605842982544 FIX: Slow to access "Explorer" or "System Administration" on MDM home pageData Quality Services (DQS)
32606132986627 FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL ServerSQL performance
32605942986722 FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL ServerSQL performance
32606072987809 FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11Reporting Services
32605962987935 FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL ServerSQL service
29427852988166 FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL ServerManagement Tools
29061442989002 FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014Integration Services
32605822989043 FIX: Access denied when you try to view report history on a SharePoint site with the View Items permission Reporting Services
32605782989512 FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular modelAnalysis Services
32606032989590 FIX: Except function does not return the calculated member that is created at the ALL member level in SSASAnalysis Services
32606172989810 FIX: Error in bcp_init when you do bulk copy with local temp table as input parameter in SQL Server Native Client 11.0SQL service
32606002990152 FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL ServerManagement Tools
32606122991526 FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from a URI Integration Services
32606142992414 FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSISIntegration Services
2980091 2993262 FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge joinSQL service
32606182993483 FIX: SSAS processing fails when you perform a Process Full operation on many partitions in a transactionAnalysis Services
32606232993529 FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 or SQL Server 2014 MDS DQS
29657482996629 FIX: "String data, right truncation" error when you do bulk copy on DBCS by using ODBC Driver 11 in SQL Server 2014SQL connectivity
31554592998301 FIX: Error 8654 when you run "INSERT INTO … SELECT" on a table with clustered columnstore index in SQL Server 2014SQL service
29765642999308 Add detailed information to the "Call to Excel Services returned an error" error message in SQL Server 2014 PowerPivotAnalysis Services
30793093003023 FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2014SQL service
32911933003755 FIX: "SQL Server edition is not supported by MDS" error when you use MDS after you apply the CU3 for SQL Server 2014DQS
29766043003760 FIX: Cannot remove the secondary filegroup after you upgrade the database to SQL Server 2014SQL service
30417533003804 FIX: Error when you export data cleansing result with the "Data and Cleansing Info" option in SQL Server 2014 DQSDQS
32905283004195 FIX: "sp_send_dbmail" stored procedure truncates email attachments to 64 KB in SQL Server 2014Management Tools
33954173007873 An update to add an "Open in Management Portal" item to the context menu for SQL Azure database nodes in SSMS 2014Management Tools
33953603007905 An update to the template script for creating SQL Azure database in SSMS 2014Management Tools
34034713008282 An update to add new service tier and performance level to the "Import Data-tier Application..." wizardManagement Tools
30261162993859 FIX: "Unexpected termination" error in SQL Server Agent job that schedules an SSIS 2014 package running every minuteIntegration Services

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:

Cumulative update package information


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.