Error when doing HTML Report from MySQL Database

[agdunn]

We have just recently moved our repository to a MySQL database and have been very happy with the performance. However when we do the html report sometimes this error occurs:

'Can't create/write to file D:\Temp\#sql_c38_0.MYI' (Errcode: 13)'

The #sql_* file is always different, but the error code is the same.

One machine hosts the DB, and the website... we also use EA on that machine to generate the html report:

Windows Server 2003 R2
IIS 6.0
MySQL 5.0.67-community-nt
Sparx EA 7.1

This error is a database issue, so I immediately hit the MySQL forums to find out if it has happened to others. The common denominator seemed to be Antivirus software.

Our system is running Mcafee AV with ondemand scan enabled. So immedietly I disabled ondemand scan and have not seen the issue re-appear.