Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
KB4570012 - Cumulative Update 7 for SQL Server 2019
Release Date: September 02, 2020
Version: 15.0.4063.15
Summary
This article describes Cumulative Update package 7 (CU7) for Microsoft SQL Server 2019. This update contains 50 fixes that were issued after the release of SQL Server 2019 Cumulative Update 6, and it updates components in the following builds:
- SQL Server - Product version: 15.0.4063.15, file version: 2019.150.4063.15
- Analysis Services - Product version: 15.0.34.22, file version: 2018.150.34.22
Known issues in this update
There's a known issue that affects using database snapshots in SQL Server 2019 CU7. Notice that using DBCC CHECKDB is also affected because this generates a database snapshot. This issue is fixed in SQL Server 2019 CU8. To get this fix, apply SQL Server 2019 CU8 or any later SQL Server 2019 CU release.
If you downloaded the CU7 package file before September 23, 2020, we recommend that you don't install it. Please move to SQL Server CU8 or a later CU release.
If you have already applied SQL Server 2019 CU7, please uninstall it and move to SQL Server CU8 or a later CU release.
If you have already applied SQL Server 2019 CU7, and you created a database snapshot, plan to drop the database snapshot, and then apply SQL Server 2019 CU8 or a later CU release before you re-create your database snapshot.
More details will be made available in the SQL Release Blog.
Improvements and fixes included in this 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 |
|---|---|---|---|---|
| 13607136 | Error occurs when mashup is used to import from Active Directory (AD) using the default M query generated from the connection wizard. Key Expression Error: The key didn't match any rows in the table |
Analysis Services | Analysis Services | Windows |
| 13607145 | Fixes an error that occurs when a session cube is created on a database and you try to query from that session cube. The following error is received when you query the session cube: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine. |
Analysis Services | Analysis Services | Windows |
| 13607144 | Fixes long duration for Integration Services Project deployment through powershell by improving search of operation messages in deployment process. | Integration Services | Server | Windows |
| 13585628 | Fixes intermittent connection issue with SSIS package executions when expression is used for both connection string and password of a connection manager. | Integration Services | Tasks_Components | Windows |
| 13626378 | Fixes an issue in MDS Filtered results where the user isn't returned to page 1 and the page count isn't updated until returning to page 1. | Master Data Services | Client | Windows |
| 13583547 | FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 (KB4577561) | Master Data Services | Master Data Services | Windows |
| 13606017 | Unable to change the DateTime/Number attributes to NULL in Master Data Services (MDS). |
Master Data Services | Master Data Services | Windows |
| 13607160 | Column description disappears after exporting/importing models through MDSModelDeploy for an approval required entity in SQL Server 2019. |
Master Data Services | Master Data Services | Windows |
| 13632226 | Fixes an issue in Master Data Services 2019 where you can't input multiline content in text attributes. | Master Data Services | Master Data Services | Windows |
| 13512207 | FIX: SQL Server fails to start when remote admin connections are enabled and IPV6 is disabled on the host (KB4575453) | SQL Server Connectivity | Protocols | Linux |
| 13598931 | FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server 2016 and 2019 (KB4561305) | SQL Server Engine | Column Stores | All |
| 13669080 | FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset (KB4577836) | SQL Server Engine | Column Stores | All |
| 13606684 | When you run a SELECT query in Read Committed Snapshot Isolation (RCSI) on Clustered Columnstore Index (CCI) on a table in SQL Server 2019, the query may return incorrect number of rows under rare conditions. |
SQL Server Engine | Column Stores | All |
| 13586253 | FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2019 (KB4578110) | SQL Server Engine | DB Management | Windows |
| 13643805 | FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 (KB4577594) | SQL Server Engine | Extensibility | All |
| 13619478 | Updates RSetup with the updated FWLINK version 3.5.2.777. | SQL Server Engine | Extensibility | Windows |
| 13643390 | Fixes failure of SQL Server Extensibility Runtimes Setup on FIPS compliant servers. | SQL Server Engine | Extensibility | All |
| 13647889 | Python and R CAB files for SQL Server Machine Learning Services on Windows and mssql-mlservices packages on Linux are updated to version 9.4.7.958. On Windows, "Cannot resume session with terminated pooled process" error is fixed while launching Python/R runtimes. On Linux, this update enables successful installation of mssql-mlservices-mlm-r package on RHEL8. |
SQL Server Engine | Extensibility | All |
| 13598899 | When you concurrently create sub directories in a FileTable directory, a deadlock may occur internally in the SQL Server Engine and all subsequent requests to FileTable directories and files may not respond. | SQL Server Engine | FileStream and FileTable | Windows |
| 13607142 | FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server (KB4569424) | SQL Server Engine | High Availability and Disaster Recovery | Linux |
| 13567739 | Fixes an issue to reduce parallel redo thread shutdown and startup thread messages in error log on servers with fewer cores and more idle databases. | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13598933 | FIX: Assertion error occurs on the mirror server during redo process hitting. Assertion: File: <FilePath\FileName>, line = <LineNumber> Failed Assertion = 'result == LCK_OK' |
SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 13607140 | This update adds detailed error information to the pacemaker log when pacemaker agent fails to connect to SQL Server resource to obtain health status. | SQL Server Engine | High Availability and Disaster Recovery | Linux |
| 13607141 | Fixes an assertion exception that occurs when you query the DMV sys.dm_hadr_automatic_seeding. |
SQL Server Engine | High Availability and Disaster Recovery | All |
| 13627086 | Updates the Zulu JRE version to zulu11.37.18-sa-jre11.0.6.101. |
SQL Server Engine | Linux | Linux |
| 13607135 | FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 (KB4567166) | SQL Server Engine | Methods to access stored data | Windows |
| 13621665 | FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 (KB4574801) | SQL Server Engine | PolyBase | All |
| 13628489 | FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 (KB4577591) | SQL Server Engine | PolyBase | Linux |
| 13634075 | FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 (KB4577590) | SQL Server Engine | PolyBase | Linux |
| 13578549 | Improvement: Enables RLS feature for PolyBase by default in SQL Server 2019. | SQL Server Engine | PolyBase | Linux |
| 13643332 | FIX: Scalar UDF Inlining issues in SQL Server 2019 (KB4538581) | SQL Server Engine | Programmability | All |
| 13647491 | FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower (KB4576778) | SQL Server Engine | Programmability | All |
| 13598907 | When you run an ALTER command WITH ROLLBACK IMMEDIATE, the rollback can trigger before the command is processed, thus rolling back transactions even if the ALTER itself fails due to lack of permissions. This fix makes sure that the rollback is processed only after the ALTER command completes. |
SQL Server Engine | Programmability | Windows |
| 13598937 | Access violation exception occurs when a query that references a non-exsting partition function is executed. | SQL Server Engine | Query Execution | Windows |
| 13616383 | Fixes a performance issue when a query outputs NULL values following a semi join in SQL Server 2019 for a database with UTF8. |
SQL Server Engine | Query Execution | Windows |
| 13667907 | Under (rare) certain circumstances, memory grant recalculation can cause an access violation. | SQL Server Engine | Query Execution | Windows |
| 13607143 | DELETE statement returns Foreign Key check constraint error even when REFERENCE table has no matching rows. Msg 547, Level 16, State 0, Line <LineNumber> The DELETE statement conflicted with the REFERENCE constraint "<ConstraintName>". The conflict occurred in database "<DatabaseName>", table "<TableName>", column '<ColumnName>'. The statement has been terminated. |
SQL Server Engine | Query Optimizer | Windows |
| 13607158 | This update fixes an issue with sys.dm_db_stats_histogram not showing NULL value histogram step. |
SQL Server Engine | Query Optimizer | All |
| 13598911 | FIX: Upgrade script may fail if you use an Always On high availability group as a secondary replica in SQL Server 2016 and 2019 (KB4563115) | SQL Server Engine | Replication | Windows |
| 13607134 | FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 (KB4569425) | SQL Server Engine | Replication | Windows |
| 13636909 | FIX: Can't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server (KB4034376) | SQL Server Engine | Replication | All |
| 13598905 | When a replication error such as deadlock occurs, random ID is inserted in MSRepl_Errors table while it should be just incremented by 1 from the previous ID value. This cumulative update (CU) fixes the issue and the MSRepl_Errors will insert entries with row ID incremented by 1 instead of using some random value. |
SQL Server Engine | Replication | Windows |
| 13598909 | FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server (KB4511771) | SQL Server Engine | Search | Windows |
| 13635355 | FIX: Error occurs when using DBCC operations while TDE key change happens in SQL Server 2019 (KB4578395) | SQL Server Engine | Security Infrastructure | All |
| 13491695 | FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size (KB4578011) | SQL Server Engine | Storage Management | Linux |
| 13598885 | DBCC CHECKDB reports corruption on spatial index incorrectly if base table has a column called ID. |
SQL Server Engine | Storage Management | Windows |
| 13598925 | When DBCC CHECKTABLE, CHECKFILEGROUP and CHECKDB commands are issued against a database with table that contains columnstore index located on read-only non-primary filegroup, you may receive the following error: Msg 8921, Level 16, State 1, Line <LineNumber> Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. |
SQL Server Engine | Storage Management | Windows |
| 13598927 | FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server 2016 and 2019 (KB4560183) | SQL Server Engine | Transaction Services | Windows |
| 13598896 | SSRS 2016 URLs are case-sensitive after applying Security update GDRs: KB4532097 and KB4535706. | SQL Server Engine | XML | Windows |
| 13602806 | Fixes the Japanese translation for "State" in SQL Configuration Manager. | 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
- Announcing updates to the SQL Server Incremental Servicing Model (ISM)
- SQL Server Service Packs are no longer supported starting from SQL Server 2017
- Determine which version and edition of SQL Server Database Engine is running
- Servicing models for SQL Server
- Naming schema and Fix area descriptions for SQL Server software update packages
- Description of the standard terminology that is used to describe Microsoft software updates
Feedback
Was this page helpful?