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
Discussion posts and replies are publicly visible
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