General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key work in object 'dbo.GiftNotepad' with unique index 'UK_GIFTNOTEPAD_1'. When saving a Gift Record with a Notepad

When saving a gift record that includes a notepad, users may get the following error:

General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot insert duplicate key row in object 'dbo.GiftNotepad'
with unique index 'UK_GIFTNOTEPAD_1'. The duplicate key value
is (#############).
Native error:2601
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement
has been terminated.
Native error:3621


Users may also see this error as an exception when committing a gift batch when the gift includes notepad fields.
Download and run the Regenerate Import IDs plug-in for the table GIFTNOTEPAD.  

Please Note: If your software is hosted through Blackbaud Hosting Services, this plugin is pre-installed.

Environment

 Raiser's Edge

Was this article helpful?