|
View previous topic :: View next topic |
Author |
Message |
mpriess
Joined: 02 Jul 2002 Posts: 112 Location: Arizona, USA
|
Posted: Wed Jun 09, 2004 7:58 am Post subject: ODBC logging configuration |
|
|
Alex,
I've setup ODBC logging as follows:
Insert into HostmonitorLog (TestName, TestID, Agent, TestMethod, TestInterval, ScheduleName, AlertProfile, AlertThreshold, MasterTest, PrivateLog, RelatedURL, TaskComment, Folder, FullPath, FolderComment, CreatedTime, ModifiedTime, DateTime, currentDATE, currentTIME, LastTestTime, Reply, Status, StatusID, SimpleStatus, LastStatus, LastReply, PreviousStatus, PreviousStatusTime, PreviousStatusDuration, PreviousStatusDuration_Sec, Recurrences, StatusChangedTime, StatusChangesCnt, TotalTests, TotalTime, FailedCnt, PassedCnt, UnknownCnt, AliveTime, DeadTime, UnknownTime, AliveRatio, DeadRatio, UnknownRatio, AverageReply, MinReply, MaxReply, HostAddr, ServiceComp, ServiceName) VALUES ('%TestName%', '%TestID%', '%Agent%', '%TestMethod%', '%Interval%','%ScheduleName%', '%AlertProfile%', '%AlertThreshold%', '%MasterTest%', '%PrivateLog%', '%RelatedURL%', '%TaskComment%', '%Folder%', '%FullPath%', '%FolderComment%', '%CreatedTime%', '%ModifiedTime%', '%DateTime%', '%DATE%', '%TIME%', '%LastTestTime%', '%Reply%', '%Status%', '%StatusID%', '%SimpleStatus%', '%LastStatus%', '%LastReply%', '%PreviousStatus%', '%PreviousStatusTime%', '%PreviousStatusDuration%', '%PreviousStatusDuration_Sec%', '%Recurrences%', '%StatusChangedTime%', '%StatusChangesCnt%', '%TotalTests%', '%TotalTime%', '%FailedCnt%', '%PassedCnt%', '%UnknownCnt%', '%AliveTime%', '%DeadTime%', '%UnknownTime%', '%AliveRatio%', '%DeadRatio%', '%UnknownRatio%', '%AverageReply%', '%MinReply%', '%MaxReply%', '%HostAddr%', '%ServiceComp%', '%ServiceName%')
And it works most of the time but I do receive quite a few ODBC errors throughout the day. Here are some of them... Any ideas what the cause of this might be?
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 't'. [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ', ', ', ')'.) Logging initiated by "WEBSHIELD: System Log Errors" test.
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'DACPRO'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 15: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 20: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 30: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 34: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ', ', ')'.) Logging initiated by "DAC-DC2: System Log Errors" test.
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'DAC3812'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 15: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 20: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 30: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 34: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ', ', ')'.) Logging initiated by "DAC-DC4: System Log Errors" test.
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'DACPRO'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 18: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 23: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 33: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Line 37: Incorrect syntax near 'a'. [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ', ', ')'.) Logging initiated by "DAC-DC4: System Log Errors" test.
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near 'HOST'.) Logging initiated by "IBM-MAWEBT1: System Log Errors" test.
ODBC log error. Error code: 4294967295 ([Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '<'.) Logging initiated by "FILE5: System Log Errors" test.
All of the errors seem to be from NT Event Log checks.
Thanks for your assistance,
Mark |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Wed Jun 09, 2004 4:07 pm Post subject: |
|
|
I assume error appears when Reply field contains multiline text or probably Reply field contains quotation marks.
Solutions:
1) disable "Show events description in Reply field" option. Option located on Miscellaneous page in the Options dialog.
If my guess is right, "NT Event Log" test will not produce this error anymore.
or
2) upgrade HostMonitor to version 4.47 (www.ks-soft.net/download/hm447.zip) and use %Reply_CStyle% variable instead of %Reply%
If my guess is right, this error may appear again but not so often.
If I am right, we will add some new variable. E.g. %Reply_1String%
Regards
Alex |
|
Back to top |
|
|
ericm
Joined: 10 Feb 2004 Posts: 40
|
Posted: Tue Jun 29, 2004 5:29 am Post subject: Somewhat related |
|
|
I have odbc setup also and would like to know if there is a way to strip the kb in the traffic test. I want to do a query of the average reply to see what the average traffic is between sites but keep running into a error when it sees the kb in the reply fields. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Tue Jun 29, 2004 9:51 pm Post subject: |
|
|
Looks like you need new macro variable, some %RealReply% or %NumericReply%...
Will try to implement in next version
Regards
Alex |
|
Back to top |
|
|
Quantum
Joined: 06 May 2004 Posts: 56
|
Posted: Thu Sep 02, 2004 8:58 am Post subject: |
|
|
Did the %realreply% ever get done ??
Thanks
-Q
edit: Forget it, found the notes !!
Any chance of getting a numeric only version of the %AlertThreshold% value ?
Thanks
-Q |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Thu Sep 02, 2004 2:07 pm Post subject: |
|
|
Quote: | Any chance of getting a numeric only version of the %AlertThreshold% value ? |
I have added task to the list
Regards
Alex |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|