This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SWQL Issues with NCM.Nodes Table

vangesseld over 4 years ago

Greetings Thwack,

Since upgrading to Orion Core 2019.2, NCM 8.0, I've been experiencing issues with SWQL queries against the NCM.Nodes table.

Any SWQL query I write in SWQL Studio or in a Custom Query widget that involves the NCM.Nodes table always seems to return 0 rows. This issue even happens in SWQL Studio when I right-click the NCM.Nodes table and do 'Generate Select Statement'.

I know that my queries are valid though, as when I write the same queries using the OrionSDK, I'm able to view the results if I print them out in my script.

I'm kind of at a loss here on how to troubleshoot this. I've updated SWQL Studio to the latest version and there was no change. I didn't decide to post this until I discovered the same problem seems to exist when trying to create a Custom Query widget.

Any advice you guys can offer would be super helpful. Please let me know if this should be posted into the OrionSDK board instead.

Thanks in advance!

EDIT: I got the widget working, it doesn't like when you limit the results by using SELECT TOP #, but I still have issues with SWQL Studio it seems.

Message was edited by: Chuck van Gessel

Top Replies

Parents

0 wesleykparker over 4 years ago

I also recently upgraded to the same platform.
I'm am having the same issue. It seems to be related to the [dbo].NCM_Nodes (View)..
When I attempt to show this in the Database manager I get the following error.
SELECT TOP 1000 * FROM [dbo].[NCM_Nodes]
-----------------------------------------------------------------------------------------------------
Msg 8153, Level 0, State 1, Line 1
Warning: Null value is eliminated by an aggregate or other SET operation.
If I look at the (dbo.NCM_Nodes) view from SQL Studio, it works fine.
Cancel
Vote Up 0 Vote Down

Cancel
0 wesleykparker over 4 years ago in reply to wesleykparker

I've located the source of the trouble. The query to create the NCM_Nodes view has a problem. The query runs in SQL Studio but flags for the same issue as why the Database Manager errors and displays no output. I was able to fix the query for the View, but haven't implemented the changes in our DB until I hear back from SolarWinds Support. I created case 00404266 to track.
I'm not sure if they flipped some global setting that is causing the problem, hence may be causing trouble with other Views in the DB, or if they just happened to change this View query and it needs to be corrected.
Cancel
Vote Up +2 Vote Down

Cancel

Reply

0 wesleykparker over 4 years ago in reply to wesleykparker

I've located the source of the trouble. The query to create the NCM_Nodes view has a problem. The query runs in SQL Studio but flags for the same issue as why the Database Manager errors and displays no output. I was able to fix the query for the View, but haven't implemented the changes in our DB until I hear back from SolarWinds Support. I created case 00404266 to track.
I'm not sure if they flipped some global setting that is causing the problem, hence may be causing trouble with other Views in the DB, or if they just happened to change this View query and it needs to be corrected.
Cancel
Vote Up +2 Vote Down

Cancel

Children

No Data