While Executing Write Record Smart Service in Process Model getting error :- Unable to write to or delete from the source due to a data integrity violation. Error Details: Column 'TaskStatus' cannot be null

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

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?

In the Process History or in the whole process Execution the taskStatus never becomes null, But in the tomcat logs we are seeing that the taskStatus is trying to write null values but via process taskStatus will always have the value.