LazyUpgradeStatus Migration fails with "Invalid Object Name" error in SolarWinds Platform 2025.4

10/21/2025 12:00 PM

10/21/2025 12:00 PM

A sample error has been shown in the below image:




System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'APM_ComponentStatus_Hourly'

This occurs when a referenced table is dropped before its dependent table.

Orion Platform

1. Connect to the SQL server and open SQL Server Management Studio.
2. Log in to SSMS with SQL Admin credentials.
3. Take a backup of the SolarWinds Platform database.
4. Open a new query window, paste the query below, and select Execute query: 
   

-- 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 '%detail errors%' AND EndDateUtc IS NULL;

5. Verify if the above query works by executing the below query:
   
   

   -- 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.
   
   Select * from LazyUpgradeStatus where Tablename LIKE 'APM_%' and EndDateUtc IS NULL

   
   This should return zero rows.
   
   
6. Users can go to the web console, click on the Notification and if no records are listed on the table, the migration has been completed. The notification will be cleared the next day.