[EN] SQL Server 2014 SP1 Cumulative Update #3 is available!

LOGO__SQLServer2014Ten days ago Microsoft released two packs of packages for SQL Server 2014. Ten days give us enough time to test those packages. In this post I’m writing about update for SQL Server 2014 with Service Pack 1. In this Cumulative Update No 3 {build 12.0.4427.24} Microsoft fixed about forty bugs and here is the list of fixed KB articles:

VSTS BUG: 5618976 | 3092704
Improvements for Distribution Agent telemetry for Azure subscribers are available in SQL Server 2014
SQL service

VSTS BUG: 5666744 | 3094865
FIX: “The process could not initialize ”” error occurs when you use merge publication in SQL Server 2014
SQL service

VSTS BUG: 5704512 | 3096617
FIX: Can’t backup in-memory OLTP database that is restored by using full and differential restore in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5575649 | 3097073
FIX: CPU usage is higher than expected when you reduce the value of CAP_CPU_PERCENT argument in creating resource pool
SQL service

VSTS BUG: 5544313 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when undeclared parameter targets a decimal column
SQL service

VSTS BUG: 5181922  | 3068359
FIX: “Cannot find the OLAP cube Model” error when you update the pivot table in a SharePoint document in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5181941 | 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English
Master Data Services (MDS)

VSTS BUG: 5715080 | 3087114
FIX: PowerPivot for SharePoint doesn’t run automatic data refresh on the first day of each month
Analysis Services

VSTS BUG: 5715082 | 3088307
FIX: Scheduler deadlock on primary replica when you remove a replica from an AlwaysOn availability group in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715087 | 3077273
FIX: Rare incorrect result occurs when you run parallel query in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715090 | 3080209
FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 5715112 | 3080856
FIX: Information disclosure when you create a session cube by using dynamic role-based security in SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5715123 | 3089687
FIX: Can’t export empty Tablix header in CSV file when NoHeader is false in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 5715131 | 3087872
FIX: Access violations when you use the FileTable feature in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715193  | 3097114
FIX: Queries take longer time to compile in SQL Server 2014 than in earlier versions
SQL performance

VSTS BUG: 4745298 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

VSTS BUG: 5489704 | 3099487
FIX: 100% CPU usage occurs when in-memory OLTP database is in recovery state in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5687518 | 3095958
FIX: Metadata inconsistency error occurs after you switch table partitions and drop corresponding files and filegroups
SQL service

VSTS BUG: 5808923 | 3099323
FIX: DBCC CHECKFILEGROUP reports false inconsistency errors on database that has partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5667070 | 3096400
FIX: It takes longer to run the ALTER DATABASE SET HADR OFF command on a secondary replica in SQL Server 2014
High Availability

VSTS BUG: 5181949 | 3075669
FIX: SSAS 2012 or SSAS 2014 crashes when you execute an MDX query that contains lots of Union expressions
Analysis Services

VSTS BUG: 5181961 | 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 or SQL Server 2014
Analysis Services

VSTS BUG: 5181966 | 3073907
FIX: SSIS 2012 or SSIS 2014 package with an Execute SQL Task may stop responding
Analysis Services

VSTS BUG: 5715073 | 3095156
FIX: Error 9002 and error 3052 when you try to add or back up log file in SQL Server 2012 or SQL Server 2014
High Availability

VSTS BUG: 5715100 | 3081580
FIX: “String or binary data would be truncated” error when you use peer-to-peer replication in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715108 | 3087094
FIX: It takes longer than expected when you run a query with non-admin user role in SSAS 2012 or SSAS 2014 in Tabular model
Analysis Services

VSTS BUG: 5715110 | 3088480
FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct
SQL performance

VSTS BUG: 5522017 | 2682488
FIX: Backup operation fails in a SQL Server database after you enable change tracking
SQL service

VSTS BUG: 5536023 | 3090141
FIX: Offline checkpoint thread shuts down without providing detailed exception information in SQL Server 2014
In-Memory OLTP

VSTS BUG: 5523582 | 3072814
FIX: Access violation occurs when you connect to an instance of SQL Server by using sqlcmd utility in SQL Server 2014
SQL connectivity

VSTS BUG: 5523590 | 3080155
FIX: Rare index corruption when you build a columnstore index with parallelism on a partitioned table in SQL Server 2014
SQL service

VSTS BUG: 5523599 | 3082860
FIX: Access violation occurs when you execute a query that contains many joins and coalesce functions in SQL Server 2014
SQL performance

VSTS BUG: 5523600 | 3082005
FIX: Case-sensitive does not work in MDS database in SQL Server 2014
MDS

VSTS BUG: 5715102 | 3091643
FIX: Error occurs when you configure SQL Server replication or set up a linked server in SQL Server 2012 or SQL Server 2014
SQL security

VSTS BUG: 5829179 | 3100361
FIX: DBCC CHECKDB doesn’t report metadata inconsistency of invalid filegroups in its summary in SQL Server 2014
SQL service

VSTS BUG: 5038265 | 3092702
FIX: It takes a longer time than earlier versions of SQL Server when you run DBCC CHECKDB in SQL Server 2012
SQL service

 

This update could be applied Microsoft SQL Server 2014, when used applies to

  • Microsoft SQL Server 2014 Service Pack 1

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    SQL Server 2014|MS_SQL14_SP1_QFE_CU3_x64
    SQL Server 2014|SQL_AS_OLEDB_64
    SQL Server 2014|MS_SQL14_SP1_QFE_CU3_x86
    SQL Server 2014|SQL_AS_OLEDB_86

Enjoy!

[EN] SQL Server 2012 SP1 Cumulative Update #15 is available!

LOGO__SQLServer2012SP1The second pack of updates for SQL Server in March is for SQL Server 2012 with Service Pack 1. In this Cumulative Update no 15 {build no 11.0.3487.0} Microsoft solved only one problem, which has been reported after latest CU 14.

VSTS BUG:  4106885 | KB: 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 MDS
Master Data Services (MDS)

This update could be applied to applies Microsoft SQL Server 2012 Service Pack 1, when used with:

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence
  • SQL Server 2012 Reporting Services
  • Microsoft SQL Server 2012 for Embedded Systems

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 15

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    2012_SP1_PPExcel_CU15_3038001_11_0_3487_x86
    SQLServer2012_SP1_CU15_3038001_11_0_3487_x86
    2012_SP1_RSShrPnt_CU15_3038001_11_0_3487_x64
    2012_SP1_PPExcel_CU15_3038001_11_0_3487_x64
    SQLServer2012_SP1_CU15_3038001_11_0_3487_x64

Enjoy!

[EN] SQL Server 2012 SP2 Cumulative Update #5 is available!

LOGO__SQLServer2012SP2First package for updates which have been released in March is for SQL Server 2012 with Service Pack 2. In this Cumulative Updates No 5 {build no 11.0.5582.0} Microsoft resolved almost thirty bugs. Some fixed errors has been published in Cumulative Update No 6 for SQL Server 2014 {post here} like SOS_CACHESTORE or PowerPivot bugs. Here is the full list of fixed bugs.

 

VSTS BUG:  4034265 | KB: 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission
Reporting Services

VSTS BUG:  4067264 | KB: 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server
SQL service

VSTS BUG:  3746215 | KB: 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages in SSIS 2012
Integration Services

VSTS BUG:  4067256 | KB: 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models
Analysis Services

VSTS BUG:  4067259 | KB: 3026082
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
SQL service

VSTS BUG:  4067262 | KB: 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

VSTS BUG:  4067274 | KB: 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG:  3995494 | KB: 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

VSTS BUG:  3980976 | KB: 3032476
FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012
SQL service

VSTS BUG:  4058285 | KB: 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source
Integration Services

VSTS BUG:  4077857 | KB: 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery
Analysis Services

VSTS BUG:  4124969 | KB: 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING
High Availability

VSTS BUG:  3987784 | KB: 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)

VSTS BUG:  4019503 | KB: 3037624
FIX: Complex parallel query does not respond in SQL Server 2012
SQL performance

VSTS BUG:  4138602 | KB: 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS 2012 report to Reporting Service Report Manager
Reporting Services

VSTS BUG:  4001004 | KB: 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS 2012
Reporting Services

VSTS BUG:  4111094 | KB: 3038332
FIX: Data Alerts tables are filled up and never be cleared old data when you use alerts for SSRS 2012 reports
Reporting Services

VSTS BUG:  4136827 | KB: 3038943
FIX: Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups
High Availability

VSTS BUG:  4142251 | KB: 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012
SQL service

VSTS BUG:  4166567 | KB: 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012
Reporting Services

VSTS BUG:  4166534 | KB: 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012
Integration Services

VSTS BUG:  4166659 | KB: 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2
Reporting Services

VSTS BUG:  4168490 | KB: 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application
SQL connectivity

VSTS BUG:  4203721 | KB: 3042007
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle
SQL service

VSTS BUG:  4142191 | KB: 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012
Analysis Services

VSTS BUG:  4073547 | KB: 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012
SQL service

VSTS BUG:  4049132 | KB: 3044958
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails
SQL service

 

This update could be applied Microsoft SQL Server 2012 Service Pack 2, when used with:

     – Microsoft SQL Server 2012 Enterprise

     – Microsoft SQL Server 2012 Developer

     – Microsoft SQL Server 2012 Express

     – Microsoft SQL Server 2012 Standard

     – Microsoft SQL Server 2012 Web

     – Microsoft SQL Server 2012 Analysis Services

     – Microsoft SQL Server 2012 Business Intelligence

     – Microsoft SQL Server 2012 for Embedded Systems

     – Microsoft SQL Server 2012 Parallel Data Warehouse

     – SQL Server 2012 Reporting Services

 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 5

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x86

    SQLServer2012_SP2_CU5_3037255_11_0_5582_x64

Enjoy!