Error: Access violation at address 10015ED4 in module 'myodb

MirkoW · Post by **MirkoW** » Tue Jul 08, 2008 2:25 am

Hi,

i have create a mysql Database and for logging with HM. i'm using the mysql odbc connector 5.1. After i try to connect with Log Analyzer, i get follow error message:

---------------------------
Error
---------------------------
Source: HostMonitor. Error: Access violation at address 10015ED4 in module 'myodbc5.dll'. Write of address 00000000
---------------------------
OK
---------------------------

KS-Soft · Post by **KS-Soft** » Tue Jul 08, 2008 8:27 am

There are various bugs in MySQL ODBC driver 5.1. Some bugs were fixed in version 5.1.2...
Could you install latest MySQL ODBC driver 5.1.4?
http://dev.mysql.com/downloads/connector/odbc/5.1.html

If you can use old driver, I would recommend to install version 3.51

Regards
Alex

MirkoW · Post by **MirkoW** » Tue Jul 08, 2008 9:59 am

Hi,

after the Latest public Version 5.1 from the Mysql Site i have tried the 3.51 but when i open the Logs with LogViewer so i geht Error Messages with invalid Entrys.

KS-Soft · Post by **KS-Soft** » Tue Jul 08, 2008 10:03 am

What exactly error message do you receive?

Regards
Alex

MirkoW · Post by **MirkoW** » Tue Jul 08, 2008 11:36 pm

Here are the exactly error message:

---------------------------
Error
---------------------------
Source: HostMonitor
Record: 683
Error: Ivalid date

Suspend following warnings?
---------------------------
Yes No
---------------------------

I think te reason for this are disabled tests with zero-filled datefileds

KS-Soft · Post by **KS-Soft** » Wed Jul 09, 2008 6:24 am

HostMonitor should not use empty date for the fields. Could you please check that record (Record: 683)?
What data type do you use to store date? timestamp? text?

Regards
Alex

MirkoW · Post by **MirkoW** » Wed Jul 09, 2008 6:36 am

i'm using the Datetime Format.

Here are row of an invalid Date with Titles:

TESTNAME - STATUS - REPLY - TESTID - TESTMETHOD - RECURRENCES - ID - EVENTTIME

'Print Service', 'Ok', '16 ms', 1244, 'check service', , 932, '2008-07-08 12:55:33'

KS-Soft · Post by **KS-Soft** » Wed Jul 09, 2008 7:16 am

H'm, I don't see anything wrong

Somehow RECURRENCES field is empty but this should not lead to such error.

What version of Log Analyzer do you use?
Could you export table sctructure and some records and send to support@ks-soft.net? or could you provide access to your SQL server?

Regards
Alex

MirkoW · Post by **MirkoW** » Wed Jul 09, 2008 7:56 am

Hi,

i have found the reason

i have removed entrys with emtpy EVENTTIME-Rows like '0000-00-00 00:00:00'

After them i dont get the error message anymore.

I Dont know why LogAnalyser display a wrong Record-ID.

KS-Soft · Post by **KS-Soft** » Wed Jul 09, 2008 8:20 am

May be there was additional filter enabled, like "analyze current week only"?

Regards
Alex

MirkoW · Post by **MirkoW** » Wed Jul 09, 2008 8:21 am

No, i'm using "all data"