Hi Victor,
it seems that any newly detected device will not be put into the database. In the Eventlog there ist following error message repeating:
---8<----
SQL query failed (Query = "INSERT INTO nodes (primary_ip,primary_name,snmp_port,node_flags,snmp_version,community,status_poll_type,agent_port,auth_method,secret,snmp_oid,uname,agent_version,platform_name,poller_node_id,zone_guid,proxy_node,snmp_proxy,icmp_proxy,required_polls,use_ifxtable,usm_auth_password,usm_priv_password,usm_methods,snmp_sys_name,bridge_base_addr,down_since,driver_name,rack_image_front,rack_position,rack_height,rack_id,boot_time,agent_cache_mode,snmp_sys_contact,snmp_sys_location,last_agent_comm_time,syslog_msg_count,snmp_trap_count,node_type,node_subtype,ssh_login,ssh_password,ssh_proxy,chassis_id,port_rows,port_numbering_scheme,agent_comp_mode,tunnel_id,lldp_id,fail_time_snmp,fail_time_agent,runtime_flags,rack_orientation,rack_image_rear,agent_id,agent_cert_subject,hypervisor_type,hypervisor_info,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): table nodes has no column named rack_image_front
--->8---
During runtime the devices could be treated normally, but after a Restart of the Netxms Server they are all vanished. I assume because they where never in the database.
I suppose somewhere in the Migration path the additional Column "rack_image_front" is not added correctly. Also the table check of nxdbmgr claims all ok, even if this column is missed. I think this should be fixed.
Meanwhile I set up a completely new instance of Netxms and it is now working as expected. Due to all Devices where missed either, it was not worth to repair the old database.
I use SQLite database. In the Version before it was mariaDB.
Thank you for your help and sorry for the late answer.
Best Regards
Martin
it seems that any newly detected device will not be put into the database. In the Eventlog there ist following error message repeating:
---8<----
SQL query failed (Query = "INSERT INTO nodes (primary_ip,primary_name,snmp_port,node_flags,snmp_version,community,status_poll_type,agent_port,auth_method,secret,snmp_oid,uname,agent_version,platform_name,poller_node_id,zone_guid,proxy_node,snmp_proxy,icmp_proxy,required_polls,use_ifxtable,usm_auth_password,usm_priv_password,usm_methods,snmp_sys_name,bridge_base_addr,down_since,driver_name,rack_image_front,rack_position,rack_height,rack_id,boot_time,agent_cache_mode,snmp_sys_contact,snmp_sys_location,last_agent_comm_time,syslog_msg_count,snmp_trap_count,node_type,node_subtype,ssh_login,ssh_password,ssh_proxy,chassis_id,port_rows,port_numbering_scheme,agent_comp_mode,tunnel_id,lldp_id,fail_time_snmp,fail_time_agent,runtime_flags,rack_orientation,rack_image_rear,agent_id,agent_cert_subject,hypervisor_type,hypervisor_info,id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): table nodes has no column named rack_image_front
--->8---
During runtime the devices could be treated normally, but after a Restart of the Netxms Server they are all vanished. I assume because they where never in the database.
I suppose somewhere in the Migration path the additional Column "rack_image_front" is not added correctly. Also the table check of nxdbmgr claims all ok, even if this column is missed. I think this should be fixed.
Meanwhile I set up a completely new instance of Netxms and it is now working as expected. Due to all Devices where missed either, it was not worth to repair the old database.
I use SQLite database. In the Version before it was mariaDB.
Thank you for your help and sorry for the late answer.
Best Regards
Martin