Why do my violation statistics appear inconsistently in Symantec Mail Security for Microsoft Exchange (SMSMSE)?
New violations are not added to statistics despite being quarantined successfully
Reports fail to generate, or the data within the reports does not make sense
Numbers on the homepage do not make sense
The database that SMSMSE is the Microsoft Access engine, which has a hard 2 gigabyte limit for databases. If the database exceeds this limit, behavior of all functions relying on this database becomes inconsistent.
WARNING: Be aware that the following procedure will clear all existing report data and start from 0 as if the product had just been installed.
Replace the database with a default database:
Download the zip file containing cmaf_db.mdb matching the installed SMSMSE version.
Open the services console (Start -> Run -> services.msc) and stop the Symantec Mail Security for Microsoft Exchange and Symantec Mail Security Utility services.
Navigate to C:\Program Files\Symantec\SMSMSE\<version>\Server\Reports (Program files (x86) on 64 bit OS).
Verify the size of the existing cmaf_db.mdb. If it is over 2GB, rename the file to cmaf_db.old
Copy the new cmaf_db.mdb into the Reports folder.
Start the Symantec Mail Security for Microsoft Exchange and Symantec Mail Security Utility services.
All future violations should now display on the console homepage and in reports.