Hi All,
Below is one of the issue we are facing it an intermittent issue. While Executing Write Record Smart Service for the Process Models we are getting the below error:- Unable to write to or delete from the source due to a data integrity violation.Error Details: Column 'TaskStatus' cannot be null.
The TaskStatus is set to NotNull in Database . We have always value set or Update in taskStatus Field before Executing the Write Record Service Node. Below is the Screenshot attached.
attaching the logs screenshot as well for the issue:-
Discussion posts and replies are publicly visible
Somewhere in your setup there is a definition of that field to not allow null values.
Hi Stefan,
Could you please elaborate what your trying to say? What kind Definition of the Field is not allowing?
When using a database backed record, the field definition in the DB dictates whether a field can/cannot contain a null value.
Thats Correct the Field doestnot accept the Null Values. But via Process we are not sending any null values to the write records still we are recieving the error. Again for the Same process its intermittent issue. its dont occure all the time. And when its occurs as well the field has a value its not null.
Can you share the config of that write records node?
Hi Stefan, below is the snapshot.
You wrote this is a related action with no UI. How do you pass data to the action?
We pass the data from Related Action where the Process Model is linked for a Action as a parameter variable we are sending the data to process from the Record Action.
OK. The issue might be, that rv!record is a partially populated record (https://appian.rocks/2024/01/16/partially-populated-records/). Then your expression might, or might not, return valid data.