Skip to main content
P
padmanabhr582914
February 24, 2026
Solved

database error while insert

  • February 24, 2026
  • 3 replies
  • 0 views

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 

Best answer by harshas2775

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.

3 replies

harshas2775
harshas2775Answer
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.

    shubhama926776
    shubhama926776
    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
      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