Log Analyzer issue, not displaying all test-information

When you post information about some problem, please include the following details: - OS version (e.g. Windows 2000 Professional SP3); HostMonitor version; problem description.
Post Reply
martint
Posts: 3
Joined: Mon May 25, 2009 2:04 am
Location: Netherlands

Log Analyzer issue, not displaying all test-information

Post by martint »

Hello,

I have a problem using LogAnalyzer.

I'm using SQL2005 Express to log to using ODBC.
OS = Windows Server 2003 R2, Standard, UK version.
Dual Xeon @ 3Ghz., 2GB RAM.
HostMonitor itself + logging are working perfect.
All records are logged in SQL2005 Express correctly.

Problem 1:
When starting LogAnalyzer (from the machine where HM + SQL are running) I can correctly connect via ODBC with the SQL server.
Data is received from the DB, and displayed.
Some tests don't show information in the columns:
Period, Alive Time, Dead Time, Unknown.
The columns Average, Min and Max remain empty too.
(HM did record data in the SQL DB though, which i can view using SQL Management Studio).

Problem 2:
When starting LogAnalyzer from another machine on the network.
All tests display data in column 'period, alive time, dead time, unknown', except, there are some tests, which don't show data in column 'Average, Min, Max).
For example. Alive time = 100%, dead time = 0%, unknown time = 0%
Column Average+Min+Max should/could be filled with data because all the data is logged/stored in the SQL DB, and Alive/dead/unknown is filled here too.
Why won't the column's 'average/min/max' not be filled / calculated ?

It seems this only goes wrong with 'Performance Counter Tests'.
(again: data seems to be stored in SQL correctly)

Hope you can give me an answer.

regards,

Martin
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Post by KS-Soft Europe »

Could you provide more information, please?
- What version of HostMonitor do you use?
- What Windows do you use? Service Pack?
- What version of LogAnalyzer do you use?
martint wrote:Some tests don't show information in the columns:
Period, Alive Time, Dead Time, Unknown.
LogAnalyzer requires at least two records in the log for particular test to calculate statistics. Also problem might be caused by different decimal separator symbol, different data format, etc. LogAnalyzer provides a special "Use fixed date&time format" options, located in "Options" -> "Interface" tab.
martint wrote:The columns Average, Min and Max remain empty too.
Average, Min and Max counters depend on "Reply" value. I see two possible causes:
1. "Reply" value is 0 or empty for all log records for this particular test.
2. "Reply" value contains some characters, that cannot be converted to number.
Could you, please, select data from log table for the particulare test (e.g. Select * from YourTable where TestName = 'some test')? You may use "Microsoft SQL Server management Studio" to query this information.

Regards,
Max
martint
Posts: 3
Joined: Mon May 25, 2009 2:04 am
Location: Netherlands

SOLVED: Changed country settings to UK (123,456,789.00)

Post by martint »

On the server where HM resides (and where LogAnalyzer works good (concerning: PerfCounterTests):
- Windows 2003 R2, SP2
- HostMonitor 7.78
- LogAnalyzer 5.48


On the workstation where the PerfCounterTests show empty 'Average/Min/Max' Columns:
- Windows XP Professional SP3
- RCC 2.78
- LogAnalyzer 5.48
WAN connection with above HM / SQL server

-> LogAnalyzer requires at least two records in the log for particular test to calculate statistics
I've selected one test in SQL. Showed up with 1601 rows, so there are more than two records

LogAnalyzer provides a special "Use fixed date&time format" options, located in "Options" -> "Interface" tab.
I tried both settings. Both don't seem to correct the problem.

SOLVED:
Changing 'Country settings' in Control panel from Dutch (123.456.789,00) to English / UK (123,456,789.00) fixed this issue


Thanks for the info Max.
KS-Soft
Posts: 12887
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

That's right - if you are using character (string) field for Reply value you should use the same regional options (decimal separator) on systems where HostMonitor and Log Analyzer are installed.

Regards
Alex
Post Reply