Applies ToSQL Server 2012 Standard SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Web

INTRODUCTION

This article lists the bugs that are fixed in Microsoft SQL Server 2012 Service Pack 1 (SP1).Notes

  • Additional fixes that are not documented here may also be included in the service pack.

  • This list will be updated when more articles are released.

  • Mandatory SQL Server 2012 SP1 hotfixAfter you install SQL Server 2012 SP1, you may experience an issue in which Windows Installer starts repeatedly. This issue is described in the following article in the Microsoft Knowledge Base. This article includes a link to a downloadable hotfix that resolves the issue: Note It is mandatory that you install this hotfix after you install SQL Server 2012 SP1.

    2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1 For more information about this issue, visit the following MSDN website:After applying Service Pack 1 for SQL Server 2012 you may encounter a known issue! Details inside…..

For more information about how to obtain SQL Server 2012 service packs, click the following article number to view the article in the Microsoft Knowledge Base:

2755533 How to obtain the latest service pack for SQL Server 2012

More Information

In addition to the fixes that are listed in this article, SQL Server 2012 SP1 includes Microsoft SQL Server 2012 Cumulative Update 1 (CU1) and Microsoft SQL Server 2012 Cumulative Update 2 (CU2). Therefore, SQL Server 2012 SP1 contains the hotfixes that were included in SQL Server 2012 CU1 and in SQL Server 2012 CU2. For more information about the cumulative update packages that are available for SQL Server 2012, click the following article number to view the article in the Microsoft Knowledge Base:

2692828 The SQL Server 2012 builds that were released after SQL Server 2012 was released

Issues that are fixed in this service pack

For more information about the bugs that are fixed in SQL Server 2012 SP1, click the following article numbers to view the articles in the Microsoft Knowledge Base.

VSTS bug number

KB article number

Description

977015

2746012

FIX: Availability group failover takes a long time if a database in the availability group contains a FileTable in SQL Server 2012

838761

2645920

FIX: New Availability Group Wizard-generated scripts skip the steps for joining a secondary database to an availability group in SQL Server 2012

871327

2699720

FIX: You experience a deadlock condition when you run multiple SSIS packages in SQL Server 2012

917018

2705571

FIX: SQL Server Data Quality Client is fr when you try to delete a data quality project after you install Cumulative Update 1 for SQL Server 2012

898170

2712972

SQL Server 2012 DQS Export to 64-bit .xls Excel file fails with error

968815

2727221

FIX: You cannot install a SQL Server 2012 cluster instance on a Server Core operating system that contains an existing cluster instance

1012760

2774422

FIX: Master Data Services Add-in for Excel cannot be installed on a computer that has Microsoft Office 2013 installed

1021897

2774426

FIX: An attribute in a change tracking group is reset and flagged as unchanged in SQL Server 2012 Master Data Services

925157

2774432

FIX: "The client version is incompatible with the database version" error when you use MDS to create a web application after you install the cumulative update packages for SQL Server 2012

954940

2774434

FIX: "Cannot write into file 'dqs_certificate.cer'" error when you install Data Quality Services on a different path than the instance of SQL Server 2012

966140

2774437

FIX: Data Quality Services can be installed in the Standard edition of SQL Server 2012 unexpectedly

884792

2774439

An update that improves the Data Quality Services (DQS) installation output log in SQL Server 2012 is available

886202

2774442

FIX: Hierarchies are not alphabetically sorted when you explore them by using Master Data Services in SQL Server 2012

965239

2723814

You experience slow synchronization between primary and secondary replicas in SQL Server 2012

892506

2930239

FIX: Non-yielding scheduler error when outer joining DMVs with a mismatched ON clause in SQL Server 2008 R2 or SQL Server 2012

Resolutions to the following issues are also included in SQL Server 2012 SP1.

VSTS bug number

Description

825067

"View Sample Records" is disabled in the "discovery" process in SQL Server Data Quality Services (DQS).

825141

Vertical scroll of Log Severity data grid is missing in DQS.

842186

New clause is incorrectly added to a previous rule of the current or previous domain in DQS.

852637

Empty "Name" column is not published as NULLin DQS.

859290

A child domain of a composite domain is not formatted when the child domain has a specific formatting.

874949

A read-only user who is in a group that has update permission can perform an update operation.

878653

"IsolatedStorageException" exception when you try to access an entity in Master Data Services in InPrivate Browsing mode in Internet Explorer.

879875

A date time column does not increase for every 20 rows that are updated to the Remote Date Services in SQL Server 2012.

880547

No results are displayed when you search a value in a Hebrew string.

881023

An unhandled exception occurs when you try to sign in to a Data Quality Project in DQS.

882088

"File download failed, check that the export destination file does not already exist" error when you try to export to an Excel file in DQS.

882306

"The given key was not present in the dictionary" error when you approve the changes in a newly-added term-based relation in DQS.

891191

Explicit hierarchies are corrupted because of circular references in SQL Server 2012.

891468

"Windows PowerShell is not installed on this server" error when you launch Configuration Manager.

896478

Installation operation fails when you run the DQSInstaller.exe file to install DQS server if you specify the "&" character in the password for the database master key.

902725

"Failed to save Configuration Name" error when a Windows user whose name has accented characters tries to open a data quality project by using Data Quality Client.

905104

Updated knowledge bases cannot be used in an already-open cleansing project in DQS.

907179

Incorrect error message is displayeds when you try to use Data Quality Client.Note In this description, the word "displayeds" is a misspelling for the word "displayed."

916173

The sort order is corrupted when you run the [mdm].[udpAttributeSave] stored procedure against an existing attribute in SQL Server 2012.

932693

"Login failed for user '<Domain>\<User>'. Failed to open the explicitly specified database 'DQS_MAIN'. [CLIENT: <local machine>]" error in Master Data Services if DQS is not installed.

935253

Cannot publish business rules when attributes contain "&" in the attribute name in Master Data Services.

935653

An access violation occurs when executing a substring function together with an invalid offset by using remote procedure call (RPC).

949931

"Date Postfix Argument Expected" error if you create a "has changed" business rule for an attribute of "DateTime" type in Master Data Services web UI.

954328

"An unexpected error occurred during the last correction process" error when you try to run DQS data cleansing in SQL Server 2012.

956115

DQS violation error message is hard to understand when you use the Master Data Services Add-in for Microsoft Excel or the Master Data Services web UI.

956194

Cannot hard delete any soft-deleted members from the Master Data Services database.

956431

Incorrect popup message when you create matching policy and then run a data matching project in DQS.

962881

A .NET Framework 4.5-based application freezes instead of handling the exception when you use the Master Data Services Add-in for Excel.

966134

"String or binary data would be truncated" error when the length of a SQL Server Integration Services (SSIS) DQS cleansing component name is longer than 32 characters.

972072

"SQL46010: Incorrect syntax near SPARSE" error in a SQL Server Data Tools (SSDT) project.

973194

The TSqlParser.ParseSubQueryExpressionWithOptionalCTE() method returns NULL for a SELECTstatement that contains a common table expression (CTE) and a pair of parentheses in an SSDT project.

978657

You cannot publish a business rule when the rule contains a "Equals a Concatenated Value" or "Must be Unique" action, and the selected attribute name has more than 128 characters.

979356

Msg 515, Level 16, State 2, Procedure udp_test_Leaf, Line 335 Cannot insert the value NULL into column 'Code', table 'MDS.mdm.tblStgErrorDetail'; column does not allow nulls. INSERT fails" error when you insert the NULL value into a column that allows for code in the tblStgErrorDetail table.

1017627

Relationship staging tables do not have an index in the BatchTag column. When there are many records in a batch staging table, a staging process experiences slow performance. SQL Server 2012 SP1 adds an index on the BatchTag column.

1022009

SQL Server 2012 SP1 now enables the String values to be converted to the Numeric values.

Resolutions to the following SQL Server deployment platform issues are also included in SQL Server 2012 SP1.

VSTS bug number

Description

861978

An error occurs, and you cannot find the SQL Server Reporting Services instance that you want to upgrade.

887180

Setup program (uninstall or remove node) does not delete a service when the service is marked for deletion.

895610

The 32-bit version of the SQL Server 2012 Express component is not updated when you install SQL Server support on 64-bit versions of Windows.

934788

You cannot uninstall the localized shared feature in SQL Server Service Packs.

936548

FIX: The value of UpdateDescription attribute is empty in the SQL Server 2012 SP1 Express edition slipstream package.

1025500

Shared features are not discovered in the feature selection page after you install SQL Server 2012 SP1.

918421

"Try the installation again using a valid copy of the installation package 'sqlls.msi'." error when you try to repair SQL Server 2012.

923970

Setup fails with a "path not found" error when you try to install the VSTA_DTLP30.msi file.

931703

You cannot install SQL Server 2012 SP1 because another Windows Installer action is in progress.

967159

The setup process randomly fails with an "access violation" error.

1030137

You cannot uninstall SQL Server 2012 SP1 on Windows 8 if you have not installed the Microsoft .NET Framework 3.5.

959184

An unhandled exception occurs in the Microsoft .NET Framework when you install a second instance of SQL Server 2012.

887176

A previously failed SQL Server installation prevents SQL Server Service Packs or Cumulative Updates from installing successfully.

880222

Adds support for the retry logic in order to bring cluster resources online.

863805

A missing IAcceptSqlServerLicenseTerms entry in the Summary log and an incorrect entry in the Settings.xml file indicate that you have rejected the Microsoft Software License Terms.

853528

The /QS parameter in a command line does not overwrite /QUITESIMPLE =”False” in configuration file when you install SQL Server 2012.

972251

The IP/subnet option is disabled on the Cluster Network Configuration page, and you cannot move to next step.

748122

The setup UI is displayed left-to-right for Hebrew and Arabic languages when you run rsSharePoint.msi.

810794

The Cluster Network Configuration page in the ADDNODE wizard does not show a selected instance's IP addresses if you go back and select a new instance of SQL Server.

824972

The navigation pane is too wide in SQL Server Installation Center.

964995

Adds a rule to warn you if the .NET Framework 3.5 is not installed and if the computer cannot access the Internet.

880779

Setup process does not provide a summary that describes the next steps when you cannot update or remove an update.

969810

You cannot install SQL Server updates through Windows Server Update Services or Microsoft Update on passive nodes of clustered instances.

880225

Adds methods in Service Quality Monitoring (SQM) and in Watson to help you understand why the Setup program cannot install an MSI because of ERROR_PATH_NOT_FOUND code.

880233

Setting validation does not report the correct setting that causes a failure in SQM and in Watson.

897566

FIX: SQM is turned off in SQL Server 2012 Service Pack CTPs.

880228

FIX: Fix the UserGroup.Exists() reporting method in SQM and Watson.

830970

Setup account validation method throws an exception when the Active Directory server is down.

926981

"There was a failure to call cluster code from a provider. Exception message: Generic failure. Status code: 997" error message when you upgrade from SQL Server 2008 R2 SP1 to SQL Server 2012.

828466

"Incorrect SKUs supported" message when you try to install SQL Server in clustered environment.

973499

FIX: Persistent state is set to 1 when an IP address is created in SQL Server Multi-Subnet Clustering.

858717

You cannot upgrade from Microsoft SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2012 on a Windows 8-based cluster.

878531

You cannot uninstall SQL Server 2012 that has dependencies on multiple mount points.

861377

You cannot use the SQL Server slipstream package to update the current feature to Service Pack 1 when you add a new feature at the same time.

846622

The Install wizard freezes when it searches for product updates.

817937

FIX: Master Data Services (MDS) feature is visible in the feature tree when you try to uninstall SQL Server 2012 SP1.

954667

FIX: When you try to update the SQL Server Client Tools or SQL Server Full-Text Search feature by using a corrupted installer file, the feature does not display the correct error message.

819093

Feature selection is unavailable when you install a security update for shared components when the instance component is at a different service pack level.

907647

FIX: Updates SQM to report the service pack level as a number.

887062

FIX: SQL Server service pack applies English to certain features even though these features are installed by using a localized language.

1018645

"Exit code:-2068578302" error message when you try to uninstall an instance of SQL Server 2012.

829208

Reporting service is in a bad state after a SQL Server upgrade fails.

References

For more information about how to determine the current SQL Server version and edition, click the following article number to view the article in the Microsoft Knowledge Base:

321185 How to determine the version and edition of SQL Server and its components

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.