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

On May 18th Microsoft released two packages of updates. Second is the Cumulative Update No 6 {bulid no 11.0.5592.0} for Microsoft SQL Server 2012 SP2 and Microsoft fixed twenty three bugs. Released list of bugs are below.

VSTS BUG: 4385496 | KB: 3053960
FIX: A system assertion in longrec.inl:1318 occurs when you rebuild or create an index on a table in SQL Server 2012
SQL service

VSTS BUG: 4259067 | KB: 3054180
FIX: Time to create a SQL Server LineString instance may take longer than expected in SQL Server 2012
SQL service

VSTS BUG: 3983191 | KB: 3029096
FIX: The changes in Oracle database are not replicated to the SQL Server 2012 database correctly
Integration Services

VSTS BUG: 4302331 | KB: 3047538
FIX: Result of aggregated values is incorrect when you execute a MDX query in SSAS 2012
Analysis Services

VSTS BUG: 4270418 | KB: 3054504
FIX: The bcp utility may crash when you use SQL Server 2012
SQL connectivity

VSTS BUG: 4320246 | KB: 3054530
FIX: Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable
SQL service

VSTS BUG: 4227763 | KB: 3043889
FIX: The chart in SSRS 2012 report is not updated correctly when you update the parameter in the URL of the report
Reporting Services

VSTS BUG: 4433378 | KB: 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012
SQL service

VSTS BUG: 4346311 | KB: 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 report when the data source is SAP NetWeaver BI type
Reporting Services

VSTS BUG: 4333683 | KB: 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012
SQL service

VSTS BUG: 4001676 | KB: 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012
Analysis Services

VSTS BUG: 4230622 | KB: 3051993
FIX: The value of NUMBER type is truncated when you select data from Oracle linked server by using OLE DB provider
SQL service

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

VSTS BUG: 4452477 | KB: 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder
Setup & Install

VSTS BUG: 4254787 | KB: 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server
SQL security

VSTS BUG: 4095370 | KB: 3035737
FIX: Access violation occurs when you run cube writeback commit transaction and batch processing at the same time
Analysis Services

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

VSTS BUG: 4221342 | KB: 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service
SQL service

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

VSTS BUG: 4301100 | KB: 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry
SQL service

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

VSTS BUG: 4204971 | KB: 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

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

 

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
  • SQL Server 2012 Reporting Services
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence

 

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 6

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_SP2_SNAC_CU6_3052468_11_0_5592_x86
    SQLServer2012_SP2_CU6_3052468_11_0_5592_x86
    2012_SP2_SNAC_CU6_3052468_11_0_5592_x64
    SQLServer2012_SP2_CU6_3052468_11_0_5592_x64

Enjoy!

[EN] SQL Server 2014 RTM Cumulative Update #6 is available!

LOGO__SQLServer2014downloadIn February Microsoft released only one package for SQL Server. And it is for SQL Server 2014 RTM. In this Cumulative Update No 6 {build no 12.0.2480.0} Microsoft resolved over sixty bugs and problems, so it’s another one very big update. They solved many problems for Reporting Services, Analysis Services, MDS, SQLOS, and Setup. Most interesting from my perspective are below and of course list of all fixed problems are later in this post. 

FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
FIX: SOS_CACHESTORE spinlock contention on system table rowset cache causes high CPU usage in SQL Server 2012 or 2014
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014
FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014
FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days
FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking

 

VSTS bug: 3720641 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014
Master Data Services (MDS)

VSTS bug: 3720632 | KB: 2994082
FIX: Error when you edit models for some groups or users in MDS for SQL Server 2012 or SQL Server 2014
MDS

VSTS bug: 3720667 | KB: 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 or 2014 report
Reporting Services

VSTS bug: 4067294 | KB: 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

VSTS bug: 3720645 | KB: 2997020
FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012 or 2014
Reporting Services

VSTS bug: 3720652 | KB: 3000494
FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
Reporting Services

VSTS bug: 3720673 | KB: 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file
Reporting Services

VSTS bug: 3720674 | KB: 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012 or SSRS 2014
Reporting Services

VSTS bug: 3720679 | KB: 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012 or SSRS 2014
Reporting Services

VSTS bug: 4067278 | KB: 3006838
FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time
Analysis Services

VSTS bug: 3720692 | KB: 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report
SQL service

VSTS bug: 3720693 | KB: 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 or SSRS 2014
Reporting Services

VSTS bug: 4067279 | KB: 3010148
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS
Analysis Services

VSTS bug: 3720691 | KB: 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode
SQL service

VSTS bug: 4067280 | KB: 3011465
FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 is under memory pressure
SQL service

VSTS bug: 3720661 | KB: 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
SQL service

VSTS bug: 3720668 | KB: 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

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

VSTS bug: 4067285 | KB: 3016384
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
Analysis Services

VSTS bug: 4067289 | KB: 3017544
FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently
Analysis Services

VSTS bug: 4067291 | KB: 3019110
FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013
SQL service

VSTS bug: 4067300 | KB: 3021757
FIX: Duplicate sequence value is generated when you run sp_sequence_get_range in parallel with NEXT VALUE FOR function
SQL service

VSTS bug: 3989801 | KB: 3023634
FIX: Conversion error occurs when you use a business rule in SQL Server 2012 or SQL Server 2014 MDS
MDS

VSTS bug: 4067301 | KB: 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version
Setup & Install

VSTS bug: 3986465 | KB: 3024815
FIX: Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014
SQL performance

VSTS bug: 4067305 | KB: 3025408
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014
Analysis Services

VSTS bug: 3915402 | KB: 3025845
FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014
SQL service

VSTS bug: 4067260 | 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: 4067263 | 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: 4067310 | KB: 3027214
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014
Management Tools

VSTS bug: 3967105 | KB: 3027847
FIX: Date conversion error when you use German SQL Server 2014 MDS in a German Windows operating system
MDS

VSTS bug: 3916894 | KB: 3027860
FIX: Error 17066 or 17310 during SQL Server startup
SQL service

VSTS bug: 4067313 | KB: 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTS bug: 4067302 | KB: 3028226
FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 or SSRS 2014
Reporting Services

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

VSTS bug: 4067296 | KB: 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube
Analysis Services

VSTS bug: 3856439 | KB: 3029762
FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014
SQL service

VSTS bug: 4067312 | KB: 3029825
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS bug: 4001583 | KB: 3029977
FIX: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014
SQL service

VSTS bug: 3885366 | KB: 3030041
FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014
Setup & Install

VSTS bug: 3921521 | KB: 3030325
FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh
Analysis Services

VSTS bug: 3891407 | KB: 3030326
FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013
Analysis Services

VSTS bug: 3749961 | KB: 3030619
FIX: Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014
SQL service

VSTS bug: 3745645 | KB: 3032067
FIX: Access denied when a newly added user browses to an MDS website in SQL Server 2014
MDS

VSTS bug: 3891762 | KB: 3032068
FIX: No MDSTrace.log file is generated after you enable tracing in the MDS 2014 web.config file
MDS

VSTS bug: 4098462 | KB: 3032087
FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014
Management Tools

VSTS bug: 3859399 | KB: 3034297
FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days
Management Tools

VSTS bug: 4072235 | KB: 3034615
FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014
SQL service

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

VSTS bug: 4084380 | KB: 3035071
FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command
Management Tools

VSTS bug: 4084413 | KB: 3035077
FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking
Management Tools

VSTS bug: 4050736 | KB: 3035165
FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014
SQL service

VSTS bug: 3894942 | KB: 3036328
FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014
SQL service

VSTS bug: 3988942 | KB: 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005
Management Tools

 

This update could be applied to applies to

– Microsoft SQL Server 2014 Developer

Microsoft SQL Server 2014 Enterprise

Microsoft SQL Server 2014 Express

Microsoft SQL Server 2014 Web

Microsoft SQL Server 2014 Standard

SQL Server 2014 Reporting Services

Microsoft SQL Server 2014 Business Intelligence

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 6

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: (1) Install the service pack on the passive node (2) Install the service pack on the active node (This step requests service restart).

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:

  • SQLServer2014_RTM_CU6_3031047_12_0_2480_x64 (641 MB)
  • SQLServer2014_RTM_CU6_3031047_12_0_2480_x86 (384 MB)

Enjoy!

[EN] SQL Server 2012 SP1 Cumulative Update 6 is available

LOGO__SQLServer2012Another update for SQL Server 2012 is available. This Cumulative Update No 6 for SQL Server 2012 with Service Pack 1 (Build number: 11.0.3381.0) resolving over twenty five requested bugs, appeared after Service Pack 1. The list are below:

VSTS BUG: 1222472 | 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

VSTS BUG: 1293680 | 2847735
FIX: "A PivotTable, cube function or slicer using connection <conn> had failed to refresh" error when you update data in an Excel workbook that is sourced from a perspective in SSAS 2012

VSTS BUG: 1396889 | 2859713
FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008, SQL Server 2012 or SQL Server 2008 R2

VSTS BUG: 1347148 | 2860446
FIX: An unexpected error occurs in function ‘XMCompressionAnalyzer::SelectBitPackCompression’ when you perform a Process command against a partitioned table in SSAS 2012

VSTS BUG: 1366483 | 2864111
FIX: It takes longer than expected to cancel an MDX query that contains many GROUP BY clauses in SSAS 2012

VSTS BUG: 1382357 | 2872854
FIX: Error 14420 when you enable Log Shipping on databases that are in an AlwaysOn availability group in SQL Server 2012

VSTS BUG: 1405603 | 2872946
FIX: CPU spinning occurs when you use Power View to run a DAX query against a Multidimensional model in SSAS 2012

VSTS BUG: 1384027 | 2873474
FIX: Error "Column ‘<column name>’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" when you run a query in SQL Server 2012

VSTS BUG: 1416030 | 2874875
FIX: Dependent DBA member data is not updated when you use entity-based staging in MDS in SQL Server 2012

VSTS BUG: 1377755 | 2874957
FIX: Scheduled data refresh disabled after you make some modifications to the PowerPivot workbook in SharePoint 2013 that interacts with SSAS 2012

VSTS BUG: 1362520 | 2875158
FIX: Inconsistent data order when you copy data from a PowerPivot worksheet to an Excel worksheet

VSTS BUG: 1428610 | 2876733
FIX: Slow performance on SQL Server 2012 linked server when you update the data together with different collation on the remote server

VSTS BUG: 1428782 | 2876882
FIX: "Internal error: An unexpected error occurred" when you run a Process command against the TFS SSAS cube

VSTS BUG: 1457677 | 2877100
FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012

VSTS BUG: 1435963 | 2877857
FIX: "The OLE DB provider ‘<ProviderName>’ provided invalid collation" when you execute distributed queries through a linked server in SQL Server 2012 SP1

VSTS BUG: 1436162 | 2878139
FIX: "Using ‘dbghelp.dll’ version ‘4.0.5’" error is logged in SQL Server 2012 when a statement or job executes the sys.fn_xe_file_target_read_file stored procedure

VSTS BUG: 1403970 | 2878975
FIX: Access violation when you run a query that uses the "change_tracking_current_version()" function in SQL Server 2012

VSTS BUG: 1402400 | 2879619
FIX: Date data is incorrect when you export an SSRS report that references a date that is earlier than March 1, 1900 as an Excel worksheet

VSTS BUG: 1428185 | 2880071
FIX: Error messages when you perform ProcessRecalc operation after the ProcessData operation on an SSAS 2012 tabular model

VSTS BUG: 1328807 | 2880094
FIX: Grand total or subtotal rows display incorrect result in a Power View report that runs against a multidimensional cube in SSAS 2012

VSTS BUG: 1402434 | 2884124
FIX: "Type mismatch" error when you run an MDX query that uses the Member.Name property against an SSAS 2012 database

VSTS BUG: 1387645 | 2884126
FIX: "RESTORE DATABASE is terminating abnormally" error when you restore the secondary database in SQL Server 2012

VSTS BUG: 21593 | 2886673
FIX: Incorrect returned value when you run an MDX query that contains a filter on a parent/child dimension in SSAS 2012

 

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

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Parallel Data Warehouse
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Business Intelligence
     

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 6

You may have to restart the computer after you apply this cumulative update.

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

  • SQL Server 2012 | x86 | 2012_SP1_PPExcel_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x86 | 2012_SP1_DAC_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x86 | SQLServer2012_SP1_CU6_2874879_11_0_3381_x86
  • SQL Server 2012 | x64 | 2012_SP1_DAC_CU6_2874879_11_0_3381_x64
  • SQL Server 2012 | x64 | SQLServer2012_SP1_CU6_2874879_11_0_3381_x64
  • SQL Server 2012 | x64 | 2012_SP1_PPExcel_CU6_2874879_11_0_3381_x64

Enjoy!