List of Bugs Fixed in SQL Server 2012 SP2 CU5 – Part 2

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 2 Cumulative Update 5 (SP 2 CU5) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source Integration Services
SQL Server MSDN KB Number 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery Analysis Services
SQL Server MSDN KB Number 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING High Availability

SQL Server MSDN KB Number 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 MDS Master Data Services (MDS)
SQL Server MSDN KB Number 3037624
FIX: Complex parallel query does not respond in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS 2012 report to Reporting Service Report Manager Reporting Services

SQL Server MSDN KB Number 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 3038332
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports Reporting Services
SQL Server MSDN KB Number 3038943
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups High Availability

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 SP2 CU6 – Part 2

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 2 Cumulative Update 6 (SP 2 CU6) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 3051993
FIX: The value of NUMBER type is truncated when you select data from Oracle linked server by using OLE DB provider SQL service
SQL Server MSDN KB Number 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012 Integration Services
SQL Server MSDN KB Number 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder Setup & Install
SQL Server MSDN KB Number 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server SQL security

SQL Server MSDN KB Number 3035737
FIX: Access violation occurs when you run cube writeback commit transaction and batch processing at the same time Analysis Services
SQL Server MSDN KB Number 3041476
FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 or SQL Server 2012 SQL service
SQL Server MSDN KB Number 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service SQL service
SQL Server MSDN KB Number 3020350

FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
SQL Server MSDN KB Number 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry SQL service
SQL Server MSDN KB Number 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS Master Data Services (MDS)
SQL Server MSDN KB Number 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
SQL Server MSDN KB Number 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012 SQL connectivity

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 CU1 – Part 9

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 1 (SP 1 CU1) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 3070139
FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS data mining models Analysis Services
SQL Server MSDN KB Number 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server SQL service

SQL Server MSDN KB Number 3025968
FIX: SSRS pages contain unlabeled check boxes in the detailed view Reporting Services
SQL Server MSDN KB Number 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS report to Reporting Services Report Manager Reporting Services
SQL Server MSDN KB Number 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS Reporting Services

SQL Server MSDN KB Number 3044160
FIX: Performance counters under “ReportServer:Service” object show zero in SSRS 2014 Reporting Services
SQL Server MSDN KB Number 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014 Integration Services
SQL Server MSDN KB Number 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014 MDS
SQL Server MSDN KB Number 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type Reporting Services

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

SQL Server MSDN KB Number 3025845
FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
SQL Server MSDN KB Number 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013 Analysis Services

SQL Server MSDN KB Number 3030041
FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014 Setup & Install
SQL Server MSDN KB Number 3030325
FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh Analysis Services
SQL Server MSDN KB Number 3030326
FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013 Analysis Services

SQL Server MSDN KB Number 3030619
FIX: Incorrect data returned when you query the DATE column in SQL Server 2014 SQL service
SQL Server MSDN KB Number 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014 Management Tools
SQL Server MSDN KB Number 3034615
FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3035071
FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command Management Tools

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 CU1 – 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 1 (SP 1 CU1) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version Setup & Install
SQL Server MSDN KB Number 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
SQL Server MSDN KB Number 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014 SQL performance

SQL Server MSDN KB Number 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service SQL service
SQL Server MSDN KB Number 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012 SQL service

SQL Server MSDN KB Number 2994082
FIX: Error when you edit models for some groups or users in MDS for SQL Server 2012 or SQL Server 2014 MDS
SQL Server MSDN KB Number 2995622
FIX: “Specified cast is not valid” when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration Services
SQL Server MSDN KB Number 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity” Analysis Services
SQL Server MSDN KB Number 3023620
FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013 Analysis Services

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 CU1 – Part 2

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 1 (SP 1 CU1) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source Analysis Services
SQL Server MSDN KB Number 3067659
FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks SQL service
SQL Server MSDN KB Number 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014 SQL service

SQL Server MSDN KB Number 3071024
“Alter failed for Database” error occurs when you enable the “Change Tracking” option for the Azure SQL Database in SQL Server Management Studio 2014 Management Tools
SQL Server MSDN KB Number 3045410
FIX: A query that uses the DECRYPTBYKEY function takes a long time in SQL Server 2014 SQL security
SQL Server MSDN KB Number 3042683
FIX: Data Tools error occurs when you upgrade a DTS package in SQL Server 2014 Integration Services

SQL Server MSDN KB Number 3042370
An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 SQL performance
SQL Server MSDN KB Number 3037624
FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014 SQL performance

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 CU8 – 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 Cumulative update package (CU) 8 for Microsoft SQL Server 2014.

MSDN Support KB Article 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014 SQL service
MSDN Support KB Article 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 SQL performance
MSDN Support KB Article 3063054
Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures SQL service

MSDN Support KB Article 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder Setup & Install
MSDN Support KB Article 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry SQL service
MSDN Support KB Article 3067659

FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks SQL service
MSDN Support KB Article 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source Analysis Services
MSDN Support KB Article 3055646
FIX: Error 35377 when you run a parallel query that contains MERGE statements 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 CU8 – 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 Cumulative update package (CU) 8 for Microsoft SQL Server 2014.

MSDN Support KB Article 3048627
FIX: “Cannot access the specified path or file on the server” when you use CSV in SSMS to back up or restore database Management Tools
MSDN Support KB Article 3067968
FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014 SQL service
MSDN Support KB Article 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem Management Tools

MSDN Support KB Article 3051993
FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider SQL service
MSDN Support KB Article 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014 MDS
MSDN Support KB Article 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services

MSDN Support KB Article 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012 Integration Services
MSDN Support KB Article 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time Analysis Services
MSDN Support KB Article 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
MSDN Support KB Article 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014 SQL performance

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 CU7 – 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 Cumulative update package (CU) 7 for Microsoft SQL Server 2014.

MSDN Support KB Article 3053664
FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014 SQL service
MSDN Support KB Article 3041476
FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 SQL service
MSDN Support KB Article 3045410
FIX: A query that uses the DECRYPTBYKEY function takes longer to be completed in SQL Server 2014 SQL security
MSDN Support KB Article 3048752
FIX: A SELECT query run as a parallel batch-mode scan may cause a deadlock situation in SQL Server 2014 SQL service

MSDN Support KB Article 3041967
FIX: “Unable to retrieve data for this section of the report” error when you request the Service Broker Statistics report in SQL Server 2014 Management Tools
MSDN Support KB Article 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 Integration Services
MSDN Support KB Article 3055799
FIX: “Cannot bulk load” error when you run a query that contains INSERT statements when trace flags 4199 and 610 are enabled on a server that is running SQL Server 2014 SQL performance
MSDN Support KB Article 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 SQL connectivity

MSDN Support KB Article 3052244
FIX: Incorrect result when the “must be unique” action is evaluated for an attribute by using SQL Server 2014 Master Data Services MDS
MSDN Support KB Article 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
MSDN Support KB Article 3051663
FIX: “8156: A database error has occurred” when you run a business rule in SQL Server 2014 Master Data Services MDS
MSDN Support KB Article 3048856
FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014 SQL service
MSDN Support KB Article 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013 Analysis Services

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 CU7 – 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 Cumulative update package (CU) 7 for Microsoft SQL Server 2014.

MSDN Support KB Article 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS data mining models Analysis Services
MSDN Support KB Article 3044160
FIX: Performance counters under “ReportServer:Service” object show zero in SSRS 2014 Reporting Services
MSDN Support KB Article 3042370
An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014 SQL service

MSDN Support KB Article 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012 or SQL Server 2014 SQL service
MSDN Support KB Article 3042077
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
MSDN Support KB Article 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application SQL connectivity

MSDN Support KB Article 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2 Reporting Services
MSDN Support KB Article 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012 or SQL Server 2014 Reporting Services
MSDN Support KB Article 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012 or SQL Server 2014 SQL service
MSDN Support KB Article 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012 or SSIS 2012 Integration Services

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