"SAM Database Maintenance Is Overdue" after upgrading to SolarWinds Platform 2022.4 to 2023.2

2/22/2023 12:42 PM

2/9/2025 6:50 PM

After upgrading to SolarWinds Platform  2022.4 to 2023.2, SAM database maintenance is not completed in the notification bar.

In the swdebugMaintenance.log, the following error message may appear multiple times:

ERROR SolarWinds.Data.DatabaseMaintenance.TimeSeriesTableHandler - Retention interval settings not specified

Server Application Monitor

This issue occurs because retention settings are not correctly read for several database tables impacting the following software release versions:

• SolarWinds Platform 2022.4
• SolarWinds Platform 2023.1
• SolarWinds Platform 2023.2

To resolve this issue, please upgrade to SolarWinds Platform 2023.3 and above.  If upgrade is not possible, please before the workaround below:

Workaround:

Using database maintenance, delete the old data from ComponentStatus_CS_Detail_hist table.

Backup the database before and use the Database Manager to run the query below

DELETE FROM [dbo].[APM_ComponentStatus_CS_Detail_hist] 
WHERE "timestamp" < DATEADD(day, -7, GETDATE())

-- 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.