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
Discussion posts and replies are publicly visible
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.
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.
There is no debugging needed. You either have to remove the non-null constraint in the database, or insert the data with a non-null value.