NetXMS Support Forum

I'm getting this error message in my logs after upgrading from 1.2.17 to 2.0.1.

[13-Jan-2016 15:31:14.661] [ERROR] SQL query failed (Query = "INSERT INTO snmp_trap_log (trap_id,trap_timestamp,ip_addr,object_id,trap_oid,trap_varlist) VALUES (15678756,1452717074,'192.168.2.2',18337,'.1.3.6.1.4.1.9.9.315.0.0.1','.1.3.6.1.2.1.2.2.1.1.10141 == ''10141''; .1.3.6.1.2.1.31.1.1.1.1.10141 == ''GigabitEthernet1/0/41''; .1.3.6.1.4.1.9.9.315.1.2.1.1.10.10141 == ''ðÞñü~â''')"): Unclosed quotation mark after the character string '.1.3.6.1.2.1.2.2.1.1.10141 == '10141'; .1.3.6.1.2.1.31.1.1.1.1.10141 == 'GigabitEthernet1/0/41'; .1.3.6.1.4.1.9.9.315.1.2.1.1.10.10141 == ''.

It looks like the quote characters are messing up the query.  Is there something I need to do to correct this, or is there a work around?

Twice now I've had the DCI's in multiple templates disappear.  The most recent occurrence was this past weekend.  I'm the only one with management access so I know it's not something I've done.  It's frustrating to have to re-create these DCI's.  This time I'm going to export them to ease re-creating them, but the bigger issue is why are they disappearing?  What do I need to do to debug this issue?

I have an Aruba wireless controller which sends traps when an access point goes down, unfortunately it sends 4 of the same trap (which I've verified by sniffing the traffic).  Since one of the actions in my Event Policy is to send an email, I get 4 of the same email when this occurrs.  The Alarm Browser window shows a count of 4, so I know my Alarm Key is okay.  Is there a way to limit the number of emails to 1?  Would I need to use situations?  Is the Alarm Count available via a NXSL script for use in an Event Filtering script?

Thanks!