Skip to main content
padmanabhr582914
New Participant
February 24, 2026
Solved

database error while insert

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 

harshas2775
harshas2775Answer
Brainy
February 26, 2026

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.

Happy to help. Even happier to optimize.
View in thread

3 replies

harshas2775
harshas2775Answer
Brainy
February 26, 2026

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.

Happy to help. Even happier to optimize.
    shubhama926776
    shubhama926776
    Brainy
    February 26, 2026

    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.

    शुभम्
      stefanhelzle0001
      stefanhelzle0001
      Brainy
      February 26, 2026

      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.

        Terms & ConditionsAccessibility statement