Skip to main content
S
spencerw418779
February 25, 2026
Question

Data integrity violation

  • February 25, 2026
  • 3 replies
  • 0 views

I am getting the following error when running a process model executed by a record action: 

Details:  Unable to write to or delete from the source due to a data integrity violation. Error Details: (conn=673325) Field 'VECTOR_CREATED_BY' doesn't have a default value

I have tried assigning a default value in the table, changing the default value to a different data type, mapping the field in the record type, and have now dropped the field from the table and the error persists. 

 

Any insight would be appreciated 

3 replies

stefanhelzle0001
stefanhelzle0001
February 25, 2026

If you setup a constraint in the database, you will have to remove (drop) that constraint. Just deleting the field won't help.

shubhama926776
shubhama926776
February 25, 2026

Drop the NOT NULL constraint first, then drop the column
Sync the Record Type manually.

D
darrend090585
February 26, 2026

Experiencing a data integrity violation typically indicates a database constraint conflict most often related to NOT NULL or default value requirements that aren’t satisfied at runtime. Ensuring the schema constraints align with Appian’s record mappings and removing or adjusting constraints where appropriate can help prevent this error and restore record operations smoothly. .net maui mobile app development services and detxt

Terms & ConditionsAccessibility statement