Network Management

Missing PDF files from a scheduled report after failed migration of Solarwinds

This article details an issue in which there are missing PDF files in scheduled reports that send emails after a failed migration in Solarwinds. The missing PDF attachments shows errors in the Core.BusinessLayer.log

First published date

11/8/2018 12:46 AM

Last published date

3/7/2022 8:21 AM

Overview

This article details an issue in which there are missing PDF files in scheduled reports that send emails after a failed migration in Orion. The missing PDF attachments show errors in the Core.BusinessLayer.log (C:\ProgramData\SolarWinds\Logs\Orion): 

ERROR SolarWinds.Orion.Core.BusinessLayer.ReportJobInitializer - (null)  Errors in ReportJob-2(SCHEDULE_NAME) @ Engine 0 & Website 2 
Invalid URL /Orion/Report.aspx?ReportID=116

Product section

Orion Platform

Cause

This is caused when WebsiteIDs were changed when running the Configuration Wizard after a failed migration. The report schedule is calling a WebsiteID that no longer exists in the database.

Resolution

  1. Stop all Orion services using Orion Service Manager.
  2. Verify the existing WebsiteIDs in the database:
    1. Open Database Manager, check the Websites table.
    2. Note the WebsiteIDs and make sure these numbers match the WebsiteIDs from the ReportJobs table.
  3. Update the ReportJobs table with the WebsiteIDs existing in the Websites table.
    1. Run the following query to your database using Database Manager to replace incorrect WebsiteIDs:
-- 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 ReportJobs SET WebsiteID = CorrectID WHERE WebsiteID = WrongID
  1. Change CorrectID with the existing WebsiteID and WrongID with the missing WebsiteID.
  2. Restart all Orion services using Orion Service Manager.
Note: A restart of Orion services may not be needed.