Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column '', table 'RaisersEdge7.dbo.DUPLICATE_WORK_CONSTITUENTINFORMATION'; column does not allow nulls. INSERT fails. Native error:515

When running the Duplicate Constituent report, users reported receiving the following error:

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'SPOUSE NAME', table 'RaisersEdge7.dbo.DUPLICATE_WORK_CONSTITUENTINFORMATION'; column does not allow nulls. INSERT fails.
Native error:515
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated. 
Native error: 3621
If you encounter this issue in the latest version and patch of Raiser's Edge please contact support and reference this article.

Environment

 Raiser's Edge
 7.95
 7.92.5508, patch 3

Was this article helpful?