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?
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, '').