KB3007556 - Cumulative Update 4 for SQL Server 2012 SP2

Applies To
SQL Server 2012 Enterprise SQL Server 2012 Developer SQL Server 2012 Standard SQL Server 2012 Web SQL Server 2012 Express SQL Server 2012 Analysis Services SQL Server 2012 Business Intelligence

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

AlwaysOn availability groups reported as NOT SYNCHRONIZING after you apply SQL Server 2014 CU5, SQL Server 2012 SP2 CU4, or SQL Server 2012 SP2 CU3

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 number KB article number Description Fix area
3720622 2793580 FIX: 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
3720640 2840657 FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 Master Data Services (MDS)
3655067 2970136 FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012 SQL service
3720631 2994082 FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS MDS
3720636 2995352 FIX: "No catalog entry found for partition ID SQL service
3743972 2995622 FIX: "Specified cast is not valid" when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration Services
3720644 2997020 FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012 Reporting Services
3720634 2998870 FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014 Analysis Services
3720650 3000494 The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode Reporting Services
3720646 3005300 FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014 SQL service
3360706 3006838 FIX: Instance of SSAS 2012 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services
3720648 3008000 FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014 Integration Services
3456411 3010148 FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS 2012 Analysis Services
3508146 3011465 FIX: Sequence object generates duplicate sequence values when SQL Server 2012 is under memory pressure SQL service
3546396 3013269 FIX: The result is incorrect when you run MDX query with unary operators in SSAS 2012 Analysis Services
3720660 3013551 FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update SQL service
3749034 3013553 FIX: 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
3660521 3016384 FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 Analysis Services
3920064 3016518 Excel Services workbook fails to refresh using a .bism file SQL service
3721338 3018713 FIX: "Internal error: An unexpected error occurred" when you run MDX query in SSAS 2012 Analysis Services
3726428 3019110 FIX: "Duplicate names are not allowed" error when you add multiple filters to the Power View report in SharePoint 2013 SQL service
3727380 3020750 FIX: Error or blank page when you click the workbook link under "Data Refresh - Recent Activity" Analysis Services
3795803 3021757 FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function SQL service
3857514 3023620 FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013 Analysis Services
3541648 3023634 FIX: "Error converting data type nvarchar to numeric" error when you use a business rule in SQL Server 2012 MDS MDS
3821919 3024790 FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version Setup & Install
3879666 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 Analysis Services
3675591 3025968 FIX: SSRS 2012 pages contain unlabeled check boxes in the detailed view Reporting Services
3937101 3027214 FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 Management Tools
3891562 3027232 FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server 2012 PowerPivot for SharePoint 2013 Analysis Services
3938494 3027425 FIX: Metadata cannot be removed at publisher and synchronization time increases when you use merge replication SQL service
3916891 3027860 Error 17066 or 17310 during SQL Server startup SQL service
3970866 3028216 FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 Analysis Services
3833497 3028226 FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 Reporting Services
3749376 3029126 FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 multidimensional cube Analysis Services
3939015 3029825 FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 SQL performance