Duplicate key in SQL.

Issue

Unable to truncate extended log table past August 2, 2012.

Getting a Duplicate Key error in SQL.

Product Line

Andover Continuum

Environment

  • SQL
  • Extended Logs

Cause

Database corruption. 

Resolution

  • Key duplication indicates that the database integrity has been damaged. 
  • Key duplication cannot be repaired.
  • The customer will have to rebuild their site database.