Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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
If you setup a constraint in the database, you will have to remove (drop) that constraint. Just deleting the field won't help.
Drop the NOT NULL constraint first, then drop the columnSync the Record Type manually.
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