The dashboard on Symantec Brightmail Gateway is not accurate
Article ID: 152677
Updated On:
Products
Messaging Gateway
Issue/Introduction
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
Cause
This is usually the result of a crashed database table or other loss of database integrity.
Resolution
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.
Feedback
Yes
No
Powered by
