Cumulative Update 4 for SQL Server 2016

This article describes cumulative update package 4 (build number: 13.0.2193.0) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

Cumulative update

Cumulative updates (CU) are now available at the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2016 is available at the Download Center.

  • Each new CU contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:



    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.

  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2016 service pack .

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:


If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note After future cumulative updates are released for SQL Server 2016, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

Hotfixes that are included in this cumulative update package


VSTS bug numberKB article numberDescriptionFix area
86837113205411FIX: "Non-yielding Scheduler" condition when you parallel-load data into a columnstore index in SQL Server 2016
SQL service
87880343201865FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server 
SQL service
89609403177238FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server 
High Availability
88406393204265FIX: Image maps in a SSRS custom report item are not rendered as expected
Reporting Services
87825183211602FIX: Cannot insert data into a table that uses a clustered columnstore index in SQL Server 2016
SQL performance
85247743212916FIX: SSAS may crash on query execution if a predefined role is specified in the connection string
Analysis Services
91261113213288FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group
High Availability
88507743115741FIX:"The process cannot access the file" error when an XML task fails in SQL Server
Integration Services
88508213197631FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server
SQL security
87989493202425Improvement: Improves the query performance for SQL Server 2016 by changing the use of histograms on UNIQUE columns
SQL performance
89316493210395FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016
SQL service
90000693209896Update to enable changing the PolyBase service accounts without reinstalling the PolyBase feature in SQL Server 2016
SQL service
88459183194959Statistics are removed after rebuilding a specific partition of an partitioned aligned index on a partitioned table in SQL Server
SQL performance
88508053188454Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server
SQL service
88461143184099SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy
SQL service
88508313194365FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking
SQL performance
89577703211605FIX: Error for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016
Analysis Services
89807663213263FIX: Error when create a stored procedure that uses a synonym together with an index hint in SQL Server 2016
SQL service
85311603197883FIX: Snapshot Agent fails when you publish UDF’s to SQL Server 2016 Distributor in Transactional Replication
Management Tools
88508373198826FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services
Analysis Services
89316503212482FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016
SQL service
89651283212789FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016
SQL service
89590453208178FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services
Analysis Services
89866243209520FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly
Analysis Services
91367653213283FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016
SQL service
88123023205964FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016
SQL service
88507673183686FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS
Analysis Services
90752483211646FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016
SQL service
90711523212523FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory
SQL service
90000143212723FIX: A query that contains a hint against a view that references at least one temporal table in a different database can generate a dump file in SQL Server 2016
SQL service
80589523209442FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server 2014 MDM report
Management Tools
89807673210597FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016
SQL service
89609433198261FIX: MDS business rule doesn't work if the Code value contains a leading space in SQL Server MDS Add-in for Excel
Master Data Services (MDS)
88459163191062FIX: FileTable directory stops responding when you create multiple files concurrently in SQL Server 2014 or 2016
SQL service
88461153195825FIX: Deadlock when you execute a query plan with a nested loop join in batch mode in SQL Server 2014 or 2016
SQL performance
88508343198827FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members
Analysis Services
84920613196012FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server 
SQL service
89185313206401FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016
In-Memory OLTP
89588323212541FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase
Analysis Services
89562833201416FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014
SQL service
88508623197950FIX: Error when you open Data Alert Manager in SQL Server 2014 or 2016 Reporting Services in SharePoint integrated mode
Reporting Services
90566543210708FIX: Cannot install SQL Server R Services during an offline installation of SQL Server 2016 updates
SQL service
89609493108537FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server
SQL service
86242053198356FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services
Analysis Services
85327673212227FIX: You can't run a data cleanse against a view in SQL Server 2016 Data Quality Services
MDS
91298033213291FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016
SQL service
90774973211338FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016
SQL service
85008313197879FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent
Management Tools
88507903181444FIX: Queries that run against secondary databases always get recompiled in SQL Server
High Availability
88507993180980Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected
Reporting Services
88888093203693“A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10
SQL service
87715183206584FIX: Checkpoint files grow excessively when you insert data into memory-optimized tables in SQL Server 2016
In-Memory OLTP
90084303209878FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled
In-Memory OLTP
88002133210699FIX: Error messages are logged if database mirroring is configured by Transact-SQL in SQL Server 2016 and no database activity occurs for more than 90 seconds
High Availability
90111623213683FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2016
SQL performance
89241633206912FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks
Analysis Services
89858933209426FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state
Analysis Services

Notes for this update

Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the hotfixes:

Language support
Components updated
Support for this update
How to uninstall this update

Cumulative update package information

Prerequisites

To apply this cumulative update package, you must be running SQL Server 2016.

Restart information

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

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Cumulative update package file information
Properties

Article ID: 3205052 - Last Review: 2017 urt. 17 - Revision: 23

Oharrak