Product: ImportOmatic

Description: This solution describes how to resolve the Error: General ODBC Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert the value NULL into column 'RESPONSE', table 'RE7_Sample.dbo.ConstituentContactConsent'; column does not allow nulls. INSERT fails.

Native error:515

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The statement has been terminated.

Native error:3621
Environment: All

Versions: RE 7.96 patch 8 and higher and IOM and higher


This error occurs when importing consent records, but the Response field is either not mapped or blank in the data file. If all the rows being imported have the same response you can use a Virtual Field to import this data, otherwise add a column for the response in the data file and populate with the response.

Refer to the ImportOmatic User Guide for additional information.