I see this often. And when I try to retry, it pops up again. Am I losing data?
Not sure why those errors occur, but the tag historian is trying to insert records where the unique constraint on the table is being hit with a duplicate key value; it’s either trying to insert the same data twice, or at least insert records for the same tag and timestamp. Retrying this without resolving the issue will just see them fail again.
Also, there’s a bug with the S+F system where retrying the quarantine will effectively get you back into the same state, since queries are not run individually but are executed within a bulk transaction, and any query that fails will revert the entire transaction… it may be slightly more nuanced than that in that queries may be bundled into more than one bulk transaction, but the result is the same
1 Like
If it is duplicate, will just delete it. We have a ton of data coming in so it is tricky to parse through this.
1 Like