I created a custom poller and then added it to a home page view. After editing the source to choose the customer poller the following error is displayed:
SQL Open Error: Incorrect syntax near the keyword 'Where'.
Another account I use it shows up fine and I can't find the difference. I am afraid to remove it and re-add to the one that is working.
Anyone know what might be wrong?
EDIT: If I drill down to the device the custom poller applies to, it shows just fine under that device.
Thanks
Custom Poller SQL error
-
-
-
BakerD
I have this exact same problem and an open ticket with SW support for this going on three + weeks now.
The account with restricted view that has the problem for me is restricted to a list of specific nodes (about 90). I have a custom MIB poller looking at an OID on some cisco gear to show the state of a service running. In the view they are restricted to seeing it shows the same SQL error you posted about.
My ticket was escalated to level 2 but they have made no progress on the issue.
My suspicion is that since the account has a restriction to only certain nodes, but the SQL query that occurs to display the status on the home page for the cutom poller view doesnt run JUST against the group of restricted nodes but queries against ALL nodes (I may be wrong about that but its my suspicion). Since the restricted account is not allowed to view ALL nodes, the sql query errors out due to the restriction even though the result if the query completed would only display status of a node the account was allowed to see.
I've offered this suggestion to support but so far they have no answers. If you figure this out before they do let me know! But you are not alone on this one
-
quote:Originally posted by clanger
BakerD
I have this exact same problem and an open ticket with SW support for this going on three + weeks now.
The account with restricted view that has the problem for me is restricted to a list of specific nodes (about 90). I have a custom MIB poller looking at an OID on some cisco gear to show the state of a service running. In the view they are restricted to seeing it shows the same SQL error you posted about.
My ticket was escalated to level 2 but they have made no progress on the issue.
My suspicion is that since the account has a restriction to only certain nodes, but the SQL query that occurs to display the status on the home page for the cutom poller view doesnt run JUST against the group of restricted nodes but queries against ALL nodes (I may be wrong about that but its my suspicion). Since the restricted account is not allowed to view ALL nodes, the sql query errors out due to the restriction even though the result if the query completed would only display status of a node the account was allowed to see.
I've offered this suggestion to support but so far they have no answers. If you figure this out before they do let me know! But you are not alone on this one
I have submitted a case on this too. -
-
-