Network Management

Report Writer error in the Orion Web Console

This article addresses an issues that generates are Report Writer error in the Orion Web Console. Error: System.ApplicationException: Field not specified or invalid at SolarWinds.Orion.Web.Reporting.C1QueryWrapper.BuildSQL() at SolarWinds.Orion.Web.Reporting.OrionReport.BuildQuery(StringoederBy, String Grouping, String filter) at SolarWinds.Orion.Web.Reporting.Reportrunner.WorkerProc(object state)

First published date

10/29/2018 12:50 PM

Last published date

6/30/2020 7:03 AM

Overview

Report writer report displays the following error in the Orion Web Console:
  
System.ApplicationException: Field not specified or invalid at SolarWinds.Orion.Web.Reporting.C1QueryWrapper.BuildSQL() at SolarWinds.Orion.Web.Reporting.OrionReport.BuildQuery(StringoederBy, String Grouping, String filter) at SolarWinds.Orion.Web.Reporting.Reportrunner.WorkerProc(object state)

 

Product section

Orion Platform

Cause

  • The report includes an older field (such as Vendor) without a space.  
  • Schema may have been corrupted.

Resolution

Resolution #1:

  1. Remove and replace the old field.
  2. Re-create the report.

Resolution #2:

  1. Log on to the SolarWinds server.
  2. Go to SolarWinds installation folder. By default it is on C:\Program Files (x86)\SolarWinds\Orion
  3. On the search box, apply this search *Report*.schema
  4. This should show around 13 files or less.
  5. Rename all of them with appending suffix '.backup' so OrionReportWriter.schema turns into OrionReportWriter.schema.backup
  6. Run the Report Writer application again.
  7. It will show a wizard window, just let it finish. When Configuration Wizard starts automatically, just click Cancel as the schemas have been rebuilt.
  8. Check the report again.