Is this a problem that i need to worry about or change? or is there something i can check to see if it is a dci causing the problem.
[08-Aug-2017 13:04:05.627] [ERROR] SQL query failed (Query = "INSERT INTO tdata_56226 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)"): [Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error
this is a new node (56226) that i just recreated after deleting the previous incarnation of this device. I have about 200 nodes that are all doing this . I haven't checked them all but any that i have map to dell powerconnect switches.
These messages are filling the log files. Is the simple solution to set LogFailedSQLQueries = no and ignore it or am I just covering up a bigger problem.
Thx.
info:
server = netxms2.1.0 on win 2012r2 with MSSQL2014 (upgraded from 2.1rc1)
device = Dell Powerconnect 5524
driver = DELL-PWC
Template DCI's:
"ID","Origin","Description","Parameter","Data Type","Polling Interval","Retention Time","Status","Thresholds","Template"
"224355","SNMP","Switch: Stack Info",".1.3.6.1.4.1.89.53.14.1.1","<< TABLE >>","custom schedule","default","Active","",""
"224354","SNMP","Switch: Software Version",".1.3.6.1.4.1.674.10895.3000.1.2.100.4.0","String","custom schedule","default","Active","",""
"224353","SNMP","Switch: Service Tag",".1.3.6.1.4.1.674.10895.3000.1.2.100.8.1.4.1","String","custom schedule","default","Active","",""
"224352","SNMP","Switch: Port Information",".1.3.6.1.4.1.89.53.3.1.1","<< TABLE >>","7200","default","Active","",""
"224356","SNMP","Switch: Stack Units",".1.3.6.1.4.1.89.53.8.0","Integer","custom schedule","default","Active","",""
"224351","SNMP","Switch: Physical Serial Number",".1.3.6.1.4.1.674.10895.3000.1.2.100.8.1.2.1","String","custom schedule","default","Active","",""
"224350","SNMP","Switch: Model",".1.3.6.1.4.1.674.10895.3000.1.2.100.1.0","String","custom schedule","default","Active","",""
"224349","SNMP","Switch: Global Status",".1.3.6.1.4.1.674.10895.3000.1.2.110.1.0","Integer","3600","default","Active","last(1) == 5",""
Hi,
it's definitely a bug in the server. Do you have errors only for this node or for multiple nodes? It is tdata table that means values for some table DCI are not stored in database. What table DCIs you have on this node? Can you check which of them will not show history?
Best regards,
Victor
Thx for the quick reply,
Yes there are about 200 or so objects doing this....
The 2 table dci's are "Switch: Stack Info" and "Switch: Port Information"
and you pointed me to the "history" which yes whenever the "TABLE" dci's are polled the error shows in the log file and no new history is recorded. Any newly created/recreated objects have no history being kept and any old objects only show history from rc1.
FYI: here is a copy of the template
What DB driver you are using - mssql.ddr or odbc.ddr?
Best regards,
Victor
mssql.ddr [Microsoft][SQL Server Native Client 10.0]
Microsoft SQL Server Management Studio 12.0.4100.1
Microsoft Analysis Services Client Tools 12.0.4100.1
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600 (2012r2)
I've found bug in MS SQL driver. Please try to replace your existing mssql.ddr with attached one - SQL errors should disappear.
Best regards,
Victor
Thx, That did the trick. History is now being kept on table DCI's.