Hello all, I wanted to share how I have been fixing my DCI collection errors. First, I am using a CentOS based linux server as a NetXMS host, so your commands may be a little different for your OS.
NETXMS DCI Database repair steps:
If DCI errors are reported in Graph Elements perform the following steps from the command line of the NetXMS linux server:
service netxmsd stop
mysqlcheck --auto-repair netxms -u root –p
nxdbmgr check
service netxmsd start
Graph Elements should now populate after a few polls.