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:
-
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 |
FIX: Availability group failover takes a long time if a database in the availability group contains a FileTable in SQL Server 2012 |
Public |
|
838761 |
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 |
FIX: You experience a deadlock condition when you run multiple SSIS packages in SQL Server 2012 |
Public |
|
917018 |
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 |
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