KB5030333 SQL Server 2019 Cumulative Update 23

This content has been archived. But, the content is true and relevant to the underlying technology products or infrastructure services.

KB5030333 is the cumulative update number 23 for SQL Server 2019. It was released on 12 October 2023. The update is a major update as it fixes many bugs and issues in SQL Server 2019.

The content below caters to SQL Server 2019 installed on Windows Servers.

Salient points

  • KB5030333 is cumulative update number 23 for SQL Server 2019.
  • KB5030333 CU 23 of SQL Server 2019 contains 24 fixes over the KB5027702 CU 22 version.
  • KB5027702 was released on 14 August 2023. On 10 October 2023, KB5029378 was released with security fixes for the CU 22 of SQL Server 2019.
  • KB5030333 corresponds to SQL Server 2019 version 15.0.4335.1. The file version is 2019.150.4335.1.
  • KB5030333 also updates the Analysis Services to the product version 15.0.35.41, and the file version is 2018.150.35.41.
  • KB5030333 can be applied to any SQL Server 2019 installation.
  • The update file for KB5030333 is SQLServer2019-KB5030333-x64.exe. The file hash is C79367EF48F653A31F98BB8A0CACF382B1C59D290F48E2A6F19D0F6171B31421.
  • To verify the file hash value, use the command – certutil -hashfile SQLServer2019-KB5030333-x64.exe SHA256 on the command prompt.
  • This Cumulative Update includes all fixes from all previous RTM Cumulative Updates. Therefore, it can be installed to resolve issues fixed in any previous RTM Cumulative Update of SQL Server 2019.

Download KB5030333

KB5030333 can be applied automatically using the Windows Update program.

You can also deploy KB5030333 manually. For manual implementation, you can download the offline installer file in .exe format. The file can be downloaded from the Microsoft Update Catalog or the Microsoft Download Center. The direct download links for the SQL Server 2019 CU 23 are mentioned below.

The size of the KB5030333 SQL Server 2019 CU 23 is 878.4 MB. The server will restart after the patch is installed. We suggest carrying out the deployment of KB5030333 in an organized change process.

KB5030333 – Changelog

There are 24 fixes or improvements in KB5030333. CU 23 makes for a major release of SQL Server 2019. The details of issue fixes are mentioned below in brief.

  • 18 issues in the SQL Server Engine are resolved
  • 2 issues in Master Data Services are fixed
  • 2 issues in SQL Connectivity are fixed
  • 2 issues related to SQL Setup are fixed

Brief details of the issues fixed are shared below.

SQL Server Engine issue fixes

Bug/Issue referenceIssue description
1992459Fixes an issue in which restoring a transaction log backup to the specific point in time fails with the following error:

Msg 9003, Level 20, State 9, Line <LineNumber>
The log scan number (xxx:xxx:xxx) passed to log scan in database ‘DatabaseName’ is not valid.
2584049Enables IO error mode history in retail builds by using trace flag 3139 to allow the investigation of the assertion failure (Location: readEncoded.cpp:2988; Expression: m_pDecodeSplitInput->GetAvailableFreeSize () >= lengthInNext) that may occur while restoring transaction log backups
2374314
Fixes an issue in which an INSERT (or any Data Manipulation Language (DML)) statement is blocked if you run the statement before a clustered columnstore index (CCI) online rebuild or drop and then run the statement during the online rebuild or drop if the statement is still in the procedure cache.
2690338
Updates the design of IDENTITY to improve the stability when SET IDENTITY_INSERT is ON for a table.

Note: To apply this update, you need to set the QUERY_OPTIMIZER_HOTFIXES database scoped configuration to ON. Otherwise, you can turn on trace flag 13193 to make this update unavailable.
2567537
Fixes an issue in which an availability group that has database level health detection enabled triggers needless failover for the following error 1105 when data files reach the limit size or the configured maximization:

<DateTime> Error: 1105, Severity: 17, State: 2.
<DateTime> Could not allocate space for object ‘<TableName>’ in database ‘<DatabaseName>’ because the ‘<FilegroupName>’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
2529767
Improves Data Definition Language (DDL) performance to create a large number of tables and partitions when the number of databases on a SQL Server instance exceeds 100.
2614132
Fixes a potential process termination issue that you might encounter when an adhoc query that uses the binary large object (BLOB) encounters an error and tries to clean up during the query shutdown.
2647396
Fixes race conditions in which certain variables aren’t initialized correctly when a batch mode sort query is aborted, which causes an access violation and INVALID_POINTER_READ_c0000005_sqlmin.dll!CBpSortLessFunctor_127,0,1,0_
::OptLessFunction
 exception
2693198
Fixes an access violation exception that you encounter at sqlmin!CBpXteHashJoin::FSeparateHash when you try to run a query that involves an Adaptive Join (CONCAT) operator in the query plan.
2590045
Fixes an issue in which the dynamic snapshot fails with the error “Arithmetic overflow error converting expression to data type int” in the partition_id_eval_proc column when you try to add new subscriptions to merge publications.
2602743
Fixes an issue that you encounter in the following scenario:

– Configure the “Replication: agent custom shutdown” alert to respond to error 20578.

– Run sp_publication_validation with @shutdown_agent as 1 to initiate an article validation.

In this scenario, you notice that the “Replication: agent custom shutdown” alert doesn’t respond, which occurs as error 20578 isn’t logged in the application log.
2614095
Fixes an issue in which the Snapshot Agent incorrectly generates the script of the XXX_msrepl_ccs stored procedure if @sync_method is concurrent, and replication stored procedures are specified under a custom schema.
2646148
Fixes inconsistent results that you encounter when you use Read Committed Snapshot Isolation (RCSI) and the full-text index doesn’t pick up the updated data in an incremental crawl.
2621966
Fixes the following error 2570 that you encounter when you run DBCC CHECKDB against a database, which is caused by using negative parameters in the RANDOM function against a column that uses dynamic data masking (DDM):

Msg 2570, Level 16, State 3, Line <LineNumber>
Page (<PageID>), slot <SlotID> in object ID <ObjectID>, index ID <IndexID>, partition ID <PartitionID>, alloc unit ID <UnitID> (type “<Type>”). Column “<ColumnName>” value is out of range for data type “<DataType>”. Update column to a legal value.
2633609
An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior.
2674865Fixes error 207 (Invalid column name ‘<ColumnName>’) that you encounter when you run a user-defined function (UDF), which references a dropped column that uses data classification.
2639915
Adds a compressed memory dump feature that helps create a compressed memory stream to replace the conventional memory stream to speed up the dump process and reduce the size of the dump file. For more information, see Use the Sqldumper.exe tool to generate a dump file in SQL Server.
2640296
Fixes an issue in which SQL Server continues to generate new dump files when the dump file size is larger than 2 gigabytes (GB).

SQL Setup issue fixes

The following 2 issues have been fixed in SQL Setup in KB5030333.

Issue referenceDescription of issue
2651628
Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead.
2746708
Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead.

SQL Connectivity issue fixes

Issue referenceDescription
2633976
Updates the version of the Microsoft ODBC driver to 17.10.5.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows.
2633979
Updates the version of the Microsoft OLE DB driver to 18.6.7. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server.

Master Data Services issue fixes

Issue referenceIssue description
2593704
Fixes an issue that you encounter when selecting other non-entity nodes after selecting an entity node in Master Data Services models.
2654352Fixes an issue in which you search for a specific node and then fail to expand the node on the hierarchy page.

October 2023 Security Updates

You may be interested in reading more about other October 2023 security or cumulative updates shared below:

Rajesh Dhawan

Rajesh Dhawan is a technology professional who loves to blog about smart wearables, Cloud computing and Microsoft technologies. He loves to break complex problems into manageable chunks of meaningful information.