NPM 9.5 Web error on Custom SQL Report

branfarm

I'm trying to pull a custom SQL report from the web interface but I'm receiving this error:

 

System.ArgumentNullException: Value cannot be null. Parameter name: s at System.IO.StringReader..ctor(String s) at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options) at System.Xml.Linq.XDocument.Parse(String text) at SolarWinds.Orion.Web.Reporting.OrionReport.ApplyLayoutGroupingSort(String grouping, String& sort) at SolarWinds.Orion.Web.Reporting.OrionReport.BuildQuery(IC1QueryProxy c1host, String orderBy, String grouping, String filter) at SolarWinds.Orion.Web.Reporting.OrionReport.BuildQuery(String orderBy, String grouping, String filter) at SolarWinds.Orion.Web.Reporting.ReportRunner.WorkerProc()

 

The report works inside the Report Writer, and it worked fine in the previous release.  Any ideas?

 

Thanks,

 

--Brandon

John.Taylor

Hi Brandon,

 

Sounds like there is a NULL value in the database table.   Please open a support ticket on this item and reference this Thwack thread.

You can try to work around the issue by identifing the column and wrap it with ISNULL(MyColumn, '').

 

- John