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

 

List of Bugs Fixed in SQL Server 2014 SP1 CU2 – 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 Service Pack 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4775394
FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled SQL service
SQL Server MSDN KB Number 4999045
FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1 SQL performance
SQL Server MSDN KB Number 5181898
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database SQL service

SQL Server MSDN KB Number 5181900
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
SQL Server MSDN KB Number 5181902
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service
SQL Server MSDN KB Number 5181933
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014 SQL performance

SQL Server MSDN KB Number 4837970
FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1 SQL service
SQL Server MSDN KB Number 4741544
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014 Management Tools
SQL Server MSDN KB Number 5067465
FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes SQL security

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 2014 SP1 CU2 – Part 4

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 Service Pack 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4867179
FIX: “Cannot Start Application” error occurs when you start SQL Server Reporting Services Report Builder in SQL Server 2014 Service Pack 1 Reporting Services
SQL Server MSDN KB Number 4741577
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4741535
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014 Analysis Services

SQL Server MSDN KB Number 4737114
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube Analysis Services
SQL Server MSDN KB Number 4737059
FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently Analysis Services
SQL Server MSDN KB Number 4584553
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014 Analysis Services

SQL Server MSDN KB Number 4584517
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
SQL Server MSDN KB Number 4744189
FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014 SQL connectivity
SQL Server MSDN KB Number 4767653
FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014 High Availability
SQL Server MSDN KB Number 4921039
FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column in SQL Server 2014 SQL service

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 2014 SP1 CU2 – Part 3

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 Service Pack 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4737005
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4736989
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Analysis Services
SQL Server MSDN KB Number 4736988
FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services

SQL Server MSDN KB Number 4584562
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
SQL Server MSDN KB Number 5159952
FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1 High Availability
SQL Server MSDN KB Number 5020141
FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1 High Availability

SQL Server MSDN KB Number 5181955
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014 SQL performance
SQL Server MSDN KB Number 5181937
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
SQL Server MSDN KB Number 5181930
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014 SQL service

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 3 4 11