Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver] The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint FK_SB7DISTRIBUTIONS _SB7DISTRIBUTIONS."

This error can occur when applying payments or credits to charges.
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver] The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint " FK_SB7DISTRIBUTIONS _SB7DISTRIBUTIONS. The conflict occurred in database "FE_5759", table " dbo" SB7DISTRIBUTIONS, column BBDISTRIBUTIONSID  native error 547 Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver] The statement has been terminated Native error:3621

Download and install the latest version and patch, if applicable. 

Environment

 7.86.93
 7.87.164

Was this article helpful?