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.