You are currently offline, waiting for your internet to reconnect

Cumulative Update 10 for SQL Server 2012 SP1

This article describes cumulative update package 10 (Build number: 11.0.3431.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 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
23061642881285You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014Integration Services
20026942928300FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server 2012SQL performance
20520212932559FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012Analysis Services
23571562933103FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server 2008 R2 or SQL Server 2012SQL performance
23571582936154FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server 2008 R2 or SQL Server 2012Management Tools
23562422936328FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012SQL service
21165312938192FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012Integration Services
23571542938476FIX: Errors when you use export/import data wizard to move data after apply CU2 for SQL Server 2008 R2 SP2 or in SQL Server 2012Integration Services
21242092939277FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server 2012 SQL performance
2129886 2950189FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server 2008 R2 or SQL Server 2012SQL service
21861302950209FIX: Access violation when the start offset is larger than the string length in function Substring in SQL Server 2012SQL service
21970342952101FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server 2012SQL performance
23562482953354FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server 2008 R2 or SQL Server 2012SQL service
21155122954480FIX: SSAS instance crashes when you perform writeback action by using the role with cell security definedAnalysis Services
22320582954861FIX: "Query Timeout Expired" when you preview a command of an SSIS package in SSDT 2012Integration Services
23069692956619FIX: The execution of an SSIS 2012 package that is stored in MSDB is slower than it is stored on the file systemIntegration Services
22817732957768FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012Reporting Services
21253292957957FIX: Attributes sort incorrectly after using the Attribute Properties function in SQL Server 2012 MDS Add-in for ExcelData Quality Services (DQS)
22838572958012FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012SQL service
22796222958062FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012SQL service
23030942959342FIX: Data-driven subscription can't be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012Reporting Services
21498122960237FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server 2012DQS
23112002960310FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server 2012SQL service
24206982960735FIX: Windows Update for SQL Server 2012 image does not work in Microsoft Azure Virtual Machine gallery Setup & Install
23047842960989FIX: Error when you use DQS Cleansing Component with large batch in an SSIS 2012 packageDQS
22851412961254FIX: The execution of an MDX query in SSAS 2012 is much slower than it is SSAS 2008 R2Analysis Services
23062182961525FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms applicationReporting Services
23251972961559Incorrect folder when deploying PowerPivot solutions through CAAnalysis Services
23615302962650FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012Analysis Services
20601582963138FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012SQL service
23579792963372FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 Analysis Services
22628792963373FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 2012Analysis Services
22628372963377FIX: An exception and access violation occur when you run an MDX calculation in SSAS 2012Analysis Services
22889552963836FIX: "Parameter missing value" error when you use a drillthrough report in SharePoint in SSRS 2012Reporting Services
20242322967634FIX: SSIS 2012 XML validator only outputs "TRUE" or "FALSE" when you perform XML validationIntegration Services
22901412967635FIX: Incorrect DBA reference of business rules after you upgrade SQL Server 2008 R2 MDS to SQL Server 2012 MDSDQS
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 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

  • SQL Server hotfixes are now multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.
  • The "Hotfix Download Available" form displays the languages for which the update package is available. If you do not see your language, that's because a cumulative update package is not available for that language.

Components updated

One cumulative update package includes all the component packages. However, the cumulative update package updates only those components that are installed on the system.

Support for this update

If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and to issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

To do this, follow these steps:
  1. In Control Panel, click Add or Remove Programs.

    Note If you are running Windows 7 or a later version, click Programs and Features in Control Panel.
  2. Locate the entry that corresponds to this cumulative update package.
  3. Right-click the entry, and then click Uninstall.
Cumulative update package information

Prerequisites

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.

Cumulative update package file information

This cumulative update package may not contain all the files that you must have to fully update a product to the latest build. This package contains only the files that you must have to correct the issues that are listed in this article.

The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.ERROR: PhantomJS timeout occurred