Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
KB5033663 - Cumulative Update 12 for SQL Server 2022
Release Date: March 14, 2024
Version: 16.0.4115.5
Summary
This article describes Cumulative Update package 12 (CU12) for Microsoft SQL Server 2022. This update contains 51 fixes that were issued after the release of SQL Server 2022 Cumulative Update 11, and it updates components in the following builds:
- SQL Server - Product version: 16.0.4115.5, file version: 2022.160.4115.5
- Analysis Services - Product version: 16.0.43.229, file version: 2022.160.43.229
Note
SQL Server 2022 CU6 enabled Microsoft Entra authentication for SQL Server replication. After you install SQL Server 2022 CU12, this feature will be generally available. For more information, see Configure replication with Microsoft Entra authentication.
Microsoft Entra authentication for replication can be disabled by using trace flag 11561.
Known issues in this update
Incorrect behavior of SESSION_CONTEXT in parallel plans
Queries that use the built-in SESSION_CONTEXT function might return incorrect results or trigger access violation (AV) dump files when run in parallel query plans. This issue occurs because of the manner in which SESSION_CONTEXT interacts with parallel execution threads, particularly if the session is reset for reuse.
For more information, see the Known issues section in SESSION_CONTEXT.
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 2022, 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 "#NNNNNNN" 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 |
|---|---|---|---|---|
| 2860396 | Fixes an access violation that you might encounter when adding or deleting an empty partition with row-level security (RLS) on a table. | Analysis Services | Analysis Services | Windows |
| 2864688 | Fixes an issue in which running Data Analysis Expressions (DAX) queries failed with error "Memory Allocation failure" even though the SQL Server Analysis Services instance still has a lot of available memory. | Analysis Services | Analysis Services | Windows |
| 2888483 | Fixes a performance degradation that might be encountered during the execution of the ProcessAdd command, which causes an increase in CPU usage and execution time. |
Analysis Services | Analysis Services | Windows |
| 2859818 | Fixes an issue that might cause a recursive hierarchy to fail to load all levels. | Master Data Services | Master Data Services | Windows |
| 2868247 | Fixes an issue in which an upgrade process in Master Data Services models might fail if you set an inappropriate entity name such as "Entity". | Master Data Services | Master Data Services | Windows |
| 2969541 | Adds the support of the Extensible Key Management (EKM) feature for SQL Server on Linux. | SQL Connectivity | Linux | Linux |
| 2920697 | Fixes an issue in which the SQLdiag tool doesn't start when trying to read the default XML configuration file. Additionally, you receive the following error message: <DateTime> SQLDIAG Output path: <FolderPath> <DateTime> SQLDIAG Failed to load XML configuration file: ErrCode:0xC00CE169,Reason:"'16' violates enumeration constraint of '7 8 9 10 10.5 10.50 11 12 13 14 15 *'. |
SQL Server Client Tools | SQLDiag | Windows |
| 2846022 | Fixes an issue in which a Volume Shadow Copy Service (VSS) restore process with the Restore with Move feature might restore an incorrect file or fail if the file path for the .mdf file includes a trailing space. Additionally, you receive the following error message if the restore process fails: NativeError: 1384 The file '<FilePath> ' cannot be overwritten. It is being used by database '<DatabaseName>' |
SQL Server Engine | Backup Restore | Windows |
| 2804318 | Fixes an issue that might cause the database file to be associated with an incorrect filegroup in the clone database created by using DBCC CLONEDATABASE. |
SQL Server Engine | DB Management | All |
| 2347023 | Fixes an issue in which the automatic seeding operation for a database remains in LIMIT_CONCURRENT_BACKUPS after adding the database to a new availability group or an existing one created with automatic seeding, even though this SQL Server instance doesn't have any other active seeding, virtual device interface (VDI), or backup threads. |
SQL Server Engine | High Availability and Disaster Recovery | All |
| 2824982 | Prevents the creation of read-scale availability groups that have a large number of databases to avoid the subsequent assertion failure (Location: ucsconnectionsend.cpp:103; Expression: 'm_pcscBoxcar->GetMessageCount () > 0'). | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 2834436 | Fixes an issue in which the database audit might not record the action when a database audit specification is initially created against the instance name (not the contained availability group listener), and future transactions are executed against the contained availability group listener. | SQL Server Engine | High Availability and Disaster Recovery | All |
| 2893030 | Fixes an issue in which the global primary or forwarder in a distributed availability group can't connect to the listener of the other availability group for a while after the local availability group fails over between replicas in multi-subnet configurations. | SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 2923126 | Fixes an issue that you encounter in sys.dm_hadr_database_replica_cluster_states for read-scale availability groups after you install SQL Server 2022 CU10 or later versions, which causes the Availability Databases folder in SQL Server Management Studio (SSMS) not to show the databases in the availability group (AG). |
SQL Server Engine | High Availability and Disaster Recovery | Windows |
| 2937584 | Fixes an issue in which the sp_server_diagnostics stored procedure doesn't respond to the Always On availability group (AG) resource DLL within the HealthCheckTimeout when the I/O takes a long time, which causes unnecessary restart and failover. For example, when the sp_server_diagnostics stored procedure is waiting for the PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE wait type. Note: To apply this fix, you need to turn on trace flag 16301, which is off by default. Tracing is added for this event regardless of the trace flag. |
SQL Server Engine | High Availability and Disaster Recovery | All |
| 2845380 | Removes the following incorrect error that's related to ca-certificates when starting SQL Server on Linux: Error searching first file in /var/opt/mssql/security/ca-certificates |
SQL Server Engine | Linux | Linux |
| 2920073 | Fixes an issue in which an unreliable network connection causes an unsuccessful status during backup to a network share, which causes the SQL Server instance to stop responding. | SQL Server Engine | Linux | Linux |
| 2958874 | Fixes an issue in which the SQL Server instance fails to start on Linux kernels 6.7 and later versions. | SQL Server Engine | Linux | Linux |
| 2768282 | Fixes an assertion failure (Location: "sql\\ntdbms\\storeng\\dfs\\trans\\PageFlush.cpp":1840; Expression: IS_OFF (BUF_LOG_BUFWRITE, buf->bstat) || IS_ON (BUF_DIRTY, buf->bstat) || m_ownerXdes->GetPru ()->IsSuspect ()) that you encounter when running the BULK INSERT statement. |
SQL Server Engine | Methods to access stored data | All |
| 2837848 | Fixes a deadlock issue that you encounter when creating or updating statistics by turning off the blocking Auto Stats feature. The blocking Auto Stats feature is turned on when you use PolyBase. Turning off the blocking Auto Stats feature might cause a different query plan and execution time because query compilation isn't blocked by statistics collection. | SQL Server Engine | PolyBase | All |
| 2870726 | Fixes an issue in which the exported delimited text file created by using CREATE EXTERNAL TABLE AS SELECT (CETAS) is incorrect if the FIELD_TERMINATOR character is '\t'. |
SQL Server Engine | PolyBase | All |
| 2937200 | Fixes an issue in which running Delta table queries requires the sysadmin server role. For more information, see Delta table query may fail with errors 2571 and 16513. | SQL Server Engine | PolyBase | All |
| 2936186 2936204 2938811 2941532 |
FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 (KB4538581) | SQL Server Engine | Programmability | All |
| 2961007 | Fixes an out-of-memory (OOM) issue that's caused by spikes in CACHESTORE_PHDR usage. |
SQL Server Engine | Programmability | Windows |
| 2833605 | Adds mitigation to avoid an assertion failure (Location: lobss.cpp:707; Expression: 'FALSE' Lob not found for read) that you might encounter when you run a complex query that uses large value data types such as varchar(max). Note: The mitigation doesn't apply in all situations. |
SQL Server Engine | Query Execution | All |
| 2850899 | 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. |
SQL Server Engine | Query Execution | All |
| 2914479 | Fixes a contention issue that you encounter when using sys.dm_exec_query_statistics_xml from multiple concurrent connections. |
SQL Server Engine | Query Execution | All |
| 2695507 | Fixes inconsistent results that are caused by the parallel spool in the plan for the INSERT, UPDATE, or DELETE query. |
SQL Server Engine | Query Optimizer | All |
| 2850915 | 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_ exception. |
SQL Server Engine | Query Optimizer | All |
| 2850932 | 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. |
SQL Server Engine | Query Optimizer | All |
| 2890724 | Fixes an issue that you encounter when references to plan cache entries become dereferenced in memory without allowing the plans to be properly removed from memory. This issue might occur for queries that are analyzed by the Cardinality Estimation (CE) feedback feature. | SQL Server Engine | Query Optimizer | All |
| 2916821 | Fixes an access violation that you encounter when a Plan Cache object type differs from what Cardinality Estimation (CE) feedback expects. In this scenario, CE feedback casts the object type into the expected one and tries to access to a field that doesn't exist in the object type. | SQL Server Engine | Query Optimizer | All |
| 2612953 | Fixes the following error that you encounter in conflict detection and in the Replication Merge Agent when converting the generation to int: Error converting data type bigint to int. |
SQL Server Engine | Replication | All |
| 2693175 | Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group: Msg 20032, Level 16, State 1, Procedure distribution.dbo.sp_MSadd_subscription, Line <LineNumber> [Batch Start Line 33] <SubscriberName> is not defined as a Subscriber for <PublisherName>. Msg 14070, Level 16, State 1, Procedure sys.sp_MSrepl_changesubstatus, Line <LineNumber> [Batch Start Line 33] Could not update the distribution database subscription table. The subscription status could not be changed. Msg 14057, Level 16, State 1, Procedure sys.sp_MSrepl_addsubscription_article, Line <LineNumber> [Batch Start Line 33] The subscription could not be created. |
SQL Server Engine | Replication | All |
| 2864330 | Fixes an issue in which overriding the MakeGenerationInterval parameter that uses a custom value doesn't work properly when you run replmerg.exe. |
SQL Server Engine | Replication | Windows |
| 2870454 | Fixes an issue in which the sp_helpsubscription stored procedure doesn't return any results after an in-place upgrade of the Publisher instance to SQL Server 2022, which causes you to fail to reinitialize the subscription with the following error message: The Subscription does not exist. |
SQL Server Engine | Replication | All |
| 2870518 | Fixes an issue in which the size of the _$update_bitmap column of dbo.conflict_<owner>_<table> doesn't get updated with changes in the number of columns of the original conflicting table, which causes the Distributor agent in peer-to-peer replication to fail with the following error message: String or binary data would be truncated in table '<TableName>', column '<ColumnName>'. Truncated value: "." |
SQL Server Engine | Replication | All |
| 2929215 | Fixes an issue in which error 18482 is caused when using sp_adddistributor to add a remote distributor if the Publisher server name contains lowercase characters and the Distributor server has the case-sensitive (_CS) collation. |
SQL Server Engine | Replication | All |
| 2877337 | Adds the following fields to the sqlserver.fulltext_filter_usage Extended Event (XEvent) to improve the telemetry reporting for the XEvent: - min_input_size - max_input_size - min_output_size - max_output_size |
SQL Server Engine | Search | Windows |
| 2956576 | Fixes an overflow issue of the word occurrence that you encounter during the full-text merging process. | SQL Server Engine | Search | All |
| 2917001 | Adds support for iterated and salted hash password verifiers. This is a more secure process than simply storing the SHA-512 hash of the password. This feature is available only in SQL Server 2022 CU12 and later versions. For more information, see Support for Iterated and Salted Hash Password Verifiers in SQL Server 2022 CU12 | SQL Server Engine | Security Infrastructure | All |
| 2907888 | Fixes an issue that causes the SQL Server Agent to terminate with the following error message: Exception 5 caught at line <LineNumber> of file <FileName>. SQLServerAgent initiating self-termination. |
SQL Server Engine | SQL Agent | All |
| 2830811 | Adds trace flag 2616 to enable the stack signature feature when a dump occurs on a SQL Server instance, which avoids multiple dumps for the same exception. | SQL Server Engine | SQL OS | All |
| 2899892 | Makes the following improvements to the compressed memory dump feature: - Adds the use of the FILE_FLAG_NO_BUFFERING flag to improve I/O performance and prevent excessive growth of the file cache. - Adds the dynamic auto-tuning parallelism to the feature to take advantage of the available CPU cores. |
SQL Server Engine | SQL OS | Windows |
| 2956541 | Before the improvement, a generic error message (configuration error during initialization) is reported when creating an event_file target for an Extended Events session if the Azure blob target is invalid. After applying the improvement, the error will be reported more specifically, such as "due to invalid or expired credentials." |
SQL Server Engine | SQL OS | All |
| 2153698 | Adds a link to error 824 to improve the troubleshooting experience. For more information, see MSSQLSERVER_824. Error Message: SQL Server detected a logical consistency-based I/O error: <Incorrect PageID>. It occurred during a <Read/Write> of page <PageID> in database ID <DatabaseID> at offset <Offset> in file '<FileName>'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see https://go.microsoft.com/fwlink/?linkid=2252374. |
SQL Server Engine | Storage Management | All |
| 2766481 | Fixes an access violation dump issue that you might encounter when resuming an index rebuild that includes partitions (for example, ALTER INDEX [index_name] ON [schema].[TableName] RESUME WITH ( MAX_DURATION = 1, MAXDOP = 1 )). |
SQL Server Engine | Table Index Partition | All |
| 2820084 | Fixes a non-yielding scheduler issue due to spinlock contention on the Redo Manager on secondary replicas of an availability group. | SQL Server Engine | Transaction Services | All |
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?