KB3208177 - Cumulative Update 1 for SQL Server 2016 SP1

Release Date:   January 18, 2017
Version:   13.0.4411.0

This article describes cumulative update package 1 (build number: 13.0.4411.0) for Microsoft SQL Server 2016 Service Pack 1 (SP1). This update contains fixes that were released after the release of SQL Server 2016 SP1.

Improvements and fixes included in this update

Bug reference Description Fix area
8198025 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS (KB3025408) Analysis Services
8808992 FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state (KB3209426) Analysis Services
8986617 FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly (KB3209520) Analysis Services
9078847 FIX: The SAMEPERIODLASTYEAR function doesn't work in DAX queries in SQL Server 2016 Analysis Services (KB3213709) Analysis Services
9097248 FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members (KB3198827) Analysis Services
9097254 FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS (KB3183686) Analysis Services
9097256 FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services (KB3198826) Analysis Services
9098040 FIX: SSAS may crash on query execution if a predefined role is specified in the connection string (KB3212916) Analysis Services
9099937 FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services (KB3208178) Analysis Services
9100068 FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode (KB3211605) Analysis Services
9100261 FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services (KB3198356) Analysis Services
9098036 FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks (KB3206912) Analysis Services
9100139 FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase (KB3212541) Analysis Services
8997069 FIX: 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 (KB3210699) High Availability
9126113 FIX: DMV sys.dm_hadr_availability_replica_states returns an incorrect synchronization health state for a distributed availability group (KB3213288) High Availability
9148639 FIX: An Always On secondary replica goes into a disconnecting state (KB3213703) High Availability
9076276 FIX: Out of memory occurs when you use long Hekaton transactions in SQL Server 2016 (KB3206401) In-Memory OLTP
9076281 FIX: SQL Server runs out of memory when you query data from memory-optimized tables if Resource Governor is enabled (KB3209878) In-Memory OLTP
8197984 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 (KB3164404) Integration Services
8500828 FIX: SQL Server 2016 Database Mail causes high CPU usage after many email messages are sent (KB3197879) Management Tools
9012612 FIX: Errors when you try to save MDS business rules in SQL Server 2016 (KB3210087) Master Data Services (MDS)
9012711 FIX: Can't save a business rule when the condition and action refer to different parent entities in SQL Server 2016 Master Data Services (KB3188151) MDS
9133096 FIX: MDS business rule doesn't trigger on an attribute value change if the attribute belongs to a change tracking group (KB3213778) MDS
8197975 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server (KB3161403) Reporting Services
8835366 FIX: "Adjust height to fit zone" setting of the SSRS 2016 Report Viewer Web Part isn't respected on a SharePoint webpage (KB3211948) Reporting Services
8981777 FIX: Fail to view report with Edge or Chrome when you use a blank space parameter on SSRS 2016 (KB3211641) Reporting Services
9049062 FIX: List view layout of the SSRS 2016 web portal reverts to Tiles view layout in Google Chrome when the page is refreshed (KB3211990) Reporting Services
9049360 FIX: SQL Server 2016 Reporting Services mobile reports can't be rendered in your browser through Active Directory Application Proxy (KB3211991) Reporting Services
9085786 FIX: Text box is missing when the toggle action is enabled in SSRS 2016 (KB3213524) Reporting Services
8668206 FIX: Parameter values aren't contained in the URL when the parameter is used multiple times in a drillthrough custom URL (KB3212252) Reporting Services
9049060 FIX: Can't save a subscription when you browse to SSRS 2016 web portal by using Internet Explorer (KB3213496) Reporting Services
9071649 FIX: KPIs bound to a dataset together with parameters aren't updated during cache refresh (KB3211220) Reporting Services
8198028 An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 or 2016 (KB3178526) SQL connectivity
8918532 Enable out of row (offrow) insert for bcp invoked during replication process to fix problems when reinitializing replication configured with re-publisher. SQL Engine
9071520 This fix allows customers to change service accounts of Polybase engine and Polybase data movement service without uninstalling the services. SQL Engine
8198022 Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server (KB3175883) SQL performance
8987408 FIX: Automatic update of statistics feature doesn't run after you truncate a table that has a clustered columnstore index (KB3210652) SQL performance
8103261 Update introduces CREATE OR ALTER Transact-SQL statement in SQL Server 2016 (KB3190548) SQL service
8812307 FIX: An assertion occurs when you bulk insert data into a table from multiple connections in SQL Server 2016 (KB3205964) SQL service
8977749 FIX: DMV sys.dm_os_spinlock_stats returns incorrect results after you install SQL Server 2016 RTM CU2 (KB3208460) SQL service
8977751 FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server 2014 or 2016 (KB3201865) SQL service
8977752 FIX: SQL Server crashes when you execute a spatial data query that has been compiled in SQL Server 2016 (KB3212789) SQL service
8999706 FIX: A dump file is generated when you enable system-versioning on a table in SQL Server 2016 (KB3210395) SQL service
8999707 FIX: An access violation occurs when you execute DBCC CHECKDB on a database in SQL Server 2016 (KB3212482) SQL service
8999708 FIX: Error when you create a stored procedure that uses a synonym together with an index hint in SQL Server 2016 (KB13213263) SQL service
9000017 FIX: 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 (KB3212723) SQL service
9008442 FIX: The "sys.dm_db_column_store_row_group_physical_stats" query runs slowly on SQL Server 2016 (KB3210747) SQL service
9049063 FIX: SQL Server crashes when you execute the OPENJSON function in a contained database in SQL Server 2016 (KB3210597) SQL service
9056673 FIX: Can't install SQL Server R Services during an offline installation of SQL Server 2016 updates (KB3210708) SQL service
9069486 FIX: Latch Contention may occur on execution of parallel queries on database that has Snapshot Isolation enabled in SQL Server 2016 (KB3211646) SQL service
9069858 FIX: Can't execute the DBCC CLONEDATABASE command on an instance of SQL Server 2016 SP1 after an in-place upgrade (KB3212214) SQL service
9071302 FIX: A memory leak occurs when SQL Server procedure cache consumes too much memory (KB3212523) SQL service
9092558 FIX: An assert error occurs when you insert data into a memory-optimized table that contains a clustered columnstore index in SQL Server 2016 (KB3211338) SQL service
9128313 FIX: Kernel crash when you create a database after you drop a database that contains FILESTEAM data in SQL Server 2016 (KB3213291) SQL service
9136777 FIX: Error 3628 when you create or rebuild a columnstore index in SQL Server 2016 (KB3213283) SQL service

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:

Download the latest cumulative update package for SQL Server 2016 SP1 now

If the download page doesn't 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.

Notes for this update

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 SP1 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 might 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.

Note

After you apply this update, Database Mail does not work on computers that do not have the .NET Framework 3.5 installed. Microsoft is currently working on addressing this in a future cumulative update. See the following KB article for more information about affected builds and suggested workarounds:

FIX: SQL Server 2016 Database Mail does not work on a computer that does not have the .NET Framework 3.5 installed

Hybrid environments deployment

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

Language support
  • SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package isn't specific to one language. It applies to all supported languages.
  • The "Download the latest cumulative update package for Microsoft SQL Server 2014 now" form displays the languages for which the update package is available. If you don't see your language, that's because a cumulative update package isn't available specifically for that language and the ENU download applies to all languages.
Components updated

One cumulative update package includes all the component packages. However, the cumulative update package updates only those components that are installed on the system.

Support for this update

If other issues occur, or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and to issues that don't qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers, or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

To do this, follow these steps:

  1. In Control Panel, select Add or Remove Programs.

    Note

    If you are running Windows 7 or a later version, select Programs and Features in Control Panel.

  2. Locate the entry that corresponds to this cumulative update package.

  3. Press and hold (or right-click) the entry, and then select Uninstall.

Cumulative update package information

Prerequisites

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

Restart information

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

Registry information

To use one of the hotfixes in this package, you don't have to make any changes to the registry.

File information

Cumulative update package file information

This cumulative update package might not contain all the files that you must have to fully update a product to the latest build. This package contains only the files that you must have to correct the issues that are listed in this article.

The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it's converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86-based versions

SQL Server 2016 Browser Service

File name File version File size Date Time Platform
Msmdsrv.rll 2015.130.4001.0 1296576 29-Oct-16 05:18 x86
Msmdsrvi.rll 2015.130.4001.0 1293512 29-Oct-16 05:18 x86
Sqlbrowser_keyfile.dll 2015.130.4001.0 88776 29-Oct-16 05:19 x86

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.sqlserver.edition.dll 13.0.4411.0 37056 07-Jan-17 01:14 x86
Microsoft.sqlserver.instapi.dll 13.0.4411.0 46280 07-Jan-17 01:14 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4411.0 72904 07-Jan-17 01:14 x86
Pbsvcacctsync.dll 2015.130.4411.0 60104 07-Jan-17 01:13 x86
Sql_common_core_keyfile.dll 2015.130.4411.0 88776 07-Jan-17 01:15 x86
Sqlmgmprovider.dll 2015.130.4411.0 364232 07-Jan-17 01:13 x86
Sqlsvcsync.dll 2015.130.4411.0 267464 07-Jan-17 01:13 x86
Sqltdiagn.dll 2015.130.4411.0 60616 07-Jan-17 01:13 x86
Svrenumapi130.dll 2015.130.4411.0 854216 07-Jan-17 01:13 x86

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.infra.dll 13.0.4411.0 1876680 07-Jan-17 01:14 x86

SQL Server 2016 sql_tools_extensions

File name File version File size Date Time Platform
Microsoft.analysisservices.project.dll 2015.130.4411.0 2023104 07-Jan-17 01:52 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4411.0 433864 07-Jan-17 01:15 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4411.0 2044104 07-Jan-17 01:15 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4411.0 33480 07-Jan-17 01:15 x86
Microsoft.sqlserver.deployment.dll 13.0.4411.0 249544 07-Jan-17 01:14 x86
Msmgdsrv.dll 2015.130.4411.0 6507720 07-Jan-17 01:14 x86
Sql_tools_extensions_keyfile.dll 2015.130.4411.0 88776 07-Jan-17 01:15 x86
Xmsrv.dll 2015.130.4411.0 32715456 07-Jan-17 01:13 x86

x64-based versions

SQL Server 2016 Browser Service

File name File version File size Date Time Platform
Keyfile.dll 2015.130.4001.0 88776 29-Oct-16 05:19 x86
Msmdsrv.rll 2015.130.4001.0 1296576 29-Oct-16 05:18 x86
Msmdsrvi.rll 2015.130.4001.0 1293512 29-Oct-16 05:18 x86

SQL Server 2016 Business Intelligence Development Studio

File name File version File size Date Time Platform
Sqlsqm_keyfile.dll 2015.130.4001.0 100544 29-Oct-16 05:20 x64

SQL Server 2016 Writer

File name File version File size Date Time Platform
Sqlwriter_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64

SQL Server 2016 Analysis Services

File name File version File size Date Time Platform
Msmdsrv.exe 2015.130.4411.0 56699584 07-Jan-17 01:53 x64
Msmgdsrv.dll 2015.130.4411.0 7507144 07-Jan-17 01:14 x64
Msmgdsrv.dll 2015.130.4411.0 6507720 07-Jan-17 01:14 x86
Sql_as_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Sqlceip.exe 13.0.4411.0 246984 07-Jan-17 01:13 x86
Tmapi.dll 2015.130.4411.0 4346056 07-Jan-17 01:13 x64
Tmcachemgr.dll 2015.130.4411.0 2825928 07-Jan-17 01:13 x64
Tmpersistence.dll 2015.130.4411.0 1071304 07-Jan-17 01:13 x64
Tmtransactions.dll 2015.130.4411.0 1351360 07-Jan-17 01:13 x64
Xmsrv.dll 2015.130.4411.0 32715456 07-Jan-17 01:13 x86
Xmsrv.dll 2015.130.4411.0 24038600 07-Jan-17 01:13 x64

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.sqlserver.edition.dll 13.0.4411.0 37056 07-Jan-17 01:14 x86
Microsoft.sqlserver.instapi.dll 13.0.4411.0 46280 07-Jan-17 01:14 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4411.0 72904 07-Jan-17 01:14 x86
Microsoft.sqlserver.mgdsqldumper.dll 2015.130.4411.0 75456 07-Jan-17 01:53 x64
Pbsvcacctsync.dll 2015.130.4411.0 60104 07-Jan-17 01:13 x86
Pbsvcacctsync.dll 2015.130.4411.0 72904 07-Jan-17 01:15 x64
Sql_common_core_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Sqlmgmprovider.dll 2015.130.4411.0 404168 07-Jan-17 01:13 x64
Sqlmgmprovider.dll 2015.130.4411.0 364232 07-Jan-17 01:13 x86
Sqlsvcsync.dll 2015.130.4411.0 349384 07-Jan-17 01:13 x64
Sqlsvcsync.dll 2015.130.4411.0 267464 07-Jan-17 01:13 x86
Sqltdiagn.dll 2015.130.4411.0 67784 07-Jan-17 01:13 x64
Sqltdiagn.dll 2015.130.4411.0 60616 07-Jan-17 01:13 x86
Svrenumapi130.dll 2015.130.4411.0 1115848 07-Jan-17 01:13 x64
Svrenumapi130.dll 2015.130.4411.0 854216 07-Jan-17 01:13 x86

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.infra.dll 13.0.4411.0 1876680 07-Jan-17 01:13 x86
Microsoft.ssdqs.infra.dll 13.0.4411.0 1876680 07-Jan-17 01:14 x86

SQL Server 2016 Database Services Core Instance

File name File version File size Date Time Platform
Databasemail.exe 13.0.16100.4 29888 09-Dec-16 00:46 x64
Microsoft.sqlserver.types.dll 2015.130.4411.0 391872 07-Jan-17 01:53 x86
Qds.dll 2015.130.4411.0 843976 07-Jan-17 01:15 x64
Sql_engine_core_inst_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Sqlaccess.dll 2015.130.4411.0 461504 07-Jan-17 01:53 x64
Sqlagent.exe 2015.130.4411.0 565952 07-Jan-17 01:53 x64
Sqlceip.exe 13.0.4411.0 246984 07-Jan-17 01:13 x86
Sqldk.dll 2015.130.4411.0 2585800 07-Jan-17 01:15 x64
Sqllang.dll 2015.130.4411.0 39355592 07-Jan-17 01:15 x64
Sqlmin.dll 2015.130.4411.0 37569224 07-Jan-17 01:13 x64
Sqlos.dll 2015.130.4411.0 26304 07-Jan-17 01:51 x64
Sqlservr.exe 2015.130.4411.0 392896 07-Jan-17 01:53 x64
Sqltses.dll 2015.130.4411.0 8896712 07-Jan-17 01:13 x64
Stretchcodegen.exe 13.0.4411.0 56008 07-Jan-17 01:13 x86

SQL Server 2016 Database Services Core Shared

File name File version File size Date Time Platform
Microsoft.sqlserver.integrationservice.hadoopconnections.ui.dll 13.0.4411.0 70856 07-Jan-17 01:13 x86
Sql_engine_core_shared_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64

SQL Server 2016 sql_extensibility

File name File version File size Date Time Platform
Launchpad.exe 2015.130.4411.0 1015496 07-Jan-17 01:15 x64
Sql_extensibility_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Sqlsatellite.dll 2015.130.4411.0 837312 07-Jan-17 01:51 x64

SQL Server 2016 Full-Text Engine

File name File version File size Date Time Platform
Sql_fulltext_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64

SQL Server 2016 sql_inst_mr

File name File version File size Date Time Platform
Imrdll.dll 13.0.4411.0 23752 07-Jan-17 01:13 x86
Sql_inst_mr_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64

SQL Server 2016 Integration Services

File name File version File size Date Time Platform
Msdtssrvr.exe 13.0.4411.0 216776 07-Jan-17 01:13 x64
Sql_is_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Sqlceip.exe 13.0.4411.0 246984 07-Jan-17 01:13 x86

SQL Server 2016 Reporting Services

File name File version File size Date Time Platform
Microsoft.reportingservices.datarendering.dll 13.0.4411.0 166080 07-Jan-17 01:14 x86
Microsoft.reportingservices.diagnostics.dll 13.0.4411.0 1621184 07-Jan-17 01:14 x86
Microsoft.reportingservices.htmlrendering.dll 13.0.4411.0 1069768 07-Jan-17 01:14 x86
Microsoft.reportingservices.portal.interfaces.dll 13.0.4411.0 125128 07-Jan-17 01:14 x86
Microsoft.reportingservices.portal.services.dll 13.0.4411.0 4920000 07-Jan-17 01:14 x86
Microsoft.reportingservices.portal.web.dll 13.0.4411.0 10416328 07-Jan-17 01:14 x86
Microsoft.sqlserver.types.dll 2015.130.4411.0 396992 07-Jan-17 01:52 x86
Microsoft.sqlserver.types.dll 2015.130.4411.0 391872 07-Jan-17 01:53 x86
Msmgdsrv.dll 2015.130.4411.0 7507144 07-Jan-17 01:14 x64
Msmgdsrv.dll 2015.130.4411.0 6507720 07-Jan-17 01:14 x86
Reportingserviceslibrary.dll 13.0.4411.0 2521792 07-Jan-17 01:14 x86
Reportingservicesnativeclient.dll 2015.130.4411.0 114376 07-Jan-17 01:13 x86
Reportingservicesnativeclient.dll 2015.130.4411.0 108744 07-Jan-17 01:14 x64
Reportingservicesnativeserver.dll 2015.130.4411.0 99008 07-Jan-17 01:14 x64
Reportingserviceswebserver.dll 13.0.4411.0 2706632 07-Jan-17 01:14 x86
Sql_rs_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Xmsrv.dll 2015.130.4411.0 32715456 07-Jan-17 01:13 x86
Xmsrv.dll 2015.130.4411.0 24038600 07-Jan-17 01:13 x64

SQL Server 2016 sql_shared_mr

File name File version File size Date Time Platform
Smrdll.dll 13.0.4411.0 23752 07-Jan-17 01:14 x86
Sql_engine_core_shared_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64

SQL Server 2016 sql_tools_extensions

File name File version File size Date Time Platform
Microsoft.analysisservices.project.dll 2015.130.4411.0 2023104 07-Jan-17 01:52 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4411.0 433864 07-Jan-17 01:13 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.4411.0 433864 07-Jan-17 01:15 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4411.0 2044104 07-Jan-17 01:13 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.4411.0 2044104 07-Jan-17 01:15 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4411.0 33480 07-Jan-17 01:13 x86
Microsoft.sqlserver.configuration.sstring.dll 13.0.4411.0 33480 07-Jan-17 01:15 x86
Microsoft.sqlserver.deployment.dll 13.0.4411.0 249544 07-Jan-17 01:13 x86
Microsoft.sqlserver.deployment.dll 13.0.4411.0 249544 07-Jan-17 01:14 x86
Msmgdsrv.dll 2015.130.4411.0 7507144 07-Jan-17 01:14 x64
Msmgdsrv.dll 2015.130.4411.0 6507720 07-Jan-17 01:14 x86
Sql_tools_extensions_keyfile.dll 2015.130.4411.0 100552 07-Jan-17 01:15 x64
Xmsrv.dll 2015.130.4411.0 32715456 07-Jan-17 01:13 x86
Xmsrv.dll 2015.130.4411.0 24038600 07-Jan-17 01:13 x64

References