The dashboard on Symantec Brightmail Gateway is not accurate
search cancel

The dashboard on Symantec Brightmail Gateway is not accurate

book

Article ID: 152677

calendar_today

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.

  1. Login using SSH as admin to the Control Center
  2. Stop the Control Center application
    cli> service controlcenter stop
  3. Start the Control Center application
    cli> service controlcenter start
  4. 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.