List of Bugs Fixed in SQL Server 2012 SP1 – Part 10

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 846622
The Install wizard freezes when it searches for product updates.
SQL Server MSDN Bug Number 817937
FIX: Master Data Services (MDS) feature is visible in the feature tree when you try to uninstall SQL Server 2012 SP1.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 907647
FIX: Updates SQM to report the service pack level as a number.

SQL Server MSDN Bug Number 887062
FIX: SQL Server service pack applies English to certain features even though these features are installed by using a localized language.
SQL Server MSDN Bug Number 1018645
“Exit code:-2068578302” error message when you try to uninstall an instance of SQL Server 2012.
SQL Server MSDN Bug Number 829208
Reporting service is in a bad state after a SQL Server upgrade fails.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP1 – Part 8

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN Bug Number 853528
The /QS parameter in a command line does not overwrite /QUITESIMPLE =”False” in configuration file when you install SQL Server 2012.
SQL Server MSDN Bug Number 972251
The IP/subnet option is disabled on the Cluster Network Configuration page, and you cannot move to next step.
SQL Server MSDN Bug Number 748122
The setup UI is displayed left-to-right for Hebrew and Arabic languages when you run rsSharePoint.msi.

SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 824972
The navigation pane is too wide in SQL Server Installation Center.
SQL Server MSDN Bug Number 964995
Adds a rule to warn you if the .NET Framework 3.5 is not installed and if the computer cannot access the Internet.

SQL Server MSDN Bug Number 880779
Setup process does not provide a summary that describes the next steps when you cannot update or remove an update.
SQL Server MSDN Bug Number 969810
You cannot install SQL Server updates through Windows Server Update Services or Microsoft Update on passive nodes of clustered instances.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 880233
Setting validation does not report the correct setting that causes a failure in SQM and in Watson.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP1 – Part 7

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN Bug Number 1025500
Shared features are not discovered in the feature selection page after you install SQL Server 2012 SP1.
SQL Server MSDN Bug Number 918421
“Try the installation again using a valid copy of the installation package ‘sqlls.msi’.” error when you try to repair SQL Server 2012.
SQL Server MSDN Bug Number 923970
Setup fails with a “path not found” error when you try to install the VSTA_DTLP30.msi file.

SQL Server MSDN Bug Number 931703
You cannot install SQL Server 2012 SP1 because another Windows Installer action is in progress.
SQL Server MSDN Bug Number 967159
The setup process randomly fails with an “access violation” error.
SQL Server MSDN Bug Number 1030137
You cannot uninstall SQL Server 2012 SP1 on Windows 8 if you have not installed the Microsoft .NET Framework 3.5.

SQL Server MSDN Bug Number 959184
An unhandled exception occurs in the Microsoft .NET Framework when you install a second instance of SQL Server 2012.
SQL Server MSDN Bug Number 887176
A previously failed SQL Server installation prevents SQL Server Service Packs or Cumulative Updates from installing successfully.
SQL Server MSDN Bug Number 880222
Adds support for the retry logic in order to bring cluster resources online.
SQL Server MSDN Bug Number 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.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP1 – Part 6

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 1022009
SQL Server 2012 SP1 now enables the String values to be converted to the Numeric values.
SQL Server MSDN Bug Number 861978
An error occurs, and you cannot find the SQL Server Reporting Services instance that you want to upgrade.
SQL Server MSDN Bug Number 887180

Setup program (uninstall or remove node) does not delete a service when the service is marked for deletion.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 934788
You cannot uninstall the localized shared feature in SQL Server Service Packs.
SQL Server MSDN Bug Number 936548
FIX: The value of UpdateDescription attribute is empty in the SQL Server 2012 SP1 Express edition slipstream package.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP1 – Part 5

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN Bug Number 935253
Cannot publish business rules when attributes contain “&” in the attribute name in Master Data Services.
SQL Server MSDN Bug Number 935653
An access violation occurs when executing a substring function together with an invalid offset by using remote procedure call (RPC).
SQL Server MSDN Bug Number 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.

SQL Server MSDN Bug Number 954328
“An unexpected error occurred during the last correction process” error when you try to run DQS data cleansing in SQL Server 2012.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 956194
Cannot hard delete any soft-deleted members from the Master Data Services database.

SQL Server MSDN Bug Number 956431
Incorrect popup message when you create matching policy and then run a data matching project in DQS.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 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.
SQL Server MSDN Bug Number 972072
“SQL46010: Incorrect syntax near SPARSE” error in a SQL Server Data Tools (SSDT) project.

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP1 – Part 1

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of SQL Server 2012 Service Pack 1 (SP 1) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2746012
FIX: Availability group failover takes a long time if a database in the availability group contains a FileTable in SQL Server 2012
SQL Server MSDN KB Number 2645920
FIX: New Availability Group Wizard-generated scripts skip the steps for joining a secondary database to an availability group in SQL Server 2012
SQL Server MSDN KB Number 2699720
FIX: You experience a deadlock condition when you run multiple SSIS packages in SQL Server 2012

SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 2712972
SQL Server 2012 DQS Export to 64-bit .xls Excel file fails with error
SQL Server MSDN KB Number 2727221
FIX: You cannot install a SQL Server 2012 cluster instance on a Server Core operating system that contains an existing cluster instance

SQL Server MSDN KB Number 2774422
FIX: Master Data Services Add-in for Excel cannot be installed on a computer that has Microsoft Office 2013 installed
SQL Server MSDN KB Number 2774426
FIX: An attribute in a change tracking group is reset and flagged as unchanged in SQL Server 2012 Master Data Services
SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 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

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 
1 2