Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

EOC 1.6.2 SWQL queries issue

Hi Everyone. I recently upgraded from EOC 1.5 to 1.6.2 and after that our Filter Nodes SQL doesnt work at all. Below the Filter Nodes SQL we are using which worked fine in EOC 1.5.

Node.CustomProperty.Service <> 'CEC' and Node.CustomProperty.Service <> 'Production' and Node.CustomProperty.Service <> 'CEC-ICMP'

Error Message:

There was a problem with the resource.

The data types ntext and varchar are incompatible in the not equal to operator.

I tried removing Dot but its still the same. Is there any changes i can do on it to make it work ?

Find more posts tagged with

Accepted answers

All comments

ctmidnight

I am now having this issue in several of our EOC dashboard views after simply cycling the product following license renewal... This is an issue between the EOC filter stack and what it maps to datatypes from the SWIS API.

This has always been a fragile ship (like everything in the 1.x EOC), but the issue because more aggravated once users upgraded to NPM 11.5.x and SAM 6.2

Did you open a ticket on this, an have you received any response or workaround besides waiting for EOC 2.0 yet?

FormerMember

Hi,

I opened a ticket with support and issue is fixed now after applying hotfix4.

Best Regards

Vijay Khatri

Sent thru iphone

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of