The dashboard on Symantec Brightmail Gateway is not accurate
Last Updated January 17, 2012
You notice that the dashboard is missing some data.
The BrightmailLog.Log has errors similar to the following:
Aug 04 2010 07:30:08 [BrightmailScheduler_Worker-10] ERROR -
com.brightmail.dl.DataAccessException: An unexpected database error has occurred. Please contact your system administrator. ; nested exception is:
java.sql.SQLException: Duplicate entry 'ywiqew7647' for key 2
This is usually the result of a crashed database table or other loss of database integrity.
The current workaround is to restart the control center service.
Login using SSH as admin to the Control Center
Stop the Control Center application cli> service controlcenter stop
Start the Control Center application cli> service controlcenter start
Run a check and repair of the Control Center database. This may take some time if a large amount of log and statistics data have been accumulated. cli> cc-config database --repair
The Control Center should begin to accumulate statistics data within ten minutes of the service restart. If not, then either a more aggressive repair of the affected database table will be required or some other issue is preventing statistics accumulation.
Stats randomly stops processing
Imported Document ID: TECH138143
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe