ODBC logging configuration

[mpriess]

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

[KS-Soft]

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

[ericm]

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.

[KS-Soft]

Looks like you need new macro variable, some %RealReply% or %NumericReply%...
Will try to implement in next version

Regards
Alex

[Quantum]

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

[KS-Soft]