---
title: "Cannot insert the value NULL into column [ColumnName]"
description: "Cannot insert the value NULL into column [ColumnName]"
keywords: "Cannot insert the value NULL into column [ColumnName] NAV SQL error message"
url: "https://myrapidi.com/wiki/cannot_insert_the_value_null_into_column_columnname"
locale: "en"
published: "2025-01-13T12:29:37Z"
modified: "2025-01-13T12:29:51Z"
---

**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** :

1. Identify the fields causing the issue (`SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Table' AND IS_NULLABLE = 'NO'`).
2. Validate and clean the source data before importing.