Skip to the content
The Update Bureau
SQL Server 2022 CU11 SQL Server 2022 CU11 Cumulative update

KB5032679

KB5032679: Cumulative update for SQL Server 2022, CU branch, January 2024. SESSION_CONTEXT errors remain; 16 fixes included

In short

Includes 16 fixes for SQL Server 2022. An issue that can make SESSION_CONTEXT return wrong results or produce access-violation dumps in parallel queries remains open.

Does it affect you? Applies to: SQL Server 2022 instances with components covered by the update. The package updates only components already installed on the instance; reapply it if you add a feature later.

Build
16.0.4105.2
Servicing branch
CU
Restart
Required

For servers on the CU branch: they install cumulative updates, which also bring fixes beyond security. Servers on the GDR branch (security fixes only) get a separate update. Which branch am I on?

What changes

Fixes 16 changes

Master Data Services

2 items
  • Find Parent works when its target is a node found by search.1
  • Downloading an attachment works when a newly created entity uses a code value found in a deletion record.2

SQL Connectivity

  • A dump and INVALID_POINTER_WRITE_c0000005_sqllang.dll!CBatch::PTaskGetWithAddRef exception can occur under a failure condition involving a connection object; this issue is fixed.3
    The issue can occur when the session monitor's reference to a connection object isn't released, leaving dangling session objects.

Column Stores

  • A string-column point search on an In-Memory OLTP columnstore table no longer encounters the specified access violation.4
    Fixes the access violation at InitCollationSensitiveLookupHash.

High Availability and Disaster Recovery

2 items
  • Creating a contained availability group no longer causes a dump and makes the SQL Server instance stop responding in the described login-role configuration.5
    The condition involves a login with the sysadmin role and other server-level roles that exist only in the SQL Server instance.
  • Dropping a distributed availability group with a suspect AG database on a forwarder no longer causes the specified access-violation dump.6

PolyBase

  • Queries of delta tables run faster after the OPTIMIZE operation in S3-compatible object storage. Query performance also improves for delta tables in Azure Blob Storage and Azure Data Lake Storage Gen2.7

Query Execution

3 items
  • Some query plans with nested loop joins in batch mode no longer encounter the specified intra-query deadlock.8
  • Using the LIKE predicate no longer encounters the specified assertion failure.9
    The assertion is Location: IntSafeWrapperRetail.cpp:31; Expression: !"Arithmetic operation failed".
  • Cardinality Estimation feedback no longer generates an empty USE HINT clause as a query hint.10

Replication

  • The distribution agent no longer fails in the described transactional replication setup with memory-optimized tables at a subscriber.11
    The subscriber uses the "replication support only" option; this fixes error 12302 from MSupd_articlename when the subscription is created with @sync_type = "replication support only".

Search

  • DBCC CHECKDB no longer fails with error 2601 when checking a cloned database in the described partitioned full-text index scenario.12
    The scenario involves a full-text index fragment partitioned because it is too large.

Security Infrastructure

  • sp_helplogins no longer returns error 9833 when run against a database with UTF-8 character encoding.13

SQL OS

2 items
  • The non-yielding scheduler dump issue on hardware with more than 64 logical processors per NUMA node is addressed. At startup, SQL Server now detects that configuration and shuts down the service.14
    Addresses the sqldk!SOS_Node::SpreadMultipleTasksAcrossNodes dump issue; the service shutdown is an intentional response when a machine has more than 64 logical processors per NUMA node.
  • The specified Stalled Resource Monitor dump issue after out-of-memory exceptions, such as error 701, is fixed.15

Deployment Platform

  • SQL Server Setup detects a conflicting OLE DB Driver feature condition and blocks a new installation instead of failing while adding SQL_SNAC_SDK.16
    The condition is a later SQL_SNAC_CORE feature version in msoledbsql.msi than the version on the SQL Server installation media. The page gives a workaround: in Control Panel, open Uninstall or change a program, select Microsoft OLE DB Driver for SQL Server, choose Change, install all features in its Setup, and rerun SQL Server Setup.

Improvements 2 changes

SQL Server

  • The SQL Server product build updates to 16.0.4105.2.17
    The file version is 2022.160.4105.2.

Analysis Services

  • The Analysis Services build updates to 16.0.43.222.18
    The file version is 2022.160.43.222.

Known issues

  1. Open Affects: Everyone

    Incorrect behavior of SESSION_CONTEXT in parallel plans

    Queries using SESSION_CONTEXT might return incorrect results or trigger access-violation dump files when run in parallel query plans, particularly if the session is reset for reuse. The issue remains open.19

    Workaround status No workaround yet

    Microsoft has not published a manual workaround for this issue yet. Monitor release health until a resolving update is available.

  2. Resolved Affects: Organizations and IT administrators Resolved by KB5031778

    Issue one: Read-scale availability group not displayed in dm_hadr_database_replica_cluster_states

    A CU10 fix caused the Availability Databases folder in SQL Server Management Studio not to show databases in read-scale availability groups. This issue is fixed in SQL Server 2022 CU12.20

    Resolution Fixed in KB5031778

    Install KB5031778 (or a later cumulative update) on affected devices. No manual workaround is required after updating.

Technical details

Data sheet · Security · Downloads · Components Click to collapse or expand

Data sheet

Released
2024-01-11
Classification
Updates
Type
Cumulative update
Servicing branch
CU
Restart
Required
Replaced by
KB5033663
VersionBuildChannel
2022 16.0.4105.2 General availability

Security

No vulnerabilities are listed for this update.

Downloads (Microsoft Update Catalog)

Package 2022
400.5 MB
sqlserver2022-kb5032679-x64.exe Main update · KB5032679 SHA-1: a3adcca1…8a21cc

Sources

Updated
Cited passages from Microsoft's official notes (20)
  1. 1. Fixes an issue in which the Find Parent feature fails if the target of the feature is a node that is searched. support.microsoft.com
  2. 2. Fixes an issue in which downloading an attachment fails if an entity newly created uses a code value existing in a deletion record. support.microsoft.com
  3. 3. Fixes a dump issue and INVALID_POINTER_WRITE_c0000005_sqllang.dll!CBatch::PTaskGetWithAddRef exception that you might encounter support.microsoft.com
  4. 4. Fixes an access violation at InitCollationSensitiveLookupHash that you encounter when running a string column point search on an In-Memory OLTP columnstore table. support.microsoft.com
  5. 5. Fixes an issue in which the creation of a contained availability group fails with a dump generated support.microsoft.com
  6. 6. Fixes an access violation dump issue that you encounter when dropping a distributed availability group (AG) that has a suspect AG database on a forwarder. support.microsoft.com
  7. 7. Fixes a performance issue in query execution time that you encounter after you run the OPTIMIZE operation for a delta table in S3-compatible object storage. support.microsoft.com
  8. 8. Fixes an intra-query deadlock that you might encounter when running some query plans that involve nested loop joins in batch mode. support.microsoft.com
  9. 9. Fixes an assertion failure (Location: IntSafeWrapperRetail.cpp:31; Expression: !"Arithmetic operation failed") that you encounter while using the LIKE predicate. support.microsoft.com
  10. 10. Fixes an issue in which the Cardinality Estimation (CE) feedback generates an empty USE HINT clause as the query hint. support.microsoft.com
  11. 11. Fixes an issue in which the distribution agent fails when you set up transactional replication with memory-optimized tables at the Subscriber support.microsoft.com
  12. 12. In this scenario, the command fails and the following error 2601 occurs support.microsoft.com
  13. 13. Fixes the following error 9833 that you encounter when running the sp_helplogins stored procedure against a database with UTF-8 character encoding support.microsoft.com
  14. 14. After applying the fix, SQL Server detects machines that have more than 64 logical processors per NUMA node at startup and shuts the SQL Server service down. support.microsoft.com
  15. 15. Fixes a "Stalled Resource Monitor" dump issue that you might encounter after out-of-memory (OOM) exceptions are raised, such as error 701. support.microsoft.com
  16. 16. After applying the fix, SQL Server Setup detects this condition, and it will block a new installation and prevent a failure during the installation. support.microsoft.com
  17. 17. SQL Server - Product version: 16.0.4105.2, file version: 2022.160.4105.2 support.microsoft.com
  18. 18. Analysis Services - Product version: 16.0.43.222, file version: 2022.160.43.222 support.microsoft.com
  19. 19. 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. support.microsoft.com
  20. 20. This issue is fixed in SQL Server 2022 CU12. support.microsoft.com
Checked automatically: 8 of 8 checks passed, 20 quoted passages · compared with Microsoft's page on Oct 20, 2026
  • Quotes found in the official pages: passed
  • Numbers found in the sources: passed
  • Vulnerabilities from the dossier only: passed
  • Links to allowed domains only: passed
  • Every official change covered: passed
  • Readable plain text: passed
  • Changes confirmed by the file list: passed
  • Sources agree: passed

A second AI read the text against the sources: correctness 5/5, clarity 4/5, completeness 4/5. How we work

Published by The Update Bureau. Written with AI from Microsoft's own documents, checked by rules and a second AI. How we work · Report a mistake