Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

KB4536075 - Cumulative Update 2 for SQL Server 2019

Release Date:   February 13, 2020
Version:   15.0.4013.40

Summary

This article describes Cumulative Update package 2 (CU2) for Microsoft SQL Server 2019. This update contains 81 fixes that were issued after the release of SQL Server 2019 Cumulative Update 1, and it updates components in the following builds:

  • SQL Server - Product version: 15.0.4013.40, file version: 2019.150.4013.40
  • Analysis Services - Product version: 15.0.34.1, file version: 2018.150.34.1

Known issues in this update

There's a known issue in SQL Server Agent in SQL Server 2019 CU2. This will be fixed in the next CU release (SQL Server 2019 CU3).

  • If you're using SQL Server 2019 SQL Server Agent, we recommend that you skip the CU2 update, and install SQL Server 2019 CU3 (KB4538853) instead.

  • If you have already applied SQL Server 2019 CU2, and you're experiencing issues that affect SQL Server Agent, please install SQL Server 2019 CU3 (KB4538853).

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. Select to download this Excel file now.

Note

Individual entries in the following table can be referenced directly through a bookmark. If you select any bug reference ID in the table, a bookmark tag is added to the URL by using the "#NNNNNNNN" format. You can then share this URL with others so that they can jump directly to the desired fix in the table.

For more information about the bugs that are fixed and enhancements that are included in this cumulative update, see the following Microsoft Knowledge Base articles.

Bug reference Description Fix area Component Platform
13322585 FIX: Calculation with summarizecolumn returns unexpected results after upgrading to SSAS 2019 with compatibility level 1500 (KB4538159) Analysis Services Analysis Services Windows
13323995 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server 2016 and 2017 (KB4527355) Analysis Services Analysis Services Windows
13324007 FIX: Memory may not get released when you process partitions with data in SQL Server (KB4529876) Analysis Services Analysis Services Windows
13324021 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS (KB4530475) Analysis Services Analysis Services Windows
13324038 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server 2017 and 2019 (KB4527510) Analysis Services Analysis Services Windows
13299413 FIX: Package execution may be impacted in SQL Server 2019 Integration Services (KB4530097) Integration Services Integration Services Windows
13324029 FIX: Menu and scroll bar are missing in "Changes" section when large number of changesets are added in Excel add-in for MDS in SQL Server 2017 and 2019 (KB4524191) Master Data Services Client Windows
13345413 FIX: Custom date format with time doesn't work properly in SQL Server 2019 Master Data Services (KB4537401) Master Data Services Server Windows
13257853 FIX: SQLDiag fails to generate output due to missing stored procedure tempdb.dbo.sp_sqldiag14 in SQL Server 2017 and 2019 (KB4531736) SQL Server Client Tools SQLDiag Windows
13277345 Improvement: Enable DNN feature in SQL Server 2019 FCI (KB4537868) SQL Server Connectivity Protocols Windows
13200686 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS (KB4523102) SQL Server Engine Backup Restore Windows
13294980 FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 (KB4538377) SQL Server Engine Column Stores Windows
13324013 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server (KB4528067) SQL Server Engine Column Stores Windows
13324015 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 or 2019 because of NCCI (KB4528066) SQL Server Engine Column Stores Windows
13355673 FIX: Access violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server 2017 and 2019 (KB4537350) SQL Server Engine Column Stores Windows
13356844 FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger (KB4538573) SQL Server Engine DB Management All
13252064 Improvement: New features included in library management for external languages in SQL Server 2019 (KB4538595) SQL Server Engine Extensibility All
13329355 Improvement: Download new CAB files that have fixes for R/Python runtime features (KB4538205) SQL Server Engine Extensibility Windows
13299424 FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019 (KB4533497) SQL Server Engine Extensibility All
13309415 FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server (KB4534249) SQL Server Engine High Availability and Disaster Recovery All
13328937 FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 (KB4537869) SQL Server Engine High Availability and Disaster Recovery Windows
13343052 FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 on Linux (KB4538174) SQL Server Engine High Availability and Disaster Recovery Linux
13323987 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server (KB4528250) SQL Server Engine In-Memory OLTP Windows
13234378 Improvement: Module and offset information is sent as output for dumps in SQL Server 2019 (KB4538759) SQL Server Engine Linux Linux
13323991
13324024
FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server (KB4527229) SQL Server Engine Management Services Windows
13317221 Improvement: Add two system tables in the Memory-optimized TempDB metadata feature in SQL Server 2019 (KB4537749) SQL Server Engine Metadata All
13323218 FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019 (KB4537751) SQL Server Engine Metadata Windows
13250169 FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 (KB4540371) SQL Server Engine Methods to access stored data Windows
13324033 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 (KB4527916) SQL Server Engine Methods to access stored data Windows
13324036 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server (KB4525483) SQL Server Engine Methods to access stored data Windows
13356198 Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux (KB4538382) SQL Server Engine PolyBase Linux
13262515 FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 (KB4534148) SQL Server Engine PolyBase All
13262847 FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019 (KB4531232) SQL Server Engine PolyBase Linux
13325916 FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 (KB4540372) SQL Server Engine PolyBase Windows
13325930 FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 (KB4539201) SQL Server Engine PolyBase Windows
13326430 FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019 (KB4539203) SQL Server Engine PolyBase Windows
13327197 FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 (KB4538161) SQL Server Engine PolyBase Windows
13333719 FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition (KB4538162) SQL Server Engine PolyBase Windows
13333721 FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019 (KB4536684) SQL Server Engine PolyBase All
13333730 FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions (KB4537072) SQL Server Engine PolyBase All
13333743 FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019 (KB4538163) SQL Server Engine PolyBase All
13334474 FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 (KB4538164) SQL Server Engine PolyBase All
13356782 FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 (KB4538968) SQL Server Engine PolyBase All
13356818 FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 (KB4539198) SQL Server Engine PolyBase All
13356967 FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 (KB4539199) SQL Server Engine PolyBase All
13356977 FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 (KB4539200) SQL Server Engine PolyBase All
13373021 FIX: Issue occurs when using PolyBase for SQL Server 2019 generic ODBC with drivers from Microsoft Access Database Engine Redistributable package (KB4539340) SQL Server Engine PolyBase All
13262635 FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations (KB4531384) SQL Server Engine Programmability All
13314681 FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019 (KB4538495) SQL Server Engine Programmability Windows
13342963 FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 (KB4537347) SQL Server Engine Programmability All
13345912 FIX: Scalar UDF Inlining issues in SQL Server 2019 (KB4538581) SQL Server Engine Programmability All
13323997 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server (KB4530212) SQL Server Engine Query Execution Linux
13324000 FIX: Error 8601 occurs when you run a query with partition function in SQL Server (KB4530251) SQL Server Engine Query Execution Windows
13324003 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned (KB4530443) SQL Server Engine Query Execution Windows
13324009 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server (KB4527716) SQL Server Engine Query Execution Windows
13303147 FIX: Scalar UDF Inlining issues in SQL Server 2019 (KB4538581) SQL Server Engine Query Optimizer Windows
13323989 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server (KB4531010) SQL Server Engine Query Optimizer Windows
13330439 FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 (KB4537452) SQL Server Engine Replication Windows
13324026 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 (KB4529833) SQL Server Engine Security Infrastructure Windows
13347083 FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 (KB4538496) SQL Server Engine Security Infrastructure Windows
13355058 FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 (KB4538342) SQL Server Engine Security Infrastructure All
13355108 FIX: Passwords are masked in audit logs in SQL Server 2019 (KB4538344) SQL Server Engine Security Infrastructure All
13356850 FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019 (KB4538481) SQL Server Engine Security Infrastructure All
13358159 FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 (KB4538575) SQL Server Engine Security Infrastructure All
13333564 Improvement: Add BDC storage pool cache in SQL Server 2019 (KB4538978) SQL Server Engine SQL BDC Polybase All
13333572 FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019 (KB4536841) SQL Server Engine SQL BDC Polybase All
13334483 FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 (KB4539000) SQL Server Engine SQL BDC Polybase All
13336003 FIX: Dumps occur because of OOM condition in SQL Server 2019 (KB4538858) SQL Server Engine SQL BDC Polybase All
13343690 FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC (KB4538036) SQL Server Engine SQL BDC Polybase Linux
13443207 FIX: Memory leak by Controller container in SQL Server 2019 BDC (KB4551838) SQL Server Engine SQL BDC Polybase Linux
13262799 Improvement: Use QUOTENAME with EXECUTE AT to query on table that has column name with quotes in SQL Server 2019 (KB4538112) SQL Server Engine SQL Big Data Cluster Linux
13356829 Improvement: Add BDC data/storage pool nodes DMVs in SQL Server 2019 (KB4538689) SQL Server Engine SQL Big Data Cluster Linux
13324019 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server (KB4530259) SQL Server Engine SQL OS Windows
13329379 FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server 2019 (KB4536005) SQL Server Engine SQL OS All
13336034 FIX: Severe spinlock contention occurs in SQL Server 2019 (KB4538688) SQL Server Engine SQL OS All
13346172 FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 (KB4537710) SQL Server Engine SQL OS All
13359683 FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 (KB4539197) SQL Server Engine SQL OS All
13281112 DBCC STACKDUMP command was extended to support generating dumps of different types: mini, filtered, full dumps. It also allows you to limit the text output in the additional text file that gets generated with the memory dump.

DBCC STACKDUMP WITH MINI_DUMP | FILTERED_DUMP | FULL_DUMP [, TEXT_DUMP = LIMITED | DETAILED]
SQL Server Engine SQL OS All
13343031 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only (KB4538378) SQL Server Engine Storage Management Windows
13314029 FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 (KB4538017) SQL Server Engine Transaction Services All
13357903 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2017 and 2019 (KB4540449) SQL Server Engine XML All
13323999 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU (KB4524542) SQL Setup Patching Windows

How to obtain or download this or the latest cumulative update package

File information

Notes for this update

How to uninstall this update

References


Feedback

Was this page helpful?

Additional resources