Cumulative update package 7 for SQL Server 2012 SP1

This article describes cumulative update package 7 (Build number: 11.0.3393.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
1282810 2792921Description of new features in SQL Server 2012 and SQL Server 2008 R2 SP2
1615704 2833989FIX: Object ID that is used in memory differs from the object ID on the disk in SQL Server 2012
1268467 2843619Tablix column header sorting buttons are Section 508 noncompliant in a Reporting Services report in SQL Server 2012
1497516 2844210FIX: The Remote Registry service crashes when an application tries to retrieve Performance Counter data from another computer
1357295 2862241FIX: Access violation when you trace an RPC event class by using SQL profiler or XEvents in SQL Server 2012
1497535 2866062FIX: Access violation when you use DTA to analyze a database that contains a partition table in SQL Server 2008 R2 or in SQL Server 2012
1497537 2868348FIX: Chart data cannot be updated when you use the Report Viewer Web Part to view the report in SSRS 2008 R2 or in SSRS 2012
1525444 2878968FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012
1447550 2879373FIX: The threads are not scheduled evenly in SQL Server 2012 Standard Edition
1455690 2881285You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012
1434542 2881661A memory leak occurs when a SQL Server Native Client OLE DB provider application calls the Prepare method in SQL Server 2012
1465290 2883424FIX: Dragged objects shake in an SSIS 2012 project after you apply Cumulative Update 6 for SQL Server 2012
1465483 2883524FIX: "SCN not found" error when you use Connector for Oracle by Attunity and CDC for Oracle by Attunity in SQL Server 2012
1480767 2884953FIX: "Non-yielding Resource Monitor" when you run a workload that executes concurrent queries in SQL Server 2012
1482635 2885671Duplicated worksheets are opened when you use the SQL Server Master Data Services Add-in for Microsoft Excel in SQL Server 2012
1492999 2887115FIX: Function sys.fn_hadr_backup_is_preferred_replica costs almost all the CPU usage in Log Shipping in SQL Server 2012
1581425 2887888FIX: Slow performance in SQL Server when you build an index on a spatial data type of a large table in a SQL Server 2012 instance
1581526 2887899FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table
1502271 2888658An access violation occurs when "sys.dm_db_index_physical_stats" is used in an IF EXISTS statement in an SQL query in SQL Server 2012
1499492 2889492You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1
1519097 2889723A series of errors occurs when you export a Reporting Services report as a PDF in SQL Server 2012
1519527 2890052Integration Services catalog permissions don't work for Windows groups in SQL Server 2012
1530003 2890415Notification messages are not received when data updates fail in a PowerPivot sheet in an instance of SQL Server 2012 Service Pack 1 Analysis Services
1482450 2891083FIX: Subscriptions does not have an option to use default parameter values that are based on expressions in SSRS 2012 in SharePoint Integrated mode
1531889 2891088FIX: Find option in Report Manager always takes you to the bottom of the page in SSRS 2012
1607598 2891230FIX: Error message when you select a report on the RSItemPicker.aspx page after you apply update 2791086 on a computer that is running SSRS 2008 R2 or SSRS 2012
1465349 2893842FIX: Fewer results in the MDS subscription view after you apply SQL Server 2012 SP1 or SQL Server 2012 CU2
1499658 2894025Mirror tables are dropped when you use "Change Data Capture for Oracle by Attunity" on a server that is running SQL Server 2012
1577746 2894305FIX: Suboptimal execution plan is generated when you run a query in SQL Server 2012
1577767 2894326An application cannot connect to a contained database when connection pooling is enabled in SQL Server 2012
1590906 2895494Slow SQL Server performance and a memory leak occurs after you apply Cumulative Update 3 for SQL Server 2012 Service Pack 1
1560706 2895694FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012
1599658 2896505Blank values for a DAX formula are seen in PowerPivot for Excel in SQL Server 2012 Analysis Services
1494708 2896720FIX: Slow performance in SQL Server 2012 when you build an index on a spatial data type of a large table
1578576 2897221Slow performance or error messages are logged when you have a transactional replication publisher server in SQL Server 2012
1607184 2897237FIX: Transaction date format on an MDS website in SQL Server 2012 differs from the format that is defined on the computer
1460938 2897263"An error occurred when loading VertiPaq data" error occurs after you run DISCOVER_XML_METADATA Rowset or load a database and then start a trace in SQL Server 2012 Analysis Services
1584328 2897265FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012
1607493 2897282FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 on a non-US locale computer
1596224 2897454FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012
1602357 2897512FIX: Newly added member disappears from the Master Data Explorer in SQL Server 2012 MDS
1610265 2897539FIX: IntelliSense feature does not work correctly after you type Transact-SQL statements in SSMS in SQL Server 2012
1615705 2897554FIX: Synchronization state of an AlwaysOn Availability Group replica may not be updated if primary is unhealthy
1610741 2897633FIX: You cannot start an audit by using an "ALTER" statement in SQL Server 2012
1530104 2899945FIX: "The report server cannot process the report" error when you view an SSRS 2012 report on a SharePoint website
1631258 2900127FIX: "PowerPoint was unable to open or save this document." error message after you modify an embedded PowerPivot table
1559163 2905275FIX: "The operation was cancelled by the user" error message when you run some MDX or DAX queries in SSAS 2012
1460958 2905298FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012
Notes for this update

Installation and deployment

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • 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 updates in this package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2012 service pack that contains the hotfixes in this package.

Cumulative update

Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server 2012 update release. We recommend that you consider applying the most recent update release.

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