[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 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!

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

Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server

An update to add new service tier and performance level to the "Import Data-tier Application…" wizard

An update to add an "Open in Management Portal" item to the context menu for SQL Azure database nodes in SSMS 2014

LOGO__SQLServer2014downloadNewest, hot and very fresh update for Microsoft SQL Server 2014 is ready and available for download. As with many previous Cumulative Updates for new systems (I observed similar stories for SQL Server 2012) this time Microsoft give us many updates. A lot of them are interesting, like three above.  In this Cumulative Update No 4 (build no 12.0.2430.0) vendor fixed almost sixty bugs for this platform. Here is the list of all:

VSTS BUG: 3260616 | KB: 2924996
FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server
Reporting Services

VSTS BUG: 2906081| KB: 2962767
FIX: "Cannot insert duplicate key" error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server
SQL performance

VSTS BUG: 2906084 | KB: 2963137
FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2578274 | KB: 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server
SQL service

VSTS BUG: 2906093 | KB: 2965069
FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2906103 | KB: 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTS BUG: 2906101 | KB: 2965922
FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013
BI Azure

VSTS BUG: 2906089 | KB: 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server
SQL service

VSTS BUG: 2906107 | KB: 2967594
FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server
SQL service

VSTS BUG: 2906117 | KB: 2970421
FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database
High Availability

VSTS BUG: 2906119 | KB: 2972411
FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 2906097 | KB: 2972463
FIX: Report cache is not cleaned up when you use SSRS 2012 or SSRS 2014 in SharePoint integrated mode
Reporting Services

VSTS BUG: 2906124 | KB: 2973921
FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS on SharePoint website
Reporting Services

VSTS BUG: 3260586 | KB: 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server
SQL service

VSTS BUG: 2627802 | KB: 2974169
FIX: Cannot recover the In-Memory OLTP database after you enable and then disable TDE on it in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2906154 | KB: 2974948
FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012 or SQL Server 2014
Management Tools

VSTS BUG: 2906091 | KB: 2975385
FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2906126 | KB: 2975498
FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file name
Reporting Services

VSTS BUG: 3260588 | KB: 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS
Analysis Services

VSTS BUG: 2906151 | KB: 2976172
FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS
Analysis Services

VSTS BUG: 2906149 | KB: 2976861
FIX: The time is longer and longer to perform process full on an SSAS 2012 or SSAS 2014 tabular model database
Analysis Services

VSTS BUG: 2906115 | KB: 2976953
FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012 or in SSAS 2014
Analysis Services

VSTS BUG: 2906135 | KB: 2979304
FIX: Error when you run RBS Maintainer in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2906153 | KB: 2980208
FIX: Permissions cannot be propagated to Subscriber in transaction replication when the Distributor is SQL Server
SQL service

VSTS BUG: 2906133 | KB: 2980395
FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server
SQL performance

VSTS BUG: 3260584 | KB: 2982544
FIX: Slow to access "Explorer" or "System Administration" on MDM home page
Data Quality Services (DQS)

VSTS BUG: 3260613 | KB: 2986627
FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server
SQL performance

VSTS BUG: 3260594 | KB: 2986722
FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server
SQL performance

VSTS BUG: 3260607 | KB: 2987809
FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11
Reporting Services

VSTS BUG: 3260596 | KB: 2987935
FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server
SQL service

VSTS BUG: 2942785 | KB: 2988166
FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server
Management Tools

VSTS BUG: 2906144 | KB: 2989002
FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014
Integration Services

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

VSTS BUG: 3260578 | KB: 2989512
FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model
Analysis Services

VSTS BUG: 3260603 | KB: 2989590
FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS
Analysis Services

VSTS BUG: 3260617 | KB: 2989810
FIX: Error in bcp_init when you do bulk copy with local temp table as input parameter in SQL Server Native Client 11.0
SQL service

VSTS BUG: 3260600 | KB: 2990152
FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server
Management Tools

VSTS BUG: 3260612 | KB: 2991526
FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from a URI
Integration Services

VSTS BUG: 3260614 | KB: 2992414
FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS
Integration Services

VSTS BUG: 2980091 | KB: 2993262
FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge join
SQL service

VSTS BUG: 3260618 | KB: 2993483
FIX: SSAS processing fails when you perform a Process Full operation on many partitions in a transaction
Analysis Services

VSTS BUG: 3260623 | KB: 2993529
FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 or SQL Server 2014 MDS
DQS

VSTS BUG: 2965748 | KB: 2996629
FIX: "String data, right truncation" error when you do bulk copy on DBCS by using ODBC Driver 11 in SQL Server 2014
SQL connectivity

VSTS BUG: 2952406 | KB: 2997763
FIX: Error 8646 when you run DML statement on a table with clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 3155459 | KB: 2998301
FIX: Error 8654 when you run "INSERT INTO … SELECT" on a table with clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 2976564 | KB: 2999308
FIX: Add detailed information to the "Call to Excel Services returned an error" error message in SQL Server 2014 PowerPivot
Analysis Services

VSTS BUG: 3079309 | KB: 3003023
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2014
SQL service

VSTS BUG: 3291193 | KB: 3003755
FIX: "SQL Server edition is not supported by MDS" error when you use MDS after you apply the CU3 for SQL Server 2014
DQS

VSTS BUG: 2976604 | KB: 3003760
FIX: Cannot remove the secondary filegroup after you upgrade the database to SQL Server 2014
SQL service

VSTS BUG: 3041753 | KB: 3003804
FIX: Error when you export data cleansing result with the "Data and Cleansing Info" option in SQL Server 2014 DQS
DQS

VSTS BUG: 3290528 | KB: 3004195
FIX: "sp_send_dbmail" stored procedure truncates email attachments to 64 KB in SQL Server 2014
Management Tools

VSTS BUG: 3395417 | KB: 3007873
FIX: An update to add an "Open in Management Portal" item to the context menu for SQL Azure database nodes in SSMS 2014
Management Tools

VSTS BUG: 3395360 | KB: 3007905
FIX: An update to the template script for creating SQL Azure database in SSMS 2014
Management Tools

VSTS BUG: 3403471 | KB: 3008282
FIX: An update to add new service tier and performance level to the "Import Data-tier Application…" wizard
Management Tools

 

This update could be applied to Microsoft SQL Server 2014 RTM and applies to

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
  • Microsoft SQL Server 2014 Business Intelligence
  • SQL Server 2014 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 4

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 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:

>> SQLServer2014_RTM_CU4_2999197_12_0_2430_x64
>> SQL2014_RTM_ODBC_CU4_2999197_12_0_2430_x64
>> SQL2014_RTM_ODBC_CU4_2999197_12_0_2430_x86
>> SQLServer2014_RTM_CU4_2999197_12_0_2430_x86

Enjoy!