database error while insert

Question

Hi All, 
 
 I'm encountering an insert error into database in the process model below. a non-null field is being fed a null value and the insert is failing! Please let me know how to debug this error. 
 
 Thanks, 
 Raj

Harsha Sharma · Answer

You need to make sure that this field with not null constraint must have a value before the write to db node. So check the flow where the value should be configured for this field and verify no conditions/flows are skipping this part.

Shubham Aware · Answer

supportingDocumentId is null -> it's hitting a NOT NULL DB column in the "Write to Selected CAN Table" node.
Trace back to "Update Selected CANs" step and ensure supportingDocumentId is being set before the write or make DB column nullable.