After migrating to VMware and upgrading to NPM 10.3.1 all custom SQL filters are now displaying the error message "Custom SQL filter is incorrectly formatted." Example filter is below.
InterfaceName like '%Async%' AND Jurisdiction != 'Data Center'
Is the Jurisdiction property a node or interface property? If you remove and re-add the filter, does this work? You may also want to look in the ResourceProperties table in the database and make sure there are no entries with a ResourceID of 0. This could cause some issues. If they are there remove them with:
Delete From ResourceProperties
Where ResourceID = 0
If there is nothing along those lines, look at the Limitations table. If there are limtitations where the WhereClause column has 1=1, then this could also cause issues. You could remove these with the following:
Delete From Limitations
Where WhereClause LIKE '1=1'
Regards,
Matthew Harvey
Loop1 Systems
http://www.loop1systems.com
Matthew,
I work with Jennifer and we did have the 1=1 limitations present in the WhereClause column. Those have been removed using the script as you suggested. Now we will see what effect the change has on the filters.
We have run across a number of little "blips" like this after the upgrade process was completed, but we are working through them slowly.
Thanks for the help!
Glad to help out. If you run into anything else, just let me know.
