Invalid object name 'APM_ProcessEvidence_Detail' occuring in the Core Business Layer logs

After you upgrade SolarWinds Platform from 2020.1 to 2020.2.6 with large historical tables or there were DB maintenance issues in the past you may see errors like below in Core.BusinessLayer.log post upgrade to 2020.2.6 or 2022.x 2023.x

ERROR SolarWinds.Orion.Core.Common.Upgrade.MigrationToTimeSeries - (null)  Error while running 
CREATE OR ALTER VIEW [dbo].[APM_ProcessEvidence_Detail_Error_upg] AS

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'APM_ProcessEvidence_Detail'.
SolarWinds.Orion.Core.Common.Upgrade.MigrationToTimeSeries.ExecuteNonQuery(String sqlStatement, SqlParameter[] sqlParamValues, Func`2 cmdFactory)

1. DB Maintenance was not completing/partially completed due to DB performance issue
2. Large tables due to long historical retention settings for APM data

Important! Before making any changes to the SolarWinds database, please make sure a recent database backup is taken or completed.

1. RDP to SolarWinds Main poller
2. Click Start > Launch Database Manager
3. Execute the query below query against on the Orion database, you should not get any errors

-- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation.
UPDATE [LazyUpgradeStatus]
   SET MigratedRowCount = InitialTotalRowCount,
   LastUpdateDateUtc = GETUTCDATE(),
   EndDateUtc = GETUTCDATE()
WHERE Description Like 'APM_%'
   AND EndDateUtc IS NULL;

4. Restart module engine service via SolarWinds Platform Service manager (Disable HA if you have HA).
5. Verify the file C:\programdata\Solarwinds\Logs\Orion\Core.BusinessLayer.log for any new errors