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.
|VSTS bug number||KB article number||Description||Fix area|
|3260616||2924996||FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server||Reporting Services|
|2906081||2962767||FIX: "Cannot insert duplicate key" error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server||SQL performance|
|2906084||2963137||FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012 or SSAS 2014||Analysis Services|
|2578274||2963138||FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server||SQL service|
|2906093||2965069||FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 or SQL Server 2014||SQL performance|
|2906103||2965654||FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer||Reporting Services|
|2906101||2965922||FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013||BI Azure|
|2906089||2967103||FIX: Service broker stops working when you unregister and remove a session in SQL Server||SQL service|
|2906107||2967594||FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server||SQL service|
|2906117||2970421||FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database||High Availability|
|2906119||2972411||FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014||Reporting Services|
|2906097||2972463||FIX: Report cache is not cleaned up when you use SSRS 2012 or SSRS 2014 in SharePoint integrated mode||Reporting Services|
|2906124||2973921||FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS on SharePoint website||Reporting Services|
|3260586||2973961||FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server||SQL service|
|2627802||2974169||FIX: Cannot recover the In-Memory OLTP database after you enable and then disable TDE on it in SQL Server 2014||In-Memory OLTP|
|2906154||2974948||FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012 or SQL Server 2014||Management Tools|
|2906091||2975385||FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014||Analysis Services|
|2906126||2975498||FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file name||Reporting Services|
|3260588||2975743||FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS||Analysis Services|
|2906151||2976172||FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS||Analysis Services|
|2906149||2976861||FIX: The time is longer and longer to perform process full on an SSAS 2012 or SSAS 2014 tabular model database||Analysis Services|
|2906115||2976953||FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012 or in SSAS 2014||Analysis Services|
|2906135||2979304||FIX: Error when you run RBS Maintainer in SQL Server 2012 or SQL Server 2014||SQL service|
|2906153||2980208||FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server||SQL service|
|2906133||2980395||FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server||SQL performance|
|3260584||2982544||FIX: Slow to access "Explorer" or "System Administration" on MDM home page||Data Quality Services (DQS)|
|3260613||2986627||FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server||SQL performance|
|3260594||2986722||FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server||SQL performance|
|3260607||2987809||FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11||Reporting Services|
|3260596||2987935||FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server||SQL service|
|2942785||2988166||FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server||Management Tools|
|2906144||2989002||FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014||Integration Services|
|3260582||2989043||FIX: Access denied when you try to view report history on a SharePoint site with the View Items permission||Reporting Services|
|3260578||2989512||FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model||Analysis Services|
|3260603||2989590||FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS||Analysis Services|
|3260617||2989810||FIX: Error in bcp_init when you do bulk copy with local temp table as input parameter in SQL Server Native Client 11.0||SQL service|
|3260600||2990152||FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server||Management Tools|
|3260612||2991526||FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from a URI||Integration Services|
|3260614||2992414||FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS||Integration 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 join||SQL service|
|3260618||2993483||FIX: SSAS processing fails when you perform a Process Full operation on many partitions in a transaction||Analysis Services|
|3260623||2993529||FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 or SQL Server 2014 MDS||DQS|
|2965748||2996629||FIX: "String data, right truncation" error when you do bulk copy on DBCS by using ODBC Driver 11 in SQL Server 2014||SQL connectivity|
|3155459||2998301||FIX: Error 8654 when you run "INSERT INTO … SELECT" on a table with clustered columnstore index in SQL Server 2014||SQL service|
|2976564||2999308||Add detailed information to the "Call to Excel Services returned an error" error message in SQL Server 2014 PowerPivot||Analysis Services|
|3079309||3003023||FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2014||SQL service|
|3291193||3003755||FIX: "SQL Server edition is not supported by MDS" error when you use MDS after you apply the CU3 for SQL Server 2014||DQS|
|2976604||3003760||FIX: Cannot remove the secondary filegroup after you upgrade the database to SQL Server 2014||SQL service|
|3041753||3003804||FIX: Error when you export data cleansing result with the "Data and Cleansing Info" option in SQL Server 2014 DQS||DQS|
|3290528||3004195||FIX: "sp_send_dbmail" stored procedure truncates email attachments to 64 KB in SQL Server 2014||Management Tools|
|3395417||3007873||An update to add an "Open in Management Portal" item to the context menu for SQL Azure database nodes in SSMS 2014||Management Tools|
|3395360||3007905||An update to the template script for creating SQL Azure database in SSMS 2014||Management Tools|
|3403471||3008282||An update to add new service tier and performance level to the "Import Data-tier Application..." wizard||Management Tools|
|3026116||2993859||FIX: "Unexpected termination" error in SQL Server Agent job that schedules an SSIS 2014 package running every minute||Integration Services|
Notes for this 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:
- SQL Server failover cluster rolling update and service pack process.
If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP:
- Install the service pack on the passive node.
- Install the service pack on the active node (This step requests servicerestart).
- Upgrade and update of availability group servers that use minimal downtime and data loss.
If you enabled AlwaysOn with SSISDB catalog for additional considerations about how to apply a CU or SP in these environments, go and see the article from the following MSDN blog:
- How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
- How to apply a hotfix for SQL Server in a replication topology
- How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
- Overview of SQL Server Servicing Installation
Cumulative update package information
PrerequisitesTo apply this cumulative update package, you must be running SQL Server 2014.
Restart informationYou may have to restart the computer after you apply this cumulative update package.
Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.
- How to obtain the latest service pack for SQL Server 2014.
- The Incremental Servicing Model for SQL Server to deliver hotfixes for reported problems.
- Naming schema for Microsoft SQL Server software update packages.
- Description of the standard terminology that is used to describe Microsoft software updates.