Tag History: Multiple values getting stored with same timestamp

Ignition
1

I'm getting very frequent erros on my gateway:
image

with the message:
"The timestamp 'timestamp' has already been stored for tag 'tagname' "
It happens with multiple tags and over the last few days the error has happened 248 times.

The tags that get flagged in the error messages have all been setup with a periodic sample mode and usually a sample rate of 2 seconds.
I would understand if it logged the values on change with no minimum time between samples, but that's not the case.

Under the store and forward menu I can retry sending the quarantined values and it will send it to the database without any issues.

The data is being sent to an SQLite database which we have no other issues with.
I cant seem to find any posts about this on the forum, but maybe someone else has had the issue in the past and then found a solution for themselves.

2

Extremely common problem if device connections are unstable, or if a device's OPC server is delivering data with quality code "Good, Overload".

Under no circumstances should you ever log history to a SQLite database. That technology is single-threaded and will utterly choke if you push it even a little. SQLite is designed to be used as storage for application configuration, not for dynamic data.

2 Likes