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 'CONSENT_DATE', 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 3.5.1.0 and higher

Answer: 


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

Refer to the ImportOmatic User Guide for additional information.