In web interface: monitoring->Events:
SQL error [ORA-00933: comando SQL no terminado correctamente] in [SELECT DISTINCT t.triggerid FROM triggers t, functions f, items as i WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND (i.hostid NOT IN (10012,10020,10003,10023,10018,10022,10019,10024,1 0008,10021,10013,10001,10014,10011,10009,10016,100 07,10015,10004,10010,10002,10017))]
the error is "items as i" in oracle the syntax is "items i"
Thanks
SQL error [ORA-00933: comando SQL no terminado correctamente] in [SELECT DISTINCT t.triggerid FROM triggers t, functions f, items as i WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND (i.hostid NOT IN (10012,10020,10003,10023,10018,10022,10019,10024,1 0008,10021,10013,10001,10014,10011,10009,10016,100 07,10015,10004,10010,10002,10017))]
the error is "items as i" in oracle the syntax is "items i"
Thanks
Comment