Solution found: "Cannot insert the value NULL into column...column does not allow nulls. INSERT fails. The statement has been terminated."

JMCM — Wed, 03 Dec 2025 06:38:35 GMT

Found a solution to the following error that I was getting when trying to create a new record in a Workforce layer, whether I did this via Survey123, the Workforce Dispatch page, or ArcGIS Pro:

All of my existing (and the new) records had priority and other required domain fields filled in, so that wasn't the issue as the error indicated.

The fix was to create a new field, then delete the new test field. The layer allowed record creation after that.

Re: Solution found: "Cannot insert the value NULL into column...column does not allow nulls. INSERT fails. The statement has been terminated.&quo

DanielFox1 — Tue, 23 Dec 2025 15:04:28 GMT

@JMCM

Thank you for sharing this solution with us. To help others I have pasted the solution below and marked it as a solution

"The fix was to create a new field, then delete the new test field. The layer allowed record creation after that"

topic Re: Solution found: "Cannot insert the value NULL into column...column does not allow nulls. INSERT fails. The statement has been terminated.&quo in ArcGIS Online Questions

Solution found: "Cannot insert the value NULL into column...column does not allow nulls. INSERT fails. The statement has been terminated."

Re: Solution found: "Cannot insert the value NULL into column...column does not allow nulls. INSERT fails. The statement has been terminated.&quo