[EN] SQL Server 2012 SP2 Cumulative Update #4 is available!

LOGO__SQLServer2012SP2New Years, new updates. First update for SQL Server Environment has been published week ago. In this Cumulative Update No 4 {build no 11.0.5569.0} for SQL Server 2012 SP2 Microsoft fixed over forty bugs, and full list is below. Interesting fixed errora are especially for SharePoint 2013 area, DBCC CHECKDB and no-english installation.

VSTS BUG: 3720622 | KB: 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

VSTS BUG: 3720640 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
Master Data Services (MDS)

VSTS BUG: 3655067 | KB: 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012
SQL service

VSTS BUG: 3720631 | KB: 2994082
FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS
MDS

VSTS BUG: 3720636 | KB: 2995352
FIX: “No catalog entry found for partition ID <ID> in database <Database Name>” error when you use SQL Server 2012
SQL service

VSTS BUG: 3743972 | KB: 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

VSTS BUG: 3720644 | KB: 2997020
FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012
Reporting Services

VSTS BUG: 3720634 | KB: 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

VSTS BUG: 3720650 | KB: 3000494
FIX: 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

VSTS BUG: 3720646 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 3360706 | KB: 3006838
FIX: Instance of SSAS 2012 crashes when cube writeback commit and processing transactions are executed at the same time
Analysis Services

VSTS BUG: 3720648 | KB: 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

VSTS BUG: 3456411 | KB: 3010148
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS 2012
Analysis Services

VSTS BUG: 3508146 | KB: 3011465
FIX: Sequence object generates duplicate sequence values when SQL Server 2012 is under memory pressure
SQL service

VSTS BUG: 3546396 | KB: 3013269
FIX: The result is incorrect when you run MDX query with unary operators in SSAS 2012
Analysis Services

VSTS BUG: 3720660 | KB: 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

VSTS BUG: 3749034 | KB: 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

VSTS BUG: 3660521 | KB: 3016384
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012
Analysis Services

VSTS BUG: 3920064 | KB: 3016518
FIX: Excel Services workbook fails to refresh using a .bism file
SQL service

VSTS BUG: 3721338 | KB: 3018713
FIX: “Internal error: An unexpected error occurred” when you run MDX query in SSAS 2012
Analysis Services

VSTS BUG: 3726428 | KB: 3019110
FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013
SQL service

VSTS BUG: 3727380| KB: 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity”
Analysis Services

VSTS BUG: 3795803 | KB: 3021757
FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function
SQL service

VSTS BUG: 3857514 | KB: 3023620
FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 3541648 | KB: 3023634
FIX: “Error converting data type nvarchar to numeric” error when you use a business rule in SQL Server 2012 MDS
MDS

VSTS BUG: 3821919 | KB: 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
Setup & Install

VSTS BUG: 3879666 | KB: 3025408
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012
Analysis Services

VSTS BUG: 3675591 | KB: 3025968
FIX: SSRS 2012 pages contain unlabeled check boxes in the detailed view
Reporting Services

VSTS BUG: 3937101 | KB: 3027214
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012
Management Tools

VSTS BUG: 3891562 | KB: 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server 2012 PowerPivot for SharePoint 2013
Analysis Services

VSTS BUG: 3938494 | KB: 3027425
FIX: Metadata cannot be removed at publisher and synchronization time increases when you use merge replication
SQL service

VSTS BUG: 3916891 | KB: 3027860
FIX: Error 17066 or 17310 during SQL Server startup
SQL service

VSTS BUG: 3970866 | KB: 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012
Analysis Services

VSTS BUG: 3833497 | KB: 3028226
FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012
Reporting Services

VSTS BUG: 3749376 | KB: 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 multidimensional cube
Analysis Services

VSTS BUG: 3939015 | KB: 3029825
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012
SQL performance

This update could be applied to applies to

  • Microsoft SQL Server 2012 Service Pack 2
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • SQL Server 2012 Reporting Services

    Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 4

    You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

    If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    • SQLServer2012_SP2_CU4_3007556_11_0_5569_x64 (601 MB)
    • SQLServer2012_SP2_CU4_3007556_11_0_5569_x86 (323 MB)

    Enjoy!