Monitor naming creates error
Hi,
I dont know where is the best place to submit this, but I found a "bug".
When creating a custom monitor, the interface allow the ' character, however, when trying to change the Treshold on the monitor with a name containing a ', an error occur, since it screw up the SQL query.
Here's an example of what I got in the Error Log when I clicked Ok on the Treshold change pane.
13:56:13:687 PM Exception while executing the SQL SELECT PolledData.NAME , PolledData.ID , PolledData.AGENT , PolledData.COMMUNITY , PolledData.PERIOD , PolledData.ACTIVE , PolledData.OID , PolledData.LOGDIRECTLY , PolledData.LOGFILE , PolledData.SSAVE , PolledData.THRESHOLD , PolledData.ISMULTIPLEPOLLEDDATA , PolledData.PREVIOUSSEVERITY , PolledData.NUMERICTYPE , PolledData.SAVEABSOLUTES , PolledData.TIMEAVG , PolledData.PORT , PolledData.WEBNMS , PolledData.GROUPNAME , PolledData.LASTCOUNTERVALUE , PolledData.LASTTIMEVALUE , PolledData.TIMEVAL , PolledData.POLICYNAME , PolledData.THRESHOLDLIST , PolledData.DNSNAME , PolledData.SUFFIX , PolledData.STATSDATATABLENAME , PolledData.POLLERNAME , PolledData.FAILURECOUNT , PolledData.FAILURETHRESHOLD , PolledData.OWNERNAME , PolledData.PARENTOBJ , PolledData.PROTOCOL , PolledData.SAVEPOLLCOUNT , PolledData.CURRENTSAVECOUNT , PolledData.SAVEONTHRESHOLD , PolledData.SNMPVERSION , PolledData.USERNAME , PolledData.CONTEXTNAME,m1.PROPNAME,m1.PROPVAL FROM PolledData,POLLUSERPROPS m1 WHERE (((((PolledData.AGENT = 'backup'))) AND (((PolledData.POLICYNAME = 'Utilisation de l'espace de stockage'))))) AND m1.NAME=*PolledData.NAME AND m1.AGENT=*PolledData.AGENT AND m1.OID=*PolledData.OID GROUP BY PolledData.NAME , PolledData.ID , PolledData.AGENT , PolledData.COMMUNITY , PolledData.PERIOD , PolledData.ACTIVE , PolledData.OID , PolledData.LOGDIRECTLY , PolledData.LOGFILE , PolledData.SSAVE , PolledData.THRESHOLD , PolledData.ISMULTIPLEPOLLEDDATA , PolledData.PREVIOUSSEVERITY , PolledData.NUMERICTYPE , PolledData.SAVEABSOLUTES , PolledData.TIMEAVG , PolledData.PORT , PolledData.WEBNMS , PolledData.GROUPNAME , PolledData.LASTCOUNTERVALUE , PolledData.LASTTIMEVALUE , PolledData.TIMEVAL , PolledData.POLICYNAME , PolledData.THRESHOLDLIST , PolledData.DNSNAME , PolledData.SUFFIX , PolledData.STATSDATATABLENAME , PolledData.POLLERNAME , PolledData.FAILURECOUNT , PolledData.FAILURETHRESHOLD , PolledData.OWNERNAME , PolledData.PARENTOBJ , PolledData.PROTOCOL , PolledData.SAVEPOLLCOUNT , PolledData.CURRENTSAVECOUNT , PolledData.SAVEONTHRESHOLD , PolledData.SNMPVERSION , PolledData.USERNAME , PolledData.CONTEXTNAME,m1.PROPNAME,m1.PROPVAL HAVING ((((((PolledData.AGENT = 'backup'))) AND (((PolledData.POLICYNAME = 'Utilisation de l'espace de stockage'))))) )
13:56:13:687 PM DatabaseProduct = 3:DatabaseName=MSSQL
13:56:13:687 PM com.adventnet.nms.poll.NmsPollException: Line 1: Incorrect syntax near 'espace'.
(And then a full java stack)
Now I know this is the error (since I changed the name and it works fine now) and won't use such names, but I wanted to let you know so you can improve the interface !
Rapha�l LEMIEUX
(Is there a "RIGHT" place to post or mail this kind of bug report ?)
I dont know where is the best place to submit this, but I found a "bug".
When creating a custom monitor, the interface allow the ' character, however, when trying to change the Treshold on the monitor with a name containing a ', an error occur, since it screw up the SQL query.
Here's an example of what I got in the Error Log when I clicked Ok on the Treshold change pane.
13:56:13:687 PM Exception while executing the SQL SELECT PolledData.NAME , PolledData.ID , PolledData.AGENT , PolledData.COMMUNITY , PolledData.PERIOD , PolledData.ACTIVE , PolledData.OID , PolledData.LOGDIRECTLY , PolledData.LOGFILE , PolledData.SSAVE , PolledData.THRESHOLD , PolledData.ISMULTIPLEPOLLEDDATA , PolledData.PREVIOUSSEVERITY , PolledData.NUMERICTYPE , PolledData.SAVEABSOLUTES , PolledData.TIMEAVG , PolledData.PORT , PolledData.WEBNMS , PolledData.GROUPNAME , PolledData.LASTCOUNTERVALUE , PolledData.LASTTIMEVALUE , PolledData.TIMEVAL , PolledData.POLICYNAME , PolledData.THRESHOLDLIST , PolledData.DNSNAME , PolledData.SUFFIX , PolledData.STATSDATATABLENAME , PolledData.POLLERNAME , PolledData.FAILURECOUNT , PolledData.FAILURETHRESHOLD , PolledData.OWNERNAME , PolledData.PARENTOBJ , PolledData.PROTOCOL , PolledData.SAVEPOLLCOUNT , PolledData.CURRENTSAVECOUNT , PolledData.SAVEONTHRESHOLD , PolledData.SNMPVERSION , PolledData.USERNAME , PolledData.CONTEXTNAME,m1.PROPNAME,m1.PROPVAL FROM PolledData,POLLUSERPROPS m1 WHERE (((((PolledData.AGENT = 'backup'))) AND (((PolledData.POLICYNAME = 'Utilisation de l'espace de stockage'))))) AND m1.NAME=*PolledData.NAME AND m1.AGENT=*PolledData.AGENT AND m1.OID=*PolledData.OID GROUP BY PolledData.NAME , PolledData.ID , PolledData.AGENT , PolledData.COMMUNITY , PolledData.PERIOD , PolledData.ACTIVE , PolledData.OID , PolledData.LOGDIRECTLY , PolledData.LOGFILE , PolledData.SSAVE , PolledData.THRESHOLD , PolledData.ISMULTIPLEPOLLEDDATA , PolledData.PREVIOUSSEVERITY , PolledData.NUMERICTYPE , PolledData.SAVEABSOLUTES , PolledData.TIMEAVG , PolledData.PORT , PolledData.WEBNMS , PolledData.GROUPNAME , PolledData.LASTCOUNTERVALUE , PolledData.LASTTIMEVALUE , PolledData.TIMEVAL , PolledData.POLICYNAME , PolledData.THRESHOLDLIST , PolledData.DNSNAME , PolledData.SUFFIX , PolledData.STATSDATATABLENAME , PolledData.POLLERNAME , PolledData.FAILURECOUNT , PolledData.FAILURETHRESHOLD , PolledData.OWNERNAME , PolledData.PARENTOBJ , PolledData.PROTOCOL , PolledData.SAVEPOLLCOUNT , PolledData.CURRENTSAVECOUNT , PolledData.SAVEONTHRESHOLD , PolledData.SNMPVERSION , PolledData.USERNAME , PolledData.CONTEXTNAME,m1.PROPNAME,m1.PROPVAL HAVING ((((((PolledData.AGENT = 'backup'))) AND (((PolledData.POLICYNAME = 'Utilisation de l'espace de stockage'))))) )
13:56:13:687 PM DatabaseProduct = 3:DatabaseName=MSSQL
13:56:13:687 PM com.adventnet.nms.poll.NmsPollException: Line 1: Incorrect syntax near 'espace'.
(And then a full java stack)
Now I know this is the error (since I changed the name and it works fine now) and won't use such names, but I wanted to let you know so you can improve the interface !
Rapha�l LEMIEUX
(Is there a "RIGHT" place to post or mail this kind of bug report ?)