KB3046038 - Cumulative Update 7 for SQL Server 2014

Applies to: SQL Server 2014 EnterpriseSQL Server 2014 DeveloperSQL Server 2014 Standard

This article describes cumulative update package 7 (Build number: 12.0.2495.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
43266023038332FIX: Data Alerts tables are filled up and never clear old data when you use alerts for SSRS 2012 or SSRS 2014 reports Reporting Services
42107823042544FIX: A query that requires nested loops join takes longer to complete in SQL Server 2014 SQL performance
43265993044958FIX: Rollback recovery on a snapshot fails when you run DBCC CHECKDB and then SQL Server shuts down unexpectedly SQL service
43362623029776FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
43265963020350FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
42213682867316FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service SQL service
43266013034492FIX: "Call to Excel Services returned an error" error when you refresh the document in the PowerPivot Gallery Analysis Services
43362673033041FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source Integration Services
43265973032476FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012 or 2014 SQL service
41987873042683FIX: Data Tools error occurs when you upgrade a DTS package in SQL Server 2014 Integration Services
43265953036601FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS Master Data Services (MDS)
40931973036330FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools
43265983038331FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS Reporting Services
43266053038267FIX: Error "[BC30494] line is too long" occurs when you upload an SSRS report to Reporting Services Report Manager Reporting Services
43362643037624FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014 SQL performance
41666313046893FIX: Inconsistent data when you add a date before March 1, 1900 in the MDS add-in for Excel in SQL Server 2014 MDS
44440983053040FIX: Hidden MDS data entries are deleted unexpectedly when you use the Master Data Services Add-in for Microsoft Excel in SQL Server 2014 MDS
40673033023620FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013 Analysis Services
40672933020750FIX: Error or blank page when you click the workbook link under "Data Refresh - Recent Activity" Analysis Services
40672863025968FIX: SSRS pages contain unlabeled check boxes in the detailed view Reporting Services
40672583023629FIX: High CPU usage after you use DTExec utility to process SSAS data mining models Analysis Services
42025133044160FIX: Performance counters under "ReportServer:Service" object show zero in SSRS 2014 Reporting Services
42656523042370An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014 SQL service
43266003042135FIX: Access violation and "No exceptions should be raised by this code" error occur when you use SQL Server 2012 or SQL Server 2014 SQL service
43266063042077FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014 Analysis Services
43266143041859FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application SQL connectivity
43266113041056FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2 Reporting Services
43266093040675FIX: Data-driven subscription with email notification shows "0 errors" when email delivery fails in SSRS 2012 or SQL Server 2014 Reporting Services
43266073039035FIX: "Parameter type cannot be deduced" when you execute sp_describe_undeclared_parameters in SQL Server 2012 or SQL Server 2014 SQL service
43266083040804FIX: "Access Denied" error occurs when you run an XML validation task in SSIS 2012 or SSIS 2012 Integration Services
43455943053664FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014 SQL service
42199293041476FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 SQL service
42532353045410FIX: A query that uses the DECRYPTBYKEY function takes longer to be completed in SQL Server 2014 SQL security
40569443048752FIX: A SELECT query run as a parallel batch-mode scan may cause a deadlock situation in SQL Server 2014 SQL service
42033883041967FIX: "Unable to retrieve data for this section of the report" error when you request the Service Broker Statistics report in SQL Server 2014 Management Tools
42332703026954FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 Integration Services
40987603055799FIX: "Cannot bulk load" error when you run a query that contains INSERT statements when trace flags 4199 and 610 are enabled on a server that is running SQL Server 2014 SQL performance
43027393052404FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 SQL connectivity
42494513052244FIX: Incorrect result when the "must be unique" action is evaluated for an attribute by using SQL Server 2014 Master Data Services MDS
42086963051798FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
43069653051663FIX: "8156: A database error has occurred" when you run a business rule in SQL Server 2014 Master Data Services MDS
43296493048856FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014 SQL service
40673063027232FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013 Analysis 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.