Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'RECORDS' with unique index 'UK_RECORDS_1'. Native error:2601 & [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been term

When saving a new constituent record, opening or saving a new education relationship, or importing downloaded NetSolutions Donations, users may receive any of the following errors: 
  • Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'RECORDS' with unique index 'UK_RECORDS_1'.  Native error:2601  
    [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.  Native error:3621
     
  • Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.EDUCATION' with unique index 'UK_EDUCATION_1'. Native error: 2601
    [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native error: 3621.
  • Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'DBO.OPXGUIDMAP' with unique index 'I_OPXGUIDMAP_1'. Native error:2601. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. Native error:3621.
This can be caused due to a corruption in the import IDs of a constituent and/or education relationship.
Download and run the Regenerate Import ID's plug-in.

OR

Rebuild Indexes

Environment

 Duplicated in version 7.70.874

Was this article helpful?