KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

Log Analyzer issue, not displaying all test-information

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
martint



Joined: 25 May 2009
Posts: 3
Location: Netherlands

PostPosted: Mon May 25, 2009 2:23 am    Post subject: Log Analyzer issue, not displaying all test-information Reply with quote

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
Back to top
View user's profile Send private message MSN Messenger
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Mon May 25, 2009 3:02 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
martint



Joined: 25 May 2009
Posts: 3
Location: Netherlands

PostPosted: Mon May 25, 2009 5:02 am    Post subject: SOLVED: Changed country settings to UK (123,456,789.00) Reply with quote

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.
Back to top
View user's profile Send private message MSN Messenger
KS-Soft



Joined: 03 Apr 2002
Posts: 12792
Location: USA

PostPosted: Mon May 25, 2009 7:35 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
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

KS-Soft Forum Index