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 attempting to add a table entry to a table, users receive the 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.
Please contact Support with the following information:
  • The name of the table
  • Do you see the table listed when you navigate to Config>Tables?
  • Have you ever been able to add table entries to this table? If so, when was the last time you added a table entry to the table?

Environment

 Raiser's Edge
 7.93
 RE 7.93.5782.2

Was this article helpful?