KB2931078 - Cumulative update package 9 for SQL Server 2012 Service Pack 1

Applies to: SQL Server 2012 Analysis ServicesSQL Server 2012 DeveloperSQL Server 2012 Enterprise

This article describes cumulative update package 9 (Build number: 11.0.3412.0) for Microsoft SQL Server 2012 Service Pack 1 (SP1). This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 SP1.

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.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
20272752723979 FIX: Access violation in SQL Server internal deadlock monitor when you run multiple applications together with Multiple Active Result Sets enabled in SQL Server 2008 R2 or in SQL Server 2012SQL service
20415702861456 FIX: Access violation in replication Distribution Agent in SQL Server 2008 R2 or SQL Server 2012 Transactional ReplicationSQL service
18521082913206 FIX: Cannot pass report parameters to reports in a SharePoint Document Library in SSRS 2008 R2 or SSRS 2012 by using HTML formsReporting Services
20768682920987 FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2 or SQL Server 2012SQL service
19933142921630 FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2 or SSAS 2012Analysis Services
20768642922799 FIX: Unexpected exception is thrown when you convert writeback partition in SSAS 2008 R2 or SSAS 2012Analysis Services
19208862922935 FIX: Excel rendering extension produces corrupted files when you use nonprintable codes in SSRS 2012Reporting Services
19933112923837 FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012SQL service
19412162924827 FIX: dtexec.exe cannot execute a package when one of the configuration files does not exist in SQL Server 2012Integration Services
19668282926089 FIX: Error when you create new report subscriptions after you apply CU7 or CU8 for SQL Server 2012 SP1SQL security
20210362926217 FIX: Performance problems occur when database lock activity increases in SQL Server 2012 SQL service
20210372926223 FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012SQL service
19722452926699 FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1 SQL service
20210382926712 FIX: Performance decreases after an ALTER INDEX…ONLINE operation is aborted in SQL Server 2012SQL service
19946332927511 FIX: Access violation may occur when trigger query joins large dataset in deleted/inserted table and runs in parallel in SQL server 2012SQL performance
19946872927524 FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012 Analysis Services
20210392927748 FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7Analysis Services
19995082927779 FIX: Database shows "recovery pending" state when you use TDE with EKM provider in SQL Server 2012SQL security
19996832927844 FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012Analysis Services
19680312929193 FIX: SQL Server 2012 instance shuts down when you join database as secondary replica during AlwaysOn Availability Groups configurationHigh Availability
19295672929832 FIX: Decimal precision is incorrect when you calculate based on size of scale in SQL Server 2012 MDSData Quality Services (DQS)
19245852929903 FIX: Merge agent fails when you apply snapshot in SQL Server 2012 instance if cross database dependencies are presentSQL service
20246252931001 FIX: Distribution Agent skips applying sp_MSins_, sp_MSupd_, sp_MSdel_ stored procedures on a Subscriber that is initialized with Backup in SQL Server 2012SQL service
20325712931241 FIX: Access violation occurs when you update a table that has an XML calculated column in SQL Server 2012SQL service
20476872932120 FIX: SQL Server takes long time to open the databases after the recovery phase when the number of databases or database files or both is large in SQL Server 2012SQL service
20351002932340 FIX: Errors when you add member in SQL Server 2012 MDSDQS
20430072932341 FIX: Content of member details window is locked when you add a new member to MDS Explorer in SQL Server 2012 MDSDQS
19098622933780 FIX: Message is not removed from transmission queue even though the ACK is received successfully in an AlwaysOn availability group in SQL Server 2012SQL service
20229612934934 FIX: Non-yielding scheduler tries to close the listener for availability group in SQL Server 2012High Availability
20825162935681 FIX: Bing Map functionality does not work in Power View or SSRS 2012Reporting Services

Notes for this update

Installation and deployment

  • 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 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:

Cumulative update package information


To apply this cumulative update package, you must be running SQL Server 2012 SP1.

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.