NetXMS Support Forum

Hi!
Im testing NetXMS and so far so good. I have installed it on a w10 vm with sql server 2014 and deployed a bunch of agents for testing purposes.

I have been playing with this powerful tool for about 2 weeks and learning a lot of things

Now i have detected a lot of errors in event viewer under system category in every windows machine with agent installed

SQL query failed (Query = "SELECT guid,type,server_info,server_id,version,content_hash FROM agent_policy"): no such column: content_hash

This event is happening on every configuration poll


Thanks in advance!

Hi,

Do you mean you deployed sql server 2014 for your NetXMS database?

What version of the agent are you deploying?

How are you deploying it?

Please post the nxagentd.conf from a machine with the error.

Please post a screenshot from the event log.

Ted

Hi and thanks for your answer.

The server runs great, all good, sql is working fine everything works just normal.

The problem is the event generated in the windows computers with agent installed.




This is the nxagentd.conf:

#
# NetXMS agent configuration file
# Created by agent installer at Wed May  6 09:58:42 2020
#

MasterServers = 192.168.0.10
ConfigIncludeDir = C:\NetXMS\etc\nxagentd.conf.d
LogFile = {syslog}
FileStore = C:\NetXMS\var
SubAgent = winperf.nsm
SubAgent = wmi.nsm

Hi,

this is bug in the agent that should have been fixed in version 3.3.314. Try to upgrade agent to that version if not already done, and then delete agent's local database file (usually C:\Windows\system32\config\systemprofile\AppData\Local\nxagentd\nxagentd.db) and restart agent. It should re-create database with correct structure.

Best regards,
Victor

Thanks, that fixed the issue!