Scenario: Happens when mandatory fields in NAV tables are left blank during an INSERT or UPDATE.
Error Message: Cannot insert the value NULL into column [ColumnName]
Cause: The field has a NOT NULL constraint, and the source data has missing values.
Resolution:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Table' AND IS_NULLABLE = 'NO').