SQL errors - field incorrect or syntax error - is this a problem?
-
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-PWCTemplate 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.
-
-
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login