Why do my violation statistics appear inconsistently in Symantec Mail Security for Microsoft Exchange (SMSMSE)?
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:
All future violations should now display on the console homepage and in reports.
Document discussing Access database limits: https://support.office.com/en-us/article/Access-2010-specifications-1e521481-7f9a-46f7-8ed9-ea9dff1fa854