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 · Accepted 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.

Stefan Helzle · Answer

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.

database error while insert

Top Replies