<turbo-stream action="update" target="wiki_card"><template>

<h1>Cannot insert the value NULL into column [ColumnName]</h1>
<div class="trix-content"><p><strong>Scenario</strong>: Happens when mandatory fields in NAV tables are left blank during an INSERT or UPDATE.<br><br><strong>Error Message</strong>: <code>Cannot insert the value NULL into column [ColumnName]</code><br><br><strong>Cause</strong>: The field has a NOT NULL constraint, and the source data has missing values.<br><br><strong>Resolution</strong>:<br><br></p><ol><li>Identify the fields causing the issue (<code>SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Table' AND IS_NULLABLE = 'NO'</code>).</li><li>Validate and clean the source data before importing.</li></ol><div><br></div></div>
</template></turbo-stream>

