Cumulative Update 1 for SQL Server 2017

Applies to: SQL Server 2017 on Windows (all editions)SQL Server 2017 on Linux (all editions)

This article describes cumulative update package 1 (build number: 14.0.3006.16) for SQL Server 2017. This update contains fixes that were released after the release of SQL Server 2017.

Cumulative update

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

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

CU packages for Linux are available at https://packages.microsoft.com/.

Notes

  • Each new CU contains all the fixes that were included with the previous CU for the installed version of SQL Server.
  • SQL Server CUs are certified to the same levels as Service Packs, and they should be installed at the same level of confidence.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:
     
    • 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.
  • We recommend that you test CUs before you deploy them to production environments.

How to obtain this CU package for Windows


The following Windows 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 2017, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

How to obtain this CU package for Linux


To update Linux to the latest CU, you must first have the Cumulative Update repository configured. Then, update your SQL Server packages by using the appropriate platform-specific update command.

For installation instructions and direct links to the CU package downloads, see the Release notes.

Hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area Platform
10868749 4040401 FIX: Access violation for spatial datatypes query via linked server in SQL Server 2014 or 2017 SQL Engine All
10936183 4039868 FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 or 2017 In-Memory OLTP All
10749795 4043455 FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 SQL Engine Linux
10966016 4039736 FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions SQL Engine All
10889338 4042885 FIX: A divide-by-zero error occurs when a parallel query is forced to run in a serial mode in SQL Server 2017 SQL performance All
10868777 3208545 FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation Analysis Services All
10867554 4043459 FIX: Remote instance of SQL Server crashes while executing a stored procedure that bulk loads an incomplete data file into a temporary table SQL Engine All
10965980 4042251 FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 or 2017 High Availability All
10729322 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Reporting Services All
10691460 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server 2016 or 2017 SQL Engine All
10865727 4024393 FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 or 2017 SQL Engine All
10868736 4022483 FIX: Error when you export a DQS knowledge base that contains domains in the DQS client in SQL Server 2014 or 2017 Data Quality Services (DQS) All
10936185 4039776 FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 or 2017 In-Memory OLTP All
10965958 4034789 FIX: An unexpected exception error occurs when a XIRR measure processes too many records in SSAS 2016 or 2017 Analysis Services All
10966015 4038590 FIX: SSIS package that contains German umlauts characters fails on execution after Incremental Package Deployment in SQL Server 2016 or 2017 Integration Services All
10868739 4039509 FIX: SSAS crashes when you process an SSAS database or cube in SQL Server 2014 or 2017 Analysis Services All
10965984 4039966 FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 or 2017 SQL Engine All
10868733 4040376 FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server 2014 or 2017 SQL Engine All
10965994 4043478 FIX: Error when you export an SSRS report on an iOS device in SQL Server 2016 or 2017 Reporting Services All
10921835 4046065 FIX: Memory corruption occurs during availability group failovers for DTC transactions in SQL Server 2017 High Availability All
11003299 4046055 FIX: FORCE_LAST_GOOD_PLAN recommendation is stuck in "Verifying" state upon first verification in SQL Server 2017 SQL Engine All
10868755 4040512 FIX: An error occurs when you export a Reporting Services report to PDF in SQL Server 2017 Reporting Services All
10978904 4043624 FIX: Change Tracking manual cleanup fails with table non-existence error in SQL Server 2014 and 2017 SQL Engine All
10965952 4024860 Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 or 2017 SQL Engine All
10868723 4038882 FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server 2014 or 2017 SQL Engine All
10965982 4039124 FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 or 2017 Reporting Services All
10965991 4040085 FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 or 2017 Analysis Services All
10965988 4040519 FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 or 2017 High Availability All
10965968 4040533 FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 or 2017 SQL Engine All
10691456 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server SQL Engine All
10966009 4038113 FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server 2016 or 2017 SQL performance All
10966008 4039058 FIX: Report Viewer Web Part does not allow a full vertical scrollbar after you set a specific web part height Reporting Services All
10965999 4039125 FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 Reporting Service Reporting Services All
10868768 4039510 FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server 2014 or 2017 XML All
10936411 4040276 FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 or 2017 SQL Engine All
10966010 4040530 FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 or 2017 Management Tools All
10966019 4040535 FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 or 2017 SQL Engine All
10985578 4045329 FIX: Error occurs on passing memory-optimized table into inline table-valued function when called from stored procedure in SQL Server 2017 In-Memory OLTP All
10986691 4045678 FIX: An unexpected error occurs when you use DReplay feature to replay a captured trace in SQL Server 2017 Management Tools All
10867553 4025020 FIX: SUSER_SNAME function returns different results between SQL Server 2014 and SQL Server 2016 SQL security All
10936097 4046066 FIX: SQL Server 2017 reports that all transactions are completed even though some transactions encounter failures while trying to commit High Availability All
11000432 4046099 FIX: An assertion error occurs within minutes or hours after you create a snapshot backup for a database that contains memory-optimized tables in SQL Server 2017 In-Memory OLTP All
10870647 4024622 FIX: Couldn't truncate a partition of the partitioned table if it contains an extended or XML index in SQL Server 2016 or 2017 SQL Engine All
10868754 4033789 FIX: A memory leak may occur when you perform Process Update operations in SSAS Analysis Services All
10936563 4039089 FIX: EXCEPTION_ACCESS_VIOLATION error when you execute the sys.sp_MScdc_capture_job stored procedure in SQL Server SQL Engine All
10965998 4039126 FIX: Horizontal scroll bar missing from Subscription page in SSRS 2016 or 2017 web portal Reporting Services All
10868726 4039511 FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server 2014 or 2017 SQL Engine All
10966001 4040531 FIX: Constraint violation error returned by the managed_backup.fn_available_backups function after you install the Cumulative Update 2 for SQL Server 2016 SP1 SQL Engine All
10938809 4044009 FIX: A deadlock condition occurs when you create a new database in SQL Server 2017 SQL Engine All
10867556 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server is also installed Data Quality Services (DQS) All
10936099 4045687 Update to enable SQL Server 2017 Express edition to act as a witness role in a database mirroring session High Availability All
10998673 4046044 FIX: Unable to install SQL Server 2017 when instance name/ID/installation path contains multi-byte characters Setup & Install All
11003402 4046022 FIX: Automatic tuning settings cannot be configured on ModelDB in SQL Server 2017 SQL Engine All
10682356 3212541 FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase Analysis Services All
10687745 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Analysis Services All
10070694 4019840 FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2017 and SQL Server 2016 SQL Engine All
10682343 4021994 FIX: SSAS crashes when a measure is added that refers to null values in Power BI Analysis Services All
10682338 4022594 FIX: Incorrect MDX query results if a table cross join is run on a table hierarchy member in SSAS Analysis Services All
10687757 4022753 FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Analysis Services All
10687776 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server 2017 MDS and SQL Server 2016 MDS Data Quality Services (DQS) All
10687780 4023995 FIX: A data mask on a floating points column is not applied in SQL Server 2017 and SQL Server 2016 SQL Engine All
10682349 4024023 FIX: SSAS crashes when you access .vmp files in SQL Server 2017 and SQL Server 2016 Analysis Services All
10687784 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2017 and SQL Server 2016 Analysis Services All
10682367 4032543 FIX: SSAS crashes when you run a DAX or MDX query in SSAS in Tabular mode Analysis Services All
10682313 4043103 FIX: Load data from staging tables takes a much longer time to finish when recursive hierarchy is used in Master Data Services Data Quality Services (DQS) All
11008122 4046638 Update to enable the new dynamic management views and functions in SQL Server 2017 SQL Engine All
10998915 4046744 FIX: DML statements that use cascading operations fail in SQL Server 2017 SQL Engine All
10982548 4046918 FIX: Execution fails when a SQL CLR function invokes Transact-SQL statements through impersonation calls in SQL Server 2017 SQL security All
10270905 4040108 FIX: Backup of availability database via VSS-based application may fail in SQL Server SQL service All
9704947 4039284 Enhancement: New keyword is added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server SQL Engine All
11080104 4052938 

FIX: DST changes of Sao Paulo time zone are not determined by SQL Server 2017 on Linux

SQL Engine Linux

 

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:
 

 

Cumulative update package information


Prerequisites

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

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.