Cumulative Update 1 for SQL Server 2016

This article describes cumulative update package 1 (build number: 13.0.2149.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
77211623170082FIX: Permission issue or failure occurs when you upgrade to SQL Server 2016 Master Data Services Master Data Services (MDS)
77008503170071SQL Server 2016 cannot send diagnostics information for MDS web application and MDS Add-in for Excel MDS
77617753170293The Product Update feature does not update SQL Server Setup support files during a slipstreamed installation for a non-English version of SQL Server 2016 Setup & Install
77211613170081A deadlock condition occurs when you run certain operations in parallel in SQL Server 2016 Master Data Services MDS
77118783169921Update to fix layout issues in SQL Server 2016 Reporting Services (SSRS) web portal Reporting Services
77356273170077FIX: JavaScript error when you create a MDS subscription view in SQL Server 2016 MDS
77008483170083FIX: Exception occurs when you associate an availability database with MDS web application in SQL Server 2016 MDS
77052613170140Adds the adjusted buffer size to the BufferSizeTuning event when AutoAdjustBufferSize is enabled in SSIS 2016 Integration Services
77006043170076FIX: Data loss when you run the udpConvertCollectionAndConsolidatedMembersToLeaf stored procedure in SQL Server 2016 MDS MDS
77356253170085Domain-based attributes created by MDS Add-in for Excel is not available for Business Rules Extension feature in SQL Server 2016 MDS
77052243170079FIX: Permission issues when you use SQL Server 2016 Master Data Services MDS
77211633170078Cannot create a MDS website by using a low-privilege account in SQL Server 2016 MDS
76878723170145FIX: SSIS package doesn't run when you call it from executable files outside the DTS\Binn folder in SQL Server 2016 Integration Services
77052233170084FIX: Can't insert the value NULL into column "ArgumentScript" when you apply a business rule in SQL Server 2016 MDS MDS
76878613170132FIX: Error 7330 when query the view that is created by the Data Feed Publishing Wizard in SQL Server 2016 Integration Services
77234733170359Improvements and fixes for SSRS 2016 mobile report Reporting Services
77211583170068An unhandled exception occurs after a filter is applied on an attribute in SQL Server 2016 Master Data Services MDS
77356213170074FIX: Unexpected exception occurs when deploying a package using SQL Server 2016 MDSModelDeploy tool MDS
77356263170214FIX: Can't generate an SSIS package when you use SQL Server Import and Export Wizard in SQL Server 2016 Integration Services
77118763169922Cannot create a new subscription for a report that contains Unicode characters in SQL Server 2016 Reporting Services web portal Reporting Services
76933433170142Buffer size is not set correctly when the data flow engine handles blob data when AutoAdjustBufferSize is enabled in SQL Server Data Tools in Visual Studio 2015 Integration Services
77118753169923Fixes some issues about assistive technology tools in SSRS 2016 Reporting Services
77356223170075The Add Annotation button is disabled for the current member version in MDS Explorer MDS
76933803170061An unhandled exception occurs when you reopen a saved workbook that contains MDS entities in SQL Server 2016 MDS
77008513170080Slow performance occurs when SQL Server 2016 Master Data Services is used for operations on large MDS databases MDS
77118743170528The "BackgroundColor" property is not respected when it is specified by an expression in SQL Server 2016 Reporting Services Reporting Services
78067753174073FIX: All data goes to deltastores when you bulk load data into a clustered columnstore index under memory pressure SQL service
77503513171882FIX: SSMS can't save maintenance plans when you connect to an instance of SQL Server 2008 R2 or earlier versions Integration Services
77109453172960FIX: Online index operations block DML operations when the database contains a clustered columnstore index SQL service
77955853173841A data flush task may cause a deadlock condition when queries are executed on a memory-optimized table in SQL Server 2016 SQL service
78188563174684FIX: SQL Server 2016 uses all available memory and crashes when it runs a query that contains HASHBYTES functions SQL performance
72842753145492FIX: XA transactions aren't cleaned when you exit a Java application in an instance of SQL Server SQL service
78015723174829FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016 SQL service
77356313175203FIX: ShortestLineTo() and STDistance() methods return incorrect result for the shortest distance in SQL Server 2016 SQL service
7779870 3171505FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain SQL service
77715343173004Data loss or incorrect results occur when you use the sp_settriggerorder stored procedure in SQL Server 2016 In-Memory OLTP
78015713173038Performance issues occur when use the sys.dm_hadr_availability_replica_states DMV on an AlwaysOn Availability Group that contains many databases in SQL Server 2016 High Availability
77798573173976FIX: Fatal Error when you run a query against the sys.sysindexes view in SQL Server 2016 In-Memory OLTP
78062683174436FIX: Failed execution of ALTER AUDIT statement causes SQL Server to crash in SQL Server 2016 SQL service
76992273167175FIX: The "Select All" check box doesn't work in the subscriptions page in SSRS 2016 Reporting Services
77715333171480FIX: Can't retrieve favorite KPIs or mobile reports in Power BI Mobile app or GetCatalogItem API in SQL Server 2016 Reporting Services
78015543172787FIX: Can't disable batch mode sorted by session trace flag 9347 or the query hint QUERYTRACEON 9347 in SQL Server 2016 SQL performance
77955863174708A memory leak occurs when DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table in SQL Server 2016 SQL service
77955913174713Data Flush Tasks of a memory-optimized temporal table may consume 100-percent CPU usage in SQL Server 2016 SQL service
75206183152377FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 or 2016 SQL service
77052253168571FIX: The SEEDING_MODE setting is ignored when you add an AlwaysOn AG replica to an existing AG in SQL Server 2016 High Availability
76946703168793FIX: Cannot create or delete a table or index when another DDL transaction is running on the same database in SQL Server 2016 SQL service
77052633171174Add error codes to diagnostics information for SSIS 2016 package execution failures Integration Services
77711443171544FIX: Error 8624 occurs when you run a query against a nonclustered columnstore index in SQL Server 2016 SQL service
77715373172671FIX: BULK INSERT or OPENROWSET import wrong data if UTF-8 encoded file does not have a BOM in SQL Server 2016 SQL service
78067783173436Behavior changes when you add uniqueidentifier columns in a clustered Columnstore Index in SQL Server 2016 SQL service
72907583156157Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available SQL performance
77503613171884FIX: Unexpected exception when you add more maintenance plan tasks for an instance of SQL Server 2012 in SSMS 2016 Integration Services
7837980 3174812FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016 SQL service
79401563178934Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) Analysis Services
75937743163924AUTOGROW_ALL_FILES and READ_ONLY aren't either updated by DDL or preserved after a database restarts in SQL Server 2016 SQL service
76992263167113Analysis Services may crash if the HeapTypeForObjects memory property is configured by a slot allocator in SQL Server 2016 Analysis Services
77054243168570An update is available to add FIPS compliant support in SQL Server 2016 SQL service
78015553174395FIX: sys.dm_external_script_execution_stats returns an incorrect counter_value in SQL Server 2016 SQL service
73376172953354FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server SQL service
77715303172974FIX: Incorrect number of rows in sys.partitions for a columnstore index in SQL Server 2016 SQL service
78057253173666The .NET Framework 3.5 is required when you configure SQL Server 2016 as a secondary in Transaction Log Shipping High Availability
77099183170996Creating or updating statistics takes a long time on a large memory-optimized table in SQL Server 2016 SQL service
77715293174433FIX: Error 10635 when you rebuild indexes online for tables that contain large object (LOB) columns in SQL Server 2016 SQL service
77955903174712A deadlock condition occurs when you make updates on a memory-optimized temporal table and you run the SWITCH PARTITION statement on a history table in SQL Server 2016 SQL service
76992553167434FIX: SSRS logs fill up the hard disk and agent jobs are not recreated after database migration in SQL Server 2016 Reporting Services
77717433171085A report configured to automatically refresh causes errors after the web browser idles for a while in SQL Server 2016 Reporting Services Reporting Services
77887723171489The Apply button on the Parameter Properties page is not localized in SQL Server 2016 Reporting Services web portal SQL service
77717453171532Drilling through from one mobile report to another does not respect the embed parameter specified in a URL in SQL Server 2016 Reporting Services Reporting Services
78243903173957FIX: Cannot install a non-English version of SQL Server 2016 on a Windows Server that is installed in Server Core mode Setup & Install
72906683136205FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server MDS
75148843160303FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 SQL performance
77717463171475FIX: Can't rename a catalog item with the same name in different case in SSRS 2016 Reporting Services
77709103172959FIX: Error 8061 when you use BULK INSERT on a table in SQL Server 2016 SQL service
78015583172981FIX: Home page of SSRS web portal becomes empty after you enable My Reports feature in SQL Server 2016 Reporting Services
78062563173065SQL Server 2016 generates a dump file when you execute an external script in parallel mode SQL service
78015653174393Windows Authentication doesn't work when you connect to SQL Server from R Script on SQL Server 2016 Express Edition SQL service
78317473175018Improves the installation process of the SQL Server R Services in SQL Server 2016 SQL service
76992463167174FIX: Subscriptions that are filtered out are still affected by the actions in SSRS 2016 Reporting Services
77220183168257Setup UI changes to English if a non-English version of SQL Server 2016 GDR update is installed using the Product Update feature Setup & Install
77602023171040"HTTP 503: Service unavailable" error message when you open the SSRS web portal after you upgrade to SSRS 2016 Reporting Services
77798583171863FIX: Secondary replica in "not healthy" state after you upgrade the primary database in SQL Server 2016 In-Memory OLTP
77617733173975FIX: Checkpoint files are missing from sys.dm_db_xtp_checkpoint_files on SQL Server 2016 In-Memory OLTP
77955843174669FIX: Infinite recompile occurs when querying a view that references the identity column of a system-versioned temporal table SQL service
78669963178297Query Store automatic data cleanup fails on editions other than Enterprise and Developer edition of SQL Server 2016 SQL service
77717443172732FIX: Column becomes empty when the VerticalAlign property is set to Middle or Bottom in SSRS 2016 Reporting Services
78015693172939FIX: Date picker on the SSRS 2016 web portal displays invalid characters if the web browser is set to non-English Reporting Services
77356283172973FIX: Assertion failure when you run UNION or UNION ALL clauses on a Row-Level Security enabled table in SQL Server 2016 SQL performance
78015613173043FIX: Wrong "schema_name" and "class_type" values for the CREATE SECURITY POLICY statement in SQL Server 2016 SQL security
78274023174088FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016 SQL service
77798683174788The Customer Experience Improvement Program is disabled after FIPS compliance is enabled in SQL Server 2016 SQL service
76937223025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
77234723171932FIX: Error message isn't localized completely when you use Tabular Model Scripting Language (TMSL) in SQL Server 2016 Analysis Services
77721333173087FIX: PolyBase feature doesn't install when you add a node to a SQL Server 2016 failover cluster SQL service
77798713173472SECURITY_CRYPTO_CONTEXT_MUTEX waits cause SQL Server 2016 to stop responding to client requests in SQL Server 2016 SQL security
78073023173779FIX: Can’t create a database with a used database name by using the Create or CreateOrReplace command in SQL Server 2016 Analysis Services
77099233168242FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode) Analysis Services
77617773171002SQL Server 2016 database log restore fails with the "Hk Recovery LSN is not NullLSN" error message In-Memory OLTP
77715353171467Can't pin an SSRS report to Power BI dashboards when you are not a member of any groups on PowerBI.com website Reporting Services
78313143174674The Full-Text Search feature does not always return the expected results in SQL Server 2016 SQL service
78015673174963FIX: Data loss when you alter column operation on a large memory-optimized table in SQL Server 2016 In-Memory OLTP
77955893174711SYSTEM_VERSIONING is not turned on for a table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled in SQL Server 2016 SQL service
72906493132062FIX: SMK initialization fails on one node of a SQL Server 2012, 2014, or 2016 failover cluster SQL security
76789483154226FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server SQL service
76943373160874FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition Analysis Services
72905653132058FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server SQL service
78015663173046FIX: Localized user interface of SSRS 2016 web portal doesn't work correctly in Internet Explorer and Microsoft Edge Reporting Services
72905823138321FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016 SQL performance
77118733168200FIX: Only one Boolean parameter can select default value when you have multiple Boolean parameters in SSRS 2016 Reporting Services
77118713171470SQL Server 2016 Reporting Services does not upload Service Quality Monitoring data collections Reporting Services
75206533147012FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads In-Memory OLTP
77118723171469Cannot open a SSRS paginated report from SQL Server 2016 Reporting Services web portal on an iPad Reporting Services
76789153152042FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Reporting Services
75206083115741FIX: "The process cannot access the file" error when an XML task fails in SQL Server Integration Services
75138813170999FIX: Heavy concurrent OLTP activity runs slowly when delayed durability is enabled in SQL Server 2016 SQL service
77617763171001FIX: Slow database recovery in SQL Server 2016 due to large log when you use In-Memory OLTP on a high-end computer In-Memory OLTP
77955873174710Audit record is missing when you turn on SYSTEM_VERSIONING for a table by using the ALTER TABLE statement in SQL Server 2016 SQL service
76004453164404FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
77709113171555Adds trace flag 9358 to disable batch mode sort operations in a complex parallel query in SQL Server 2016 SQL performance
79149313178137FIX: Potential loss of historical data when you alter an in-memory temporal table in SQL Server 2016 SQL service
72907273149128Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server 2012 or 2016 SQL security
76789763162396FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
73375063131443FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server SQL service
77356353175205FIX: Long query contains specific expressions receives syntax error if forced parameterization is enabled in SQL Server 2016 SQL service
76789343152596FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Reporting Services
72907543146123Query plan generation improvement for some columnstore queries in SQL Server 2014 or 2016 SQL performance
76943303155209FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 SQL service
72906863139489FIX: "A severe error occurred on the current command" when a Table-Valued User-Defined function is referred to by a synonym SQL service
72907443152135FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 or 2016 SQL performance
73374733123309FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server SQL service
78067773175478FIX: It takes a long time to compile a query and add it to the Query Store in SQL Server 2016 SQL service
78067743173784An unexpected error occurs when you execute a DAX query that contains variables in SQL Server 2016 Analysis Services Analysis Services
78015533174396FIX: Counters for job objects created by SQL Server Trusted Launchpad are not visible in Windows Performance Monitor SQL service
77798593171574Cannot capture the CommandBegin and CommandEnd events in a JSON-based statement script in SQL Server 2016 Analysis Services
76790113155503FIX: MERGE statement to sync tables is unsuccessful when change data capture is enabled in SQL Server 2012, 2014, or 2016 SQL service
75206303152378FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server SQL service
78067763173989FIX: Availability databases are not fully started after you restart the server instance of SQL Server 2016 High Availability
76789813152965FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server High Availability
77715313173781FIX: Unexpected exception when you make cross-appdomain TOM call in SQL Server 2016 Analysis Services
75206253150896FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server SQL service
74397003158710FIX: The ALTER SERVER CONFIGURATION with SET SOFTNUMA command does not work in SQL Server 2016 Setup & Install
77915313171759A query that accesses data in a columnstore index causes the Database Engine to receive a floating point exception in SQL Server 2016 SQL service
76790243160427FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
78115153174076FIX: Cannot query or migrate data from a local Stretch-enabled table after you execute sys.sp_rda_reconcile_batch SQL service
75206473146404FIX: Canceling a backup task crashes SQL Server 2014 or 2016 SQL service
78115753173471FIX: Error 3456 "Could not redo log record" occurs, causing replicas to be suspended or repeated behavior in SQL Server SQL service

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
Savybės

Straipsnio ID: 3164674 – Paskutinė peržiūra: 2017-01-06 – Peržiūra: 1

Atsiliepimai