NetXMS Support Forum

Hello Community,

i have an issue with a SQL Query. This is how the netxmsd Log looks like. If i have this Error Message NetXMS Service will stop.

2018.02.17 05:48:12.995 *E* SQL query failed (Query = "INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VALUES (1,0,'\004\004')"): 42P01 FEHLER:  Relation idata_1 existiert nicht LINE 1: INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VA...

Any help?

Best Regards

Hi,

seems to be a bug in server. What version you are running and on what OS? Do you have crash dumps?

Best regards,
Victor

Hi,

i run a Debian 9.3.0 (Stretch) with NetXMS 2.2.2
No, i don't have Crash Dumps

Best Regards

Hi,

on Debian core dump generation disabled by default. Please try to enable it and provide us with core file. There are also slight chance that this is known issue fixed in 2.2.3 or upcoming 2.2.4 (will be released within few days).

Best regards,
Victor