Return
-
Title
Event log archiving fails with "Error: Violation of UNIQUE KEY constraint 'IX_tblEventDefinition_AlertFormatCode'. Cannot insert duplicate key in object 'dbo.tblEventDefinition'. The statement has been terminated." -
Description
Database archiving fails with error message: **Warning(s)** An error has occurred. Will retry in 30 seconds. This is retry 1 of 10. Error: Violation of UNIQUE KEY constraint 'IX_tblEventDefinition_AlertFormatCode'. Cannot insert duplicate key in object 'dbo.tblEventDefinition'. The statement has been terminated. -
Resolution
Open SQL Server Management Studio.
Expand Databases.
Right click the "Archive Database" and select "New Query".
Execute the SQL query below:
Delete tblEventDefinition
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Support and Development.Quest Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.For customization of the Active Administrator, please contact our Professional Services Organization.