We do not provide support for build process on Windows. Please use pre-build binaries or contact [email protected] for commercial support quite.

Ok, thank you very much

Hi, We have quite a few systems with ICMP polling disabled and only SNMP or Agent enabled. The only time I have seen the behaviour you describe is when the server can't reach the agent. Have you confirmed that the server can contact the node on port 4700? Cheers

Hi, The right-click on a Node MIB Explorer Walk works in 2.1-M3. The MIB Walk Results if called from within a DCI are still broken. While they no longer shows Hex-STRING, they show the SNMP Type in the Value column as per the attached screenshot. Cheers [image: MIB Walk Results.jpg]

Upgrading database... Upgrading from version 410 to 411 Converting table tdata_100:  0%SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error): INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?) failed Rolling back last stage due to upgrade errors... Database upgrade failed C:\NetXMS\bin>nxdbmgr upgrade -t NetXMS Database Manager Version 2.1-M3 Build 9008 (2.1-M3) (UNICODE) Upgrading database... Upgrading from version 410 to 411 >>> SELECT var_value FROM metadata WHERE var_name='TdataTableUpdated' >>> SELECT var_name,var_value FROM metadata WHERE var_name LIKE 'TDataTableCreat ionCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%' >>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va r_name LIKE 'TDataIndexCreationCommand_%' >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not  null,tdata_value text null)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _0','CREATE CLUSTERED INDEX idx_tdata_%d ON tdata_%d(item_id,tdata_timestamp)') >>> SELECT id FROM nodes Converting table tdata_100:  0%>>> EXEC sp_rename 'tdata_100','tdata_temp_100' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_0' >>> CREATE TABLE tdata_100 (item_id integer not null,tdata_timestamp integer not  null,tdata_value text null) >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_1' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_2' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_3' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_4' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_5' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_6' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_7' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_8' >>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_9' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_0' >>> CREATE CLUSTERED INDEX idx_tdata_100 ON tdata_100(item_id,tdata_timestamp) >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_1' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_2' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_3' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_4' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_5' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9' >>> INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?) SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrec t or syntax error): INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?) >>> DROP TABLE tdata_100 >>> EXEC sp_rename 'tdata_temp_100','tdata_100' failed >>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va r_name LIKE 'TDataIndexCreationCommand_%' >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_ timestamp)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not  null,record_id bigint not null,UNIQUE(record_id))') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFE RENCES tdata_%d(record_id) ON DELETE CASCADE)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not nu ll,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) RE FERENCES tdata_records_%d(row_id) ON DELETE CASCADE)') Rolling back last stage due to upgrade errors... Database upgrade failed other update try as below xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx C:\NetXMS\bin>nxdbmgr upgrade NetXMS Database Manager Version 2.1-M3 Build 9008 (2.1-M3) (UNICODE) Upgrading database... Upgrading from version 410 to 411 Converting table tdata_100:  99%SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error): INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?) failed Rolling back last stage due to upgrade errors... Database upgrade failed xxxxxxx >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8' >>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'  99%>>> INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?, ?) SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrec t or syntax error): INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?) >>> DROP TABLE tdata_100 >>> EXEC sp_rename 'tdata_temp_100','tdata_100' failed >>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va r_name LIKE 'TDataIndexCreationCommand_%' >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_ timestamp)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand _2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not  null,record_id bigint not null,UNIQUE(record_id))') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFE RENCES tdata_%d(record_id) ON DELETE CASCADE)') >>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand _2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not nu ll,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) RE FERENCES tdata_records_%d(row_id) ON DELETE CASCADE)') Rolling back last stage due to upgrade errors... Database upgrade failed C:\NetXMS\bin>

Finally! Thank you! works fine now And yes the $ instead of % was a typo above I mostly had it working before but was unaware you needed to actually run 'instance discovery' after a config poll. Some of my old scripts magically started working

Hi, there are few issues already found in 2.1-M3, especially with new back-connect functionality. We plan to release RC version in a week or two, which will be followed by stable 2.1 release. Best regards, Victor

It appears it is very similar, but it does answer my question.  Tried searching but that post didn't show in the results.  Thanks for the link!

Hello, I want to share my solution for tomcat7: Upgrade to Java8 (Alex recomendation): https://tecadmin.net/install-java-8-on-debian/ On  /etc/default/tomcat7 add line JAVA_HOME=/usr/lib/jvm/java-8-oracle, and restart tomcat7 service I deleted my past 2.1-m3 .war's , deploy the new 2.1-m3 .war, and it work Regards

Thank you Victor, I am try generate alarm with different keys and it's works fine. with best regards, Tomislav

I have problem with sendin sms using Huawei USB dongle. Sometimes netxms send sms, sometimes not. I dont know why. My server config is: SMSDrvConfig: /dev/ttyUSB2,9600,8,N,1,T SMSDriver: /usr/lib/i386-linux-gnu/libnxsms_generic.so Debug level is 5. In log i can see: [15-Apr-2017 19:31:55.282] [DEBUG] *actions* Sending SMS to NUMBER1;NUMBER2: "MESSAGE" [15-Apr-2017 19:31:55.282] [DEBUG] SMS sender: rcpt="NUMBER1" text="MESSAGE" [15-Apr-2017 19:31:55.282] [DEBUG] SMS: send to {"NUMBER1"}: {"MESSAGE"} [15-Apr-2017 19:31:57.887] [DEBUG] SMS: ReadToOK: readToMark returned -1 [15-Apr-2017 19:31:58.002] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:31:58.002] [DEBUG] SMS: ATZ sent, got OK [15-Apr-2017 19:31:58.105] [DEBUG] SMS: ReadToOK buffer content: 'ATE0 OK ' [15-Apr-2017 19:31:58.106] [DEBUG] SMS: ATE0 sent, got OK [15-Apr-2017 19:31:58.308] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:31:58.309] [DEBUG] SMS: AT+CMGF=1 sent, got OK [15-Apr-2017 19:32:02.845] [DEBUG] SMS: ReadToOK buffer content: ' +CMGS: 236 OK ' [15-Apr-2017 19:32:02.845] [DEBUG] SMS: AT+CMGS + message body sent, got OK [15-Apr-2017 19:32:02.846] [DEBUG] SMS: serial port closed [15-Apr-2017 19:32:02.846] [DEBUG] SMS sender: rcpt="NUMBER2" text="MESSAGE" [15-Apr-2017 19:32:02.846] [DEBUG] SMS: send to {"NUMBER2"}: {"MESSAGE"} [15-Apr-2017 19:32:05.451] [DEBUG] SMS: ReadToOK: readToMark returned -1 [15-Apr-2017 19:32:05.567] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:05.568] [DEBUG] SMS: ATZ sent, got OK [15-Apr-2017 19:32:05.670] [DEBUG] SMS: ReadToOK buffer content: 'ATE0 OK ' [15-Apr-2017 19:32:05.670] [DEBUG] SMS: ATE0 sent, got OK [15-Apr-2017 19:32:05.874] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:05.874] [DEBUG] SMS: AT+CMGF=1 sent, got OK [15-Apr-2017 19:32:08.576] [DEBUG] SMS: serial port closed [15-Apr-2017 19:32:08.576] [DEBUG] Failed to send SMS (will retry) [15-Apr-2017 19:32:08.577] [DEBUG] SMS: send to {"NUMBER2"}: {"MESSAGE"} [15-Apr-2017 19:32:11.179] [DEBUG] SMS: ReadToOK: readToMark returned -1 [15-Apr-2017 19:32:11.294] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:11.294] [DEBUG] SMS: ATZ sent, got OK [15-Apr-2017 19:32:11.397] [DEBUG] SMS: ReadToOK buffer content: 'ATE0 OK ' [15-Apr-2017 19:32:11.397] [DEBUG] SMS: ATE0 sent, got OK [15-Apr-2017 19:32:11.600] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:11.600] [DEBUG] SMS: AT+CMGF=1 sent, got OK [15-Apr-2017 19:32:14.286] [DEBUG] SMS: serial port closed [15-Apr-2017 19:32:14.286] [DEBUG] Failed to send SMS (will retry) [15-Apr-2017 19:32:14.287] [DEBUG] SMS: send to {"NUMBER2"}: {"MESSAGE"} [15-Apr-2017 19:32:16.891] [DEBUG] SMS: ReadToOK: readToMark returned -1 [15-Apr-2017 19:32:17.005] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:17.005] [DEBUG] SMS: ATZ sent, got OK [15-Apr-2017 19:32:17.107] [DEBUG] SMS: ReadToOK buffer content: 'ATE0 OK ' [15-Apr-2017 19:32:17.107] [DEBUG] SMS: ATE0 sent, got OK [15-Apr-2017 19:32:17.311] [DEBUG] SMS: ReadToOK buffer content: ' OK ' [15-Apr-2017 19:32:17.311] [DEBUG] SMS: AT+CMGF=1 sent, got OK [15-Apr-2017 19:32:19.998] [DEBUG] SMS: serial port closed [15-Apr-2017 19:32:19.998] [DEBUG] Failed to send SMS (will not retry) [15-Apr-2017 19:32:19.998] [DEBUG] Failed to send SMS (complete failure) [15-Apr-2017 19:32:19.999] [DEBUG] EVENT SYS_SMS_FAILURE [30] (ID:3292 F:0x0001 S:1 TAG:"") FROM aida: Unable to send SMS to phone "NUMBER2" I don't know why sms to first number is sent but to second not. But sometimes even sms to first number is not sent. Thanks for your help.

Sorry i cannot test to see if this works as i uninstalled this test server and moved it to a production one. Will test next time though if i get this error again.

External parameter runs on demand, when server requests it. So you effectively control it when setting DCI polling interval. Best regards, Victor

You need one agent in the network to act as proxy. Other than that, you can monitor everything else in that network using SNMP only via the above agent/proxy. Just set that agent as your default proxy for the zone in question and ensure you add the other SNMP devices to that zone.

Thanks Victor for helping me out.

Hi, you have to add object access rights as well. They are assigned in object properties. You can also add your users to Admins group - it should have all object rights assignments already. Best regards, Victor

This seems like a good compromise, I will have to test this. Thanks!

Thanks for your help  As you said, I have to install that on my Client PC and It works.

Hi we have multiple sites which we monitor as well as hosts at each of the sites. These sites are connected via VPN or point to point link. What is the recommended way to set this up so if either VPN or Point to point link goes down then alerts are not sent out for each host but an alert sent out for the site. We are currently running - 2.1-M2. And secondly I notice in the change logs for 2.1-M3  the following is mentioned -  Improved event correlation based on network topology Could you provide more details on what this means. Thanks in advanced.

Thanks a lot this has resolved our issue with overnight daily reboots.   John