"SolarWinds.Orion.LogMgmt.Maintenance.LogMaintenancePlugin - Failed to remove partitions in Log" error in Database Maintenance on the SolarWinds Platform

From the Web Console, upon looking at the My Deployment Page, you will see the critical error for Check if Database Maintenance works properly.

The following can be seen in the log at C:\ProgramData\SolarWinds\Logs\Orion\swDebugMaintenance.log on the SolarWinds Platform server:

ERROR SolarWinds.Orion.LogMgmt.Maintenance.LogMaintenancePlugin - Failed to remove partitions in Log , Attempt #1, ErrorNumber 596
System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command.  The results, if any, should be discarded.

ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngineHelper - Action failed for plugin [SolarWinds.Orion.LogMgmt.Maintenance.LogMaintenancePlugin]
System.Exception: Failed to remove partitions.

ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 0.99s Plugin action - LogMaintenancePlugin->PreMaintenace for Orion.LogMgmt
Message:
--------------------------------------------
Failed to remove partitions.
--------------------------------------------

The SQL Server lacks a certain cumulative update.

NOTE:

• Before making any changes, make sure that you have a recent database backup, a snapshot of the VM, or a restore point of the physical server.
• Work with your DBA for any database-related concerns.

1. Install the Cumulative Update: Cumulative Update 29 for SQL Server 2019
2. Run Database Maintenance manually and confirm it completes.
3.  Go back to the My Deployment Page and confirm whether the Check if Database Maintenance works properly notification is cleared.