Skip to main content
Known Participant
Dec 29, 2025 4:27 PM UTC
Question

Regarding write data to records.

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

    Inspiring
    Dec 29, 2025 8:41 PM UTC

    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
    Brainy
    Dec 30, 2025 5:08 AM UTC

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

    शुभम्
    kavipriyan695800
    Inspiring
    Dec 31, 2025 12:56 PM UTC
    Verify whether any triggers are configured for this table

    stefanhelzle0001
    Brainy
    Jan 1, 2026 10:02 AM UTC

    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.