KB4038634 - Cumulative Update 1 for SQL Server 2017

Summary

This article describes Cumulative Update package 1 (CU1) for SQL Server 2017. This update contains 71 fixes that are issued after the release of SQL Server 2017 RTM, and updates components to the following builds.

SQL Server - Product version: 14.0.3006.16, file version: 2017.140.3006.16
Analysis Services - Product version: 14.0.1.439, file version: 2017.140.1.439

Known issues with this update

There are no known issues with this cumulative update.

Improvements and fixes included in this cumulative update

A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2019 and SQL Server 2017. Click to download this Excel file now.

Note: Individual entries in the following table can be referenced directly via a bookmark. If you click on any bug reference ID in the table, you will notice that a bookmark tag is added to the URL using this format #bkmk_NNNNNNNN. You can then share this URL to others so they can directly jump to the desired fix in the table.

Bug reference	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

How to obtain or download this or latest cumulative update package

The following update is available from the Microsoft Download Center:

Download icon Download the latest cumulative update package for SQL Server 2017 now

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 and all previous CUs can be downloaded from the Microsoft Update Catalog. However, we recommend that you always install the latest cumulative update that is available.

The following update is available from the Microsoft Update Catalog:

Download icon Download the cumulative update package for SQL Server 2017 CU 1 now

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.

File information

You can verify the download by computing the hash of the SQLServer2017-KB4038634-x64.exe file via the following command:

certutil -hashfile SQLServer2017-KB4038634-x64.exe SHA256

File name	SHA256 hash
SQLServer2017-KB4038634-x64.exe	C1187BF68AC07294D8242C4126F021D3BEEF561F86931A8229B3D4AE86993A73

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 is 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.

x64-based versions

SQL Server 2017 Analysis Services

File name	File version	File size	Date	Time	Platform
Microsoft.analysisservices.server.core.dll	14.0.1.439	1380512	01-Oct-2017	22:06	x86
Microsoft.data.mashup.dll	2.49.4831.201	174816	01-Oct-2017	20:52	x86
Microsoft.data.mashup.oledb.dll	2.49.4831.201	36576	01-Oct-2017	20:52	x86
Microsoft.data.mashup.preview.dll	2.49.4831.201	48864	01-Oct-2017	20:52	x86
Microsoft.data.mashup.providercommon.dll	2.49.4831.201	105184	01-Oct-2017	20:52	x86
Microsoft.hostintegration.connectors.dll	2.49.4831.201	5167328	01-Oct-2017	20:52	x86
Microsoft.mashup.container.exe	2.49.4831.201	26336	01-Oct-2017	20:52	x64
Microsoft.mashup.container.netfx40.exe	2.49.4831.201	26848	01-Oct-2017	20:52	x64
Microsoft.mashup.container.netfx45.exe	2.49.4831.201	26848	19-Oct-2017	12:13	x64
Microsoft.mashup.eventsource.dll	2.49.4831.201	159456	01-Oct-2017	20:52	x86
Microsoft.mashup.oauth.dll	2.49.4831.201	82656	01-Oct-2017	20:52	x86
Microsoft.mashup.oledbprovider.dll	2.49.4831.201	67296	19-Oct-2017	12:13	x86
Microsoft.mashup.shims.dll	2.49.4831.201	25824	01-Oct-2017	20:52	x86
Microsoft.mashup.storage.xmlserializers.dll	1.0.0.0	151264	01-Oct-2017	20:52	x86
Microsoft.mashupengine.dll	2.49.4831.201	13032160	01-Oct-2017	20:52	x86
Microsoft.powerbi.adomdclient.dll	14.0.1.484	1044672	01-Oct-2017	20:52	x86
Msmdlocal.dll	2017.140.1.439	40357024	01-Oct-2017	22:06	x86
Msmdlocal.dll	2017.140.1.439	59898528	19-Oct-2017	12:22	x64
Msmdpump.dll	2017.140.1.439	8544416	19-Oct-2017	12:22	x64
Msmdsrv.exe	2017.140.1.439	60589352	01-Oct-2017	22:07	x64
Msmgdsrv.dll	2017.140.1.439	8208544	01-Oct-2017	22:07	x64
Msmgdsrv.dll	2017.140.1.439	7310496	19-Oct-2017	12:15	x86
Powerbiextensions.dll	2.49.4831.201	5316832	01-Oct-2017	20:52	x64
Sql_as_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlboot.dll	2017.140.3006.16	194720	19-Oct-2017	11:08	x64
Sqlceip.exe	14.0.3006.16	249504	19-Oct-2017	12:18	x86

SQL Server 2017 Database Services Common Core

File name	File version	File size	Date	Time	Platform
Microsoft.analysisservices.adomdclient.dll	14.0.1.439	1088672	01-Oct-2017	22:04	x86
Microsoft.analysisservices.adomdclient.dll	14.0.1.439	1088672	01-Oct-2017	22:06	x86
Microsoft.analysisservices.core.dll	14.0.1.439	1380648	01-Oct-2017	22:04	x86
Microsoft.analysisservices.xmla.dll	14.0.1.439	741536	01-Oct-2017	22:04	x86
Microsoft.analysisservices.xmla.dll	14.0.1.439	741536	01-Oct-2017	22:06	x86
Pbsvcacctsync.dll	2017.140.3006.16	66720	19-Oct-2017	12:19	x86
Pbsvcacctsync.dll	2017.140.3006.16	80544	19-Oct-2017	12:22	x64
Sql_common_core_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlftacct.dll	2017.140.3006.16	53920	19-Oct-2017	11:09	x86
Sqlftacct.dll	2017.140.3006.16	61088	19-Oct-2017	12:22	x64
Sqlmgmprovider.dll	2017.140.3006.16	371864	19-Oct-2017	12:15	x86
Sqlmgmprovider.dll	2017.140.3006.16	414880	19-Oct-2017	12:21	x64

SQL Server 2017 Database Services Core Instance

File name	File version	File size	Date	Time	Platform
Datacollectorcontroller.dll	2017.140.3006.16	224928	19-Oct-2017	11:08	x64
Fssres.dll	2017.140.3006.16	88224	19-Oct-2017	12:21	x64
Hadrres.dll	2017.140.3006.16	186528	19-Oct-2017	12:21	x64
Hkcompile.dll	2017.140.3006.16	1421472	19-Oct-2017	11:08	x64
Hkengine.dll	2017.140.3006.16	5858464	19-Oct-2017	11:08	x64
Hkruntime.dll	2017.140.3006.16	161952	19-Oct-2017	12:21	x64
Microsoft.analysisservices.applocal.xmla.dll	14.0.1.439	740136	19-Oct-2017	12:20	x86
Microsoft.sqlautoadmin.autobackupagent.dll	14.0.3006.16	237216	19-Oct-2017	12:20	x86
Microsoft.sqlautoadmin.sqlautoadmin.dll	14.0.3006.16	79520	19-Oct-2017	12:09	x86
Microsoft.sqlserver.xevent.linq.dll	2017.140.3006.16	303776	19-Oct-2017	11:02	x64
Qds.dll	2017.140.3006.16	1164448	19-Oct-2017	14:38	x64
Sqagtres.dll	2017.140.3006.16	72864	19-Oct-2017	12:22	x64
Sql_engine_core_inst_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlaccess.dll	2017.140.3006.16	474784	19-Oct-2017	11:08	x64
Sqlagent.exe	2017.140.3006.16	578720	19-Oct-2017	12:21	x64
Sqlagentctr140.dll	2017.140.3006.16	60576	19-Oct-2017	11:08	x64
Sqlagentctr140.dll	2017.140.3006.16	51872	19-Oct-2017	12:15	x86
Sqlboot.dll	2017.140.3006.16	194720	19-Oct-2017	11:08	x64
Sqlceip.exe	14.0.3006.16	249504	19-Oct-2017	12:18	x86
Sqlcmdss.dll	2017.140.3006.16	71840	19-Oct-2017	12:21	x64
Sqldk.dll	2017.140.3006.16	2789024	19-Oct-2017	14:38	x64
Sqlevn70.rll	2017.140.3006.16	3288224	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	3587232	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	1441440	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	2084512	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	3205792	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3329696	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3769504	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3907232	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3904160	19-Oct-2017	11:02	x64
Sqlevn70.rll	2017.140.3006.16	2031264	19-Oct-2017	11:02	x64
Sqlevn70.rll	2017.140.3006.16	4015264	19-Oct-2017	11:02	x64
Sqlevn70.rll	2017.140.3006.16	3472032	19-Oct-2017	11:03	x64
Sqlevn70.rll	2017.140.3006.16	3776672	19-Oct-2017	11:03	x64
Sqlevn70.rll	2017.140.3006.16	3358368	19-Oct-2017	11:03	x64
Sqlevn70.rll	2017.140.3006.16	3282592	19-Oct-2017	11:04	x64
Sqlevn70.rll	2017.140.3006.16	3625632	19-Oct-2017	11:04	x64
Sqlevn70.rll	2017.140.3006.16	3393184	19-Oct-2017	11:04	x64
Sqlevn70.rll	2017.140.3006.16	3579032	19-Oct-2017	11:04	x64
Sqlevn70.rll	2017.140.3006.16	3666592	19-Oct-2017	11:05	x64
Sqlevn70.rll	2017.140.3006.16	1494176	19-Oct-2017	11:05	x64
Sqlevn70.rll	2017.140.3006.16	3810976	19-Oct-2017	11:06	x64
Sqlevn70.rll	2017.140.3006.16	3775136	19-Oct-2017	11:07	x64
Sqllang.dll	2017.140.3006.16	41170080	19-Oct-2017	14:57	x64
Sqlmin.dll	2017.140.3006.16	40221344	19-Oct-2017	14:50	x64
Sqlolapss.dll	2017.140.3006.16	106656	19-Oct-2017	11:08	x64
Sqlos.dll	2017.140.3006.16	26272	19-Oct-2017	11:03	x64
Sqlpowershellss.dll	2017.140.3006.16	66720	19-Oct-2017	12:21	x64
Sqlrepss.dll	2017.140.3006.16	63136	19-Oct-2017	12:21	x64
Sqlscm.dll	2017.140.3006.16	69280	19-Oct-2017	11:08	x64
Sqlscriptdowngrade.dll	2017.140.3006.16	27800	19-Oct-2017	11:08	x64
Sqlscriptupgrade.dll	2017.140.3006.16	5871264	19-Oct-2017	09:52	x64
Sqlservr.exe	2017.140.3006.16	485024	19-Oct-2017	14:38	x64
Sqlsvc.dll	2017.140.3006.16	160416	19-Oct-2017	12:21	x64
Sqltses.dll	2017.140.3006.16	9536160	19-Oct-2017	14:38	x64
Sqsrvres.dll	2017.140.3006.16	259744	19-Oct-2017	12:22	x64
Svl.dll	2017.140.3006.16	153760	19-Oct-2017	12:22	x64
Xpadsi.exe	2017.140.3006.16	88224	19-Oct-2017	12:21	x64
Xplog70.dll	2017.140.3006.16	74400	19-Oct-2017	12:22	x64
Xpsqlbot.dll	2017.140.3006.16	32416	19-Oct-2017	12:22	x64
Xpstar.dll	2017.140.3006.16	436384	19-Oct-2017	12:21	x64

SQL Server 2017 Database Services Core Shared

File name	File version	File size	Date	Time	Platform
Dts.dll	2017.140.3006.16	2996896	19-Oct-2017	12:19	x64
Dtsconn.dll	2017.140.3006.16	495264	19-Oct-2017	12:19	x64
Dtshost.exe	2017.140.3006.16	103072	19-Oct-2017	12:21	x64
Dtspipeline.dll	2017.140.3006.16	1264288	19-Oct-2017	12:19	x64
Dtutil.exe	2017.140.3006.16	145568	19-Oct-2017	12:19	x64
Microsoft.analysisservices.applocal.core.dll	14.0.1.439	1381536	01-Oct-2017	22:06	x86
Msxmlsql.dll	2017.140.3006.16	1450656	19-Oct-2017	11:08	x64
Sql_engine_core_shared_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlscm.dll	2017.140.3006.16	59544	19-Oct-2017	11:01	x86
Sqlscm.dll	2017.140.3006.16	69280	19-Oct-2017	11:08	x64
Sqlsvc.dll	2017.140.3006.16	133280	19-Oct-2017	11:01	x86
Sqlsvc.dll	2017.140.3006.16	160416	19-Oct-2017	12:21	x64

SQL Server 2017 sql_extensibility

File name	File version	File size	Date	Time	Platform
Launchpad.exe	2017.140.3006.16	1121440	19-Oct-2017	12:21	x64
Sql_extensibility_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlsatellite.dll	2017.140.3006.16	918688	19-Oct-2017	12:22	x64

SQL Server 2017 Full-Text Engine

File name	File version	File size	Date	Time	Platform
Fd.dll	2017.140.3006.16	665760	19-Oct-2017	11:08	x64
Fdhost.exe	2017.140.3006.16	113312	19-Oct-2017	12:21	x64
Fdlauncher.exe	2017.140.3006.16	61600	19-Oct-2017	11:08	x64
Sql_fulltext_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlft140ph.dll	2017.140.3006.16	66208	19-Oct-2017	11:08	x64

SQL Server 2017 sql_inst_mr

File name	File version	File size	Date	Time	Platform
Imrdll.dll	14.0.3006.16	23712	19-Oct-2017	11:08	x86
Sql_inst_mr_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64

SQL Server 2017 Integration Services

File name	File version	File size	Date	Time	Platform
Attunity.sqlserver.cdccontroltask.dll	5.0.0.70	75248	15-Sep-2017	06:38	x86
Attunity.sqlserver.cdcsplit.dll	5.0.0.70	36336	15-Sep-2017	06:38	x86
Attunity.sqlserver.cdcsrc.dll	5.0.0.70	76272	19-Oct-2017	12:10	x86
Dts.dll	2017.140.3006.16	2548384	19-Oct-2017	11:01	x86
Dts.dll	2017.140.3006.16	2996896	19-Oct-2017	12:19	x64
Dtsconn.dll	2017.140.3006.16	397984	19-Oct-2017	11:01	x86
Dtsconn.dll	2017.140.3006.16	495264	19-Oct-2017	12:19	x64
Dtshost.exe	2017.140.3006.16	88224	19-Oct-2017	12:15	x86
Dtshost.exe	2017.140.3006.16	103072	19-Oct-2017	12:21	x64
Dtspipeline.dll	2017.140.3006.16	1057440	19-Oct-2017	12:10	x86
Dtspipeline.dll	2017.140.3006.16	1264288	19-Oct-2017	12:19	x64
Dtutil.exe	2017.140.3006.16	125088	19-Oct-2017	11:01	x86
Dtutil.exe	2017.140.3006.16	145568	19-Oct-2017	12:19	x64
Isdeploymentwizard.exe	14.0.3006.16	477344	19-Oct-2017	12:58	x86
Isdeploymentwizard.exe	14.0.3006.16	476832	19-Oct-2017	13:08	x64
Microsoft.analysisservices.applocal.core.dll	14.0.1.439	1381536	01-Oct-2017	22:04	x86
Microsoft.analysisservices.applocal.core.dll	14.0.1.439	1381536	01-Oct-2017	22:06	x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll	14.0.3006.16	493728	19-Oct-2017	09:51	x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll	14.0.3006.16	493728	19-Oct-2017	11:08	x86
Microsoft.sqlserver.integrationservices.server.dll	14.0.3006.16	83616	19-Oct-2017	12:15	x86
Microsoft.sqlserver.integrationservices.server.dll	14.0.3006.16	83616	19-Oct-2017	12:20	x86
Microsoft.sqlserver.integrationservices.wizard.common.dll	14.0.3006.16	415392	19-Oct-2017	12:42	x86
Microsoft.sqlserver.integrationservices.wizard.common.dll	14.0.3006.16	415392	19-Oct-2017	12:59	x86
Msdtssrvr.exe	14.0.3006.16	219808	19-Oct-2017	12:21	x64
Sql_is_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlceip.exe	14.0.3006.16	249504	19-Oct-2017	12:18	x86

SQL Server 2017 sql_polybase_core_inst

File name	File version	File size	Date	Time	Platform
Sqlevn70.rll	2017.140.3006.16	1494176	19-Oct-2017	11:05	x64
Sqlevn70.rll	2017.140.3006.16	3904160	19-Oct-2017	11:02	x64
Sqlevn70.rll	2017.140.3006.16	3205792	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3907232	19-Oct-2017	11:01	x64
Sqlevn70.rll	2017.140.3006.16	3810976	19-Oct-2017	11:06	x64
Sqlevn70.rll	2017.140.3006.16	2084512	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	2031264	19-Oct-2017	11:02	x64
Sqlevn70.rll	2017.140.3006.16	3579032	19-Oct-2017	11:04	x64
Sqlevn70.rll	2017.140.3006.16	3587232	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	1441440	19-Oct-2017	11:00	x64
Sqlevn70.rll	2017.140.3006.16	3775136	19-Oct-2017	11:07	x64

SQL Server 2017 sql_shared_mr

File name	File version	File size	Date	Time	Platform
Smrdll.dll	14.0.3006.16	23712	19-Oct-2017	11:08	x86
Sql_engine_core_shared_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64

SQL Server 2017 sql_tools_extensions

File name	File version	File size	Date	Time	Platform
Dts.dll	2017.140.3006.16	2548384	19-Oct-2017	11:01	x86
Dts.dll	2017.140.3006.16	2996896	19-Oct-2017	12:19	x64
Dtsconn.dll	2017.140.3006.16	397984	19-Oct-2017	11:01	x86
Dtsconn.dll	2017.140.3006.16	495264	19-Oct-2017	12:19	x64
Dtshost.exe	2017.140.3006.16	88224	19-Oct-2017	12:15	x86
Dtshost.exe	2017.140.3006.16	103072	19-Oct-2017	12:21	x64
Dtspipeline.dll	2017.140.3006.16	1057440	19-Oct-2017	12:10	x86
Dtspipeline.dll	2017.140.3006.16	1264288	19-Oct-2017	12:19	x64
Dtutil.exe	2017.140.3006.16	125088	19-Oct-2017	11:01	x86
Dtutil.exe	2017.140.3006.16	145568	19-Oct-2017	12:19	x64
Microsoft.sqlserver.astasksui.dll	14.0.3006.16	184480	19-Oct-2017	13:08	x86
Microsoft.sqlserver.chainer.infrastructure.dll	14.0.3006.16	406688	19-Oct-2017	11:01	x86
Microsoft.sqlserver.chainer.infrastructure.dll	14.0.3006.16	406688	19-Oct-2017	12:20	x86
Microsoft.sqlserver.configuration.sco.dll	14.0.3006.16	2093216	19-Oct-2017	12:15	x86
Microsoft.sqlserver.configuration.sco.dll	14.0.3006.16	2093216	19-Oct-2017	12:20	x86
Msmgdsrv.dll	2017.140.1.439	7310496	19-Oct-2017	12:15	x86
Sql_tools_extensions_keyfile.dll	2017.140.3006.16	100512	19-Oct-2017	12:19	x64
Sqlscm.dll	2017.140.3006.16	59544	19-Oct-2017	11:01	x86
Sqlscm.dll	2017.140.3006.16	69280	19-Oct-2017	11:08	x64
Sqlsvc.dll	2017.140.3006.16	133280	19-Oct-2017	11:01	x86
Sqlsvc.dll	2017.140.3006.16	160416	19-Oct-2017	12:21	x64

Notes for this update

To apply this Cumulative Update package, you must be running SQL Server 2017.

You may have to restart the computer after you apply this Cumulative Update package.

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

This article also provides important information about the following situations:

Pacemaker : A behavioral change is made in distributions that use the latest available version of Pacemaker. Mitigation methods are provided.
Query Store : You must run this script if you use the Query Store and you have previously installed Microsoft SQL Server 2017 Cumulative Update 2 (CU2).

Analysis Services CU build version

Beginning in SQL Server 2017, the Analysis Services build version number and SQL Server Database Engine build version number do not match. For more information, see Verify Analysis Services cumulative update build version.

Cumulative updates (CU)

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

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 should be installed at the same level of confidence.
We recommend ongoing, proactive installation of CUs as they become available according to these guidelines:
- 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.

IMPORTANT

All distributions (including RHEL 7.3 and 7.4) that use the latest available Pacemaker package 1.1.18-11.el7 introduce a behavior change for the start-failure-is-fatal cluster setting if its value is false. This change affects the failover workflow. If a primary replica experiences an outage, the cluster is expected to fail over to one of the available secondary replicas. Instead, users will notice that the cluster keeps trying to start the failed primary replica. If that primary never comes online (because of a permanent outage), the cluster never fails over to another available secondary replica.

This issue affects all SQL Server versions, regardless of the cumulative update version that they are on.

To mitigate the issue, use either of the following methods.

Method 1

Follow these steps:

Remove the start-failure-is-fatal override from the existing cluster.

# RHEL, Ubuntu pcs property unset start-failure-is-fatal # or pcs property set start-failure-is-fatal=true # SLES crm configure property start-failure-is-fatal=true
Decrease the cluster-recheck-interval value.

# RHEL, Ubuntu pcs property set cluster-recheck-interval=<Xmin> # SLES crm configure property cluster-recheck-interval=<Xmin>
Add the failure-timeout meta property to each AG resource.

# RHEL, Ubuntu pcs resource update ag1 meta failure-timeout=60s # SLES crm configure edit ag1 # In the text editor, add `meta failure-timeout=60s` after any `param`s and before any `op`s

Note In this code, substitute the value for <Xmin> as appropriate. If a replica goes down, the cluster tries to restart the replica at an interval that is bound by the failure-timeout value and the cluster-recheck-interval value. For example, if failure-timeout is set to 60 seconds and cluster-recheck-interval is set to 120 seconds, the restart is tried at an interval that is greater than 60 seconds but less than 120 seconds. We recommend that you set failure-timeout to 60s and cluster-recheck-interval to a value that is greater than 60 seconds. We recommend that you do not set cluster-recheck-interval to a small value. For more information, refer to the Pacemaker documentation or consult the system provider.

Method 2

Revert to Pacemaker version 1.1.16.

IMPORTANT

You must run this script if you use Query Store and you are updating from SQL Server 2017 Cumulative Update 2 (CU2) directly to SQL Server 2017 Cumulative Update 3 (CU3) or any later cumulative update. You do not have to run this script if you have previously installed SQL Server 2017 Cumulative Update 3 (CU3) or any later SQL Server 2017 cumulative update.

SET NOCOUNT ON;
DROP TABLE IF EXISTS #tmpUserDBs;

SELECT [database_id], 0 AS [IsDone]
INTO #tmpUserDBs
FROM master.sys.databases
WHERE [database_id] > 4
 AND [state] = 0 -- must be ONLINE
 AND is_read_only = 0 -- cannot be READ_ONLY
 AND [database_id] NOT IN (SELECT dr.database_id FROM sys.dm_hadr_database_replica_states dr -- Except all local Always On secondary replicas
  INNER JOIN sys.dm_hadr_availability_replica_states rs ON dr.group_id = rs.group_id
  INNER JOIN sys.databases d ON dr.database_id = d.database_id
  WHERE rs.role = 2 -- Is Secondary
   AND dr.is_local = 1
   AND rs.is_local = 1)

DECLARE @userDB sysname;

WHILE (SELECT COUNT([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0) > 0
BEGIN
 SELECT TOP 1 @userDB = DB_NAME([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0

 -- PRINT 'Working on database ' + @userDB

 EXEC ('USE [' + @userDB + '];
DECLARE @clearPlan bigint, @clearQry bigint;
IF EXISTS (SELECT [actual_state] FROM sys.database_query_store_options WHERE [actual_state] IN (1,2))
BEGIN
 IF EXISTS (SELECT plan_id FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27'')
 BEGIN
  DROP TABLE IF EXISTS #tmpclearPlans;

  SELECT plan_id, query_id, 0 AS [IsDone]
  INTO #tmpclearPlans
  FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27''

  WHILE (SELECT COUNT(plan_id) FROM #tmpclearPlans WHERE [IsDone] = 0) > 0
  BEGIN
   SELECT TOP 1 @clearPlan = plan_id, @clearQry = query_id FROM #tmpclearPlans WHERE [IsDone] = 0
   EXECUTE sys.sp_query_store_unforce_plan @clearQry, @clearPlan;
   EXECUTE sys.sp_query_store_remove_plan @clearPlan;

   UPDATE #tmpclearPlans
   SET [IsDone] = 1
   WHERE plan_id = @clearPlan AND query_id = @clearQry
  END;

  PRINT ''- Cleared possibly affected plans in database [' + @userDB + ']''
 END
 ELSE
 BEGIN
  PRINT ''- No affected plans in database [' + @userDB + ']''
 END
END
ELSE
BEGIN
 PRINT ''- Query Store not enabled in database [' + @userDB + ']''
END')
  UPDATE #tmpUserDBs
  SET [IsDone] = 1
  WHERE [database_id] = DB_ID(@userDB)
END

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

SQL Server failover cluster rolling update and service pack process

Note If you do not want to use the rolling update process, follow these steps to apply an update:
1. Install the update on the passive node.
2. Install the update on the active node (requires a service restart).
Upgrade and update of availability group servers that use minimal downtime and data loss

Note If you enabled AlwaysOn with SSISDB catalog, see the information about SSIS with AlwaysOn for more information about how to apply an update in these environments.
How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
How to apply a hotfix for SQL Server in a replication topology
How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
Overview of SQL Server Servicing Installation

SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package is not specific to one language. It applies to all supported languages.

One Cumulative Update package includes all available updates for ALL SQL Server 2017 components (features). However, the cumulative update package updates only those components that are currently installed on the SQL Server instance you select to be serviced. If a SQL Server feature (for example, Analysis Services) is added to the instance after this CU is applied, you must re-apply this CU to update the new feature to this CU.

If additional issues occur or if any troubleshooting is required, you might have to create a service request. The usual support costs will apply to additional support questions and to issues that do not 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

In Control Panel, open the Programs and Features item, and then select View installed updates.
Locate the entry that corresponds to this cumulative update package under SQL Server 2017.
Press and hold (or right-click) the entry, and then select Uninstall.

To uninstall this CU on Linux, you must roll back the package to the previous version.

For more information about how to roll back the installation, see Rollback SQL Server.

Third-party information disclaimer

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

KB4038634 - Cumulative Update 1 for SQL Server 2017

Summary

Known issues with this update

Improvements and fixes included in this cumulative update

How to obtain or download this or latest cumulative update package

File information

Notes for this update

How to uninstall this update

Third-party information disclaimer

References

Need more help?

Want more options?

Was this information helpful?

Thank you for your feedback!

Summary

Known issues with this update

Improvements and fixes included in this cumulative update

How to obtain or download this or latest cumulative update package

How to obtain or download the latest cumulative update package for Windows (Recommended)

How to obtain or download this cumulative update package for Windows

How to obtain or download the latest cumulative update package for Linux

File information

File hash information

Cumulative Update package file information

Notes for this update

Prerequisites

Restart information

Registry information

Important notices

Pacemaker notice

Query Store notice

Hybrid environments deployment

Language support

Components (features) updated

Support for this update

How to uninstall this update

How to uninstall this update on Windows

How to uninstall this update on Linux

Third-party information disclaimer

References

Need more help?

Want more options?

Was this information helpful?

Thank you for your feedback!