NetXMS Support Forum

Hi,

I need help with importing database file into new NetXMS database.
I have followed instruction to create database backup with instruction nxdbmgr export export_file.
Export file has created without error but in proces of importing  this file into fresh NetXMS database i have got error:

"SQL query failed (Incorrect integer value: "" for column 'port_rows'. I have put complete error message in attachment.
Obviously, something is wrong with database data but application is working fine without any error or warning for this node.
If anybody have advice what can I do to avoid this importing error please help me.

Thanks,
Tomislav

Thanks for help,

Maybe I didn't describe problem with port and interface show enough.
On the object browser tab a can see all interface of every switches and on the object details tab I can see overview, alarms, last value and performace as well.
But when I select Interface or Ports tab on Object Details for some switches interface table and ports is not show (or stay on last switch port list). Also, when I select tab overview after selection of ports or interface I got error. I sent you error picture in the attachment.

I have check information data in Overview tab for all switches and I can see anything suspected or wrong.
In my system I use cisco SF500 and SF500 stacked switches.


best regards,
Tomislav

Thanks a lot,

I have changed "View all alarm categories" permission for admin and now I can see all alarms for any node and after resolve all alarms node goes to normal state.
Also, I have changes propagation status as Critical -Warning and now I get warning alert for port down on switch.
Now I have only one problem with interface and port view on object details tabs, for some switch I can see interface table and ports but
for other ports tab is empty and interface tab is not refresh with list of interface. Problem usually with stacked switch but find same problem with normal switch. If you have some advice how I can resolve this bugs please help me.

Have you experience with new future Outstanding alarm remainder. I have set one sound for this option but I when alarm occured noting hapened.?
Is there any server parameter to set time of outstanding reminder?


best regards,
Tomislav

Dears,

I upgraded NeteXMS server from 2.0.8 to 2.1 version but in new version I got same strange notification and error in work of server.
First, at a few cisco switch server can't show port view and list of interface. After I change tab on Object details server generate message box with error
"An Error has occurred when activation this view" (attach). I have never seen this message before in the old version of server.
Second problem is status of some nodes. For a example, after one of interface goes down node change status to critical. When this interface go to normal state
node go to some strange "Minor" state. I have checked all alarms of this node and interface status and all is in the normal state but icon of node is still o "Minor" state. When this occurred I can only recreate this node (delete and create new node) to change his status to normal.

Also, I have question how I can change events severity level for interface down of some node from "Critical" to "Warning" or "Minor".

If anybody have some idea to resolve these problem please help me.

best regards,
Tomislav

Hi,

I need help with cleaning database of NetXMS. I saw that some table on database name like tdata_record_xxx and tdata_rows_xxx is  grown up every day, a few Gb.
I check data on this table and it's look like some archive of data collection polling.

Does NetXMS application have some purge tools for cleaning this data in database and how I can reduce filling this data on the database.
Maybe I can clean it with other tools but I wouldn't like drop or clean some table because that will occur crash application at all.

Thanks for any suggestion and advice,

with best regards,
Tomislav

Thank you Victor,

I am try generate alarm with different keys and it's works fine.

with best regards,

Tomislav

Hi,

I need one help with alarm presentation on the alarm browser table.
When I generate alarms for one node (after receive some traps of this node) in NetXMS server all alarms from one node come in one line on the alarm browser table
independently of type, index or alarm severity.
After one next alarm generated on server for the same node counter increase number a alarm message line only show last alarm description.
It's not logical because there is many different alarms with different severity and line show only last incoming alarm.

After I double click on this line I can see all alarms in count on the alarm details table and that is great.

Is there any way to separate all new alarm with different message or severity or different index of alarm and show it in new line on the alarm browser table.

Maybe in server parameters exist some variable to change rule of alarm count and showing on the alarm table.

Please if anybody have solution for this please help me with some advice.

Thanks,
Tomislav

Thanks Victor,

Best regards,
Tomislav

Hi Victor,

I am using netxms-2.0.7-x64.exe, last version of NetXMS server.
I am trying use reversed IP address of remote server 42.228.19.172 as you described in your post and its working excellent. It's working!!!!!!! Yeees!!!
I spend two day of analyzing this problem.
Victor, thank you a lot.
As anyone send this bug to the NetXMS develop team? If aren't I will send it.

with best regards,
Tomislav

Thank you for your replay.

I have already check connection with paping aplication and ping and connection on port 4702 is established correctly.

Connecting to 172.19.228.42 on TCP 4702:

Connected to 172.19.228.42: time=1.00ms protocol=TCP port=4702
Connected to 172.19.228.42: time=1.00ms protocol=TCP port=4702
Connected to 172.19.228.42: time=1.00ms protocol=TCP port=4702
Connected to 172.19.228.42: time=1.00ms protocol=TCP port=4702

Connection statistics:
        Attempted = 4, Connected = 4, Failed = 0 (0.00%)
Approximate connection times:
        Minimum = 1.00ms, Maximum = 1.00ms, Average = 1.00ms

Is there some variable on source manager where is forward port defined?

with best regards,
Tomislav

Hi,
I have two Netxms Servers with identical events and rules configuration and I want forward events from one to another server.

Both server are installed on the Win7 system and it's connected on the switch in one VLAN.
On the both server firewall is turned off.

I've set the following settings - EnableISCListener and ReceiveForwardedEvents to destination server and restarted the core. On the main server I have created new action type "forward event" with IP address 172.19.228.42 of slave server and I have created rules for some event with forward action.
After alert have occurred on the main server it has nothing sent to slave server. I have check log file on the main server and there is following log
[27-Dec-2016 14:54:25.114] [DEBUG] *actions* Executing action 1 (ForwardEventTo_172.19.228.42) of type FORWARD EVENT
[27-Dec-2016 14:54:25.114] [DEBUG] *actions* Forwarding event to "172.19.228.42"
[27-Dec-2016 14:54:30.121] [WARN ] Failed to forward event to server 172.19.228.42: Connect failed

I have run wireshark on the main sever but nothing is receiving the data on port 4702.

Any ideas is there something I've missed?

Tomislav

Hi Guys,

At first, NETXMS application is excellent solution for SNMP management. I have used this application for two week and I'm think that this SNMP manager it is great choice.

I have two question
1. First problem is pushing value to target node when user select acknowledge on specific alarm on the list.
One of node specific parameters as described as "activeAlertlsAcknowledged" and it has read/write access.
How I can recognize action of user Acknowledge and make some script to activate write(push) value to this specific node parameters?
.
2. Second problem is how create repeated sound for alarms which will be terminated after user select a Acknowledge state of target alarm.

Please if someone have any idea how to resolve these requirements and make script for these action please help me.

Thanks,
Tomislav