Network Management

Manually delete Orion Legacy Reports when Report Migration Tool cannot.

This article will go over how to remove the legacy reports from Orion when installing 2020.2.6 HF4

First published date

3/6/2022 8:35 PM

Last published date

10/30/2025 9:54 PM

Overview

You will see this error when upgrading, forcing you to do migrate the legacy reports.
image.png

"Failed to migrate report(s). Check the Solarwinds.ReportMigrationTool.log file for details."

Failed to migrate report(s). Check the Solarwinds.ReportMigrationTool.log file for details.png

Product section

Orion Platform

Resolution

  1. First, try to migrate ALL the legacy reports through the migration tool.
Please note: The migration tool will not make the warning in the SolarWinds Active Diagnostics go away until the remaining steps are followed.
  1. Optional: Delete the reports folder. Default location C:\Program Files (x86)\SolarWinds\Orion\Reports
  2. Run SQL script to delete all the legacy reports saved in the default location.
-- 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.

Delete from ReportDefinitions where LegacyPath = '\Reports'
  1. Try rerunning the installer checker again. The legacy report warning will be gone now.