Moved SQL queries to use ExternalMetric instead more control over connections and errors that way so in general better way so far.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menu2024.03.18 10:34:20.066 *I* [db.drv ] Database driver "mssql.ddr" loaded and initialized successfully
2024.03.18 10:34:20.098 *D* [db.conn ] New DB connection opened: handle=000002538F7AD490
2024.03.18 10:34:20.098 *I* [dbquery ] Connected to database "db1"
2024.03.18 10:34:20.113 *I* [subagents ] Subagent "DBQUERY" (dbquery.nsm) loaded successfully (version 4.4.2)
2024.03.18 10:40:18.546 *I* [db.drv ] Database driver "mssql.ddr" loaded and initialized successfully
2024.03.18 10:40:18.546 *W* [dbquery ] Cannot connect to database "db1" ([Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)
2024.03.18 10:40:18.546 *I* [subagents ] Subagent "DBQUERY" (dbquery.nsm) loaded successfully (version 4.4.2)
DebugLevel = 6
LogFile = C:\NetXMS\log\log.txt
MasterServers = *.*.*.*
ConfigIncludeDir = C:\NetXMS\etc\nxagentd.conf.d
FileStore = C:\NetXMS\var
SubAgent = winperf.nsm
SubAgent = dbquery.nsm
*DBQUERY
Database = id=db1;driver=mssql.ddr;server=server;dbname=db;login=user;password=pwd
Quote from: Victor Kirhenshtein on February 29, 2024, 06:04:13 PMHi,Windows 11 23H2 installed with installer and i have dark theme in OS
on what operating system and what client (standalone jar, from installer)? Also, Do you have dark theme in the OS?
Best regards,
Victor
Quote from: Alex Kirhenshtein on September 20, 2023, 02:29:27 PMDo you have any non-Ethernet interfaces there with MAC address longer than 6 bytes?not that i can see
2023.09.20 09:45:19.570 *D* [ndd.common ] NetworkDeviceDriver::getInterfaces(0x7f0dae84c740): completed, ifList=0x7f0db5c81300
2023.09.20 09:45:21.466 *I* [logger ] Log file opened (rotation policy 2, max size 16777216)
2023.09.20 09:45:21.466 *I* [startup ] Starting NetXMS server version 4.4.2 build tag 4.4-568-g3a9a8aa557
2023.09.20 09:45:18.722 *D* [node.iface ] Node::getInterfaceList(node=TPFIBSW02 [10402]): calling driver (useIfXTable=true)
2023.09.20 09:45:18.722 *D* [ndd.common ] NetworkDeviceDriver::getInterfaces(0x7f0dae84c740,true)
Quote from: Alex Kirhenshtein on September 15, 2023, 10:40:07 AMI though all the =? values was for log obfuscation but even the trace on the SQL server only shows =? i guess that would cause this issue since a lot of the columns are int and it tries to update ? into that.Quote from: MarcusH on September 15, 2023, 10:30:30 AMAny way to figure out what creates this query?It's executed by object syncer thread, which saves node changes back into the database.
From the error message it's unclear which field is not accepted by the SQL server, this link might help with tracing it: https://stackoverflow.com/a/62905763