Cumulative Update 4 for SQL Server 2012 SP2

If you plan to deploy this cumulative update on an AlwaysOn configuration, you must read the following Knowledge Base article before you do this:

Summary

This article describes cumulative update package 4 (Build number: 11.0.5569.0) for Microsoft SQL Server 2012 Service Pack 2 (SP2). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP2.

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
37206222793580FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server Management Tools
37206402840657FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 Master Data Services (MDS)
36550672970136FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012 SQL service
37206312994082FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS MDS
37206362995352FIX: "No catalog entry found for partition ID in database " error when you use SQL Server 2012 SQL service
37439722995622FIX: "Specified cast is not valid" when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration Services
37206442997020FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012 Reporting Services
37206342998870FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014 Analysis Services
37206503000494The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode Reporting Services
37206463005300FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014 SQL service
33607063006838FIX: Instance of SSAS 2012 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services
37206483008000FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014 Integration Services
34564113010148FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS 2012 Analysis Services
35081463011465FIX: Sequence object generates duplicate sequence values when SQL Server 2012 is under memory pressure SQL service
35463963013269FIX: The result is incorrect when you run MDX query with unary operators in SSAS 2012 Analysis Services
37206603013551FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update SQL service
37490343013553FIX: 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
36605213016384FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 Analysis Services
39200643016518Excel Services workbook fails to refresh using a .bism file SQL service
37213383018713FIX: "Internal error: An unexpected error occurred" when you run MDX query in SSAS 2012 Analysis Services
37264283019110FIX: "Duplicate names are not allowed" error when you add multiple filters to the Power View report in SharePoint 2013 SQL service
37273803020750FIX: Error or blank page when you click the workbook link under "Data Refresh - Recent Activity" Analysis Services
37958033021757FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function SQL service
38575143023620FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013 Analysis Services
35416483023634FIX: "Error converting data type nvarchar to numeric" error when you use a business rule in SQL Server 2012 MDS MDS
38219193024790FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version Setup & Install
38796663025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 Analysis Services
36755913025968FIX: SSRS 2012 pages contain unlabeled check boxes in the detailed view Reporting Services
39371013027214FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 Management Tools
38915623027232FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server 2012 PowerPivot for SharePoint 2013 Analysis Services
39384943027425FIX: Metadata cannot be removed at publisher and synchronization time increases when you use merge replication SQL service
39168913027860Error 17066 or 17310 during SQL Server startup SQL service
39708663028216FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 Analysis Services
38334973028226FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 Reporting Services
37493763029126FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 multidimensional cube Analysis Services
39390153029825FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 SQL performance

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 2012 update release.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2012 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 2012 SP2.

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
Egenskaper

Artikel-id: 3007556 – senaste granskning 23 jan. 2015 – revision: 1

Feedback