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?

Hi,

what database you are using?

Best regards,
Victor

Ooops, I should have included that info in the original post.  We are using MS SQL Server 2014.