Applies ToSQL Server 2012 Business Intelligence SQL Server 2012 Enterprise SQL Server 2012 Developer SQL Server 2012 Standard SQL Server 2012 Web SQL Server 2012 Express SQL Server 2012 Enterprise Core

INTRODUCTION

This article lists the bugs that are fixed in the Community Technology Preview (CTP) version of Microsoft SQL Server 2012 Service Pack 1 (SP1).Notes

  • This is a CTP version of SQL Server 2012 SP1. This version is not supported by Microsoft Customer Support Services. You can submit your feedback at the following Microsoft Connect website:

    Microsoft SQL Server Connect

  • Other fixes that are not documented may be included in the service pack.

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

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 CTP contains the hotfixes that were included in cumulative update packages that are available for SQL Server 2012. 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

The issues that are fixed in this CTP version of the service pack

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

VSTS bug number

KB article number

Description

Status

977015

2746012

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

Public

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

Public

871327

2699720

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

Public

917018

2705571

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

Public

898170

2712972

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

Public

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

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 previous rule of current or previous domain in DQS.

852637

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

859290

A child domain of 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 message 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 Master Data Services web UI or Excel Add-in.

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

The .NET Framework 4.5-based application stops responding 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.

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.