LogAnalyzer shows 65535 years and percentages not valid

[Wabiloo]

I'm trying to analyze about a year of data (across 2008 and 2009) in LogAnalyzer.
For some reason however, when I load my ODBC logs, most of the tests show a Period of 65535 years (and a few months), and most tests show alive and dead time with percentages that are way above 100%.

For example:
Test 1 / HTTP Test / 65535 years 11 months / 3509370.74% alive / -2241348.26%

I've also noticed that when selecting a test, the log list in the right hand side panel seems to be fairly randomly ordered, with 2008 and 2009 dates interleaved regularly. It is as if LA did not take the year into account when sorting...

I did check that both HMM and LogAnalyzer used the same date format (dd/MM/yyyy)

Any idea what the problem could be?

[KS-Soft Europe]

What exact SQL Server do you use to store ODBC logs? What exact ODBC driver do you use? What field type do you use to store date values?


Regards,
Max

[Wabiloo]

I've actually fixed my problem.
I was trying to use the eventtime column (as text) rather than the eventtimestamp. Using the latter made everything a lot faster and got me correct results as well.

For reference: SQL Server 2005 with SQL Native Client for ODBC connection

[KS-Soft Europe]

Ok. Glad it works for you.
Thank you for your feedback.

Regards,
Max