Skip to main content
M
mukeshs429429
August 12, 2025
Solved

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

  • August 12, 2025
  • 13 replies
  • 0 views

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

Best answer by mukeshs429429

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.

13 replies

shubhama926776
shubhama926776
August 12, 2025
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

M
mukeshs429429Author
August 12, 2025

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.

shubhama926776
shubhama926776
August 12, 2025

Thanks for clarifying details.
Did taskStatus arrive as NULL from the Related Action, or did it become NULL during process execution?

stefanhelzle0001
stefanhelzle0001
August 12, 2025

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

M
mukeshs429429Author
August 12, 2025

Hi Stefan,

Could you please elaborate what your trying to say? What kind Definition of the Field is not allowing?

stefanhelzle0001
stefanhelzle0001
August 12, 2025

When using a database backed record, the field definition in the DB dictates whether a field can/cannot contain a null value.

Terms & ConditionsAccessibility statement