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

Question

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:-

mukeshs429429 · Accepted Answer

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.

Shubham Aware · Answer

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&rsquo;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

Stefan Helzle · Answer

Somewhere in your setup there is a definition of that field to not allow null values.

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

Top Replies