LogAnalyzer shows 65535 years and percentages not valid

Wabiloo · Post by **Wabiloo** » Mon Feb 23, 2009 4:15 am

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 · Post by **KS-Soft Europe** » Mon Feb 23, 2009 6:26 am

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 · Post by **Wabiloo** » Mon Feb 23, 2009 6:34 am

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 · Post by **KS-Soft Europe** » Mon Feb 23, 2009 6:46 am

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

Regards,
Max