Duplicate GUID issue in ec_alert Table for Monitor Solution

Article:TECH215726  |  Created: 2014-03-11  |  Updated: 2014-03-11  |  Article URL http://www.symantec.com/docs/TECH215726
Article Type
Technical Solution



Subject

Issue



A duplicate GUID error in the ec_alert table referencing an issue with a primary key keeps showing up in the Server logs on the NS.  It can eventually cause alerts to stop triggering.


Error



( Exception Details: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ec_alert'. Cannot insert duplicate key in object 'dbo.ec_alert'. The duplicate key value is (60b32377-7c0a-4f4f-82cc-182aae50595d)"
 

*Note the GUID referenced will be different and may be different every time the error occurs.


Environment



Windows Server 2008 R2

Symantec Management Platform 7.1 - 7.5


Cause



The cause of this issue is unknown at this time.


Solution



This issue can be resolved by completely purging the tables ec_alert and ec_alert_pooled.

To purge the tables open Microsoft SQL Server Management Studio and run the following queries:

delete from ec_alert

delete from ec_alert_pooled

This should clear all of the data in the tables and allow the Event Console to function normally thereafter. 




Article URL http://www.symantec.com/docs/TECH215726


Terms of use for this information are found in Legal Notices