Node uptime report not working anymore in NPM9.5

Hi,

i have another question.....
Since i upgraded to 9.5 my Node uptime report does not seem to work anymore....

SELECT Nodes.Site_code,VendorIcon,Caption,Ip_Address,
DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
FROM Nodes
WHERE DateDiff(hour,Nodes.LastBoot,GetDate()) < '24'
ORDER BY 1,5 ASC

In the reportmaker under preview looks good but when i save it i get the following message:

"Detected usage of a Macro which links to a nonexistent field in the report. Therefore WebURL, which usages this macro, will not be generated correctly. Missing Fields: NodeID"

The report shown in the webconsole is giving the following 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()

Anybody any suggestions??

Find more posts tagged with

report_writer

node_uptime_report

preview

Accepted answers

All comments

John.Taylor

Please open a support ticket and reference this post.

Thanks

John

Mars

Case # 97985 Created

rslegers

I have the same issue after the upgrade to V9.5. Did you already receive some information from the support desk?

bleearg13

I, too, had this same issue with a Custom SQL report. I had to remove the WebURL from the "Field Formatting" portion of my report. After doing this, the report would display again on the website.

BakerD

Hi,
i have another question.....
Since i upgraded to 9.5 my Node uptime report does not seem to work anymore....
SELECT Nodes.Site_code,VendorIcon,Caption,Ip_Address,
DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
FROM Nodes
WHERE DateDiff(hour,Nodes.LastBoot,GetDate()) < '24'
ORDER BY 1,5 ASC
In the reportmaker under preview looks good but when i save it i get the following message:
"Detected usage of a Macro which links to a nonexistent field in the report. Therefore WebURL, which usages this macro, will not be generated correctly. Missing Fields: NodeID"
The report shown in the webconsole is giving the following 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()
Anybody any suggestions??

I'm running 9.5.1 and with a few of my own tweaks it is working

SELECT NodeID,VendorIcon,Caption,Ip_Address,
DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
FROM Nodes
WHERE DateDiff(hour,Nodes.LastBoot,GetDate()) > '1'
ORDER BY 5 DESC

Thanks

EDIT: Turns out you have to leave the HoursUp Formating field left to "No Formatting" and this is just give hours. If set to time I get the error posted a few posts back.