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
mukeshs429429 said: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.
This shouldn’t happen.Have you checked the process instance history to see where TaskStatus becomes null?Also, could you share a snapshot of your process model or provide more details so we can investigate further?
A few possible causes are:TaskStatus is being set to null under specific conditions.Concurrent processes are updating the same record (race condition)A data type mismatch is causing a silent conversion failure
Hi Shubham,
Its a Straight Foward Process which only Update the Status for the Request.
We have check the History of Process Model no where it is set to null,
This is a single user Specific Action Concurrent User cannot perform same action for Same Request ID at same time.
Data Type we have checked its varchar(32) and Record Field its text.
Snapshot of Process attaching below :-
its a record related action no UI is there, the updated taskStatus its get from Related action as a Parameter for Primary Record and then write to record.
Please note this issue we are not facing all the time, Intermittently its occurring.
Let us know what could be missing here.
Thanks for clarifying details.Did taskStatus arrive as NULL from the Related Action, or did it become NULL during process execution?