workitems with state Running not updated after finished/cancelled integration

Hello,
When working on the coin capacity dashboard, we noticed that a large number of integrations do not have an updated state. Currently, we store information in influxdb about the state - eg. Running. To update the state for a given integration it would require to OVERWRITE the exact timestamp (the match would be exact to the nanosecond precision unless we change precision). Why this can be important? When doing statistics about filed/passed workitiem, I highly rely on the state. if the state is inaccurate all the statiics carry a very LARGE ERROR. It also makes it questionable if other states are reported correctly.
In the attachment, I add a sample of data. I executed the query: (16 of December)
"select * from workitem where state = 'Running' and time > now() - 30d and time < now() - 20d"