Skip to main content
December 29, 2025
Question

Regarding write data to records.

  • December 29, 2025
  • 4 replies
  • 0 views

I am getting weired error while saving data to records. I have a table which has onlly three not null column. I am passing values to all of them. But I am getting constraint violation error for createdby_tcxt which is not even not null. I passed value for it as well. I checked DB structure, checked records many times. Even I am getting data into the process model to update. The error is like " Data constraint or integrity violation: the createdby_txt field doesn't have default value. Anyone has any idea why I may be faving this issue.

    4 replies

    December 29, 2025

    If you verified the table/record definition and everything is OK, check if there is a DB trigger that removes the createdby_txt value you tried to insert

    shubhama926776
    December 30, 2025

    Check your Record Type field mappings to ensure createdby_txt is actually mapped to the correct database column.

    kavipriyan695800
    December 31, 2025
    Verify whether any triggers are configured for this table

    stefanhelzle0001
    January 1, 2026

    There MUST be some configuration in the database causing this issue. Triggers and constraints might be a good start to look for. Try manually insert an item.