Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TABLEENTRIES_1." The conflict occurred in database "RE7Database", table "dbo.CODETABLES", column "CODETABLESID".

When working in a gift record and attempting to add a benefit type to the Benefits code table an error appears. The full error is Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TABLEENTRIES_1." The conflict occurred in database "RE7Database", table "dbo.CODETABLES", column "CODETABLESID". Native error: 547
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. Native error: 3621.
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Log into the Raiser's Edge
  2. Navigate to Config > Tables > Benefits 
  3. There will be benefits listed
  4. When attempting to add a new one, there is no option to add a unit value
  5. Navigate to a Constituent Record
  6. Add a new gift to the constituent
  7. Add gift information
  8. Select the Benefits option
  9. Type in a new benefit type 
  10. Error appears

Environment

 Raiser's Edge
 7.93
 RE 7.93.5782.2

Was this article helpful?