AnsweredAssumed Answered

after a crash we have a datapoint with out of sequence timestamp and on summaries, error "[-11122] Out of sequence data event in sumnav object"

Question asked by p2cl2 on Apr 13, 2017
Latest reply on Apr 21, 2017 by Steve Boyko

Our PI Data Archive server hardware crashed a few weeks ago due to a power problem. This has (I believe) resulted in a strange datapoint being added that is out of sequence.

If I look at the last recorded points prior to the crash on a test tag I get...

      "timestamp" : -- Wed, 22 Mar 2017 23:10:42.625 GMT ... expected

      "timestamp" : -- Wed, 22 Mar 2017 23:10:52.264 GMT ... with a value of 1042

      "timestamp" : -- Wed, 22 Mar 2017 23:11:02.109 GMT ... expected

      "timestamp" : -- Wed, 22 Mar 2017 23:11:13.078 GMT ... expected

      "timestamp" : -- Wed, 22 Mar 2017 23:11:22.953 GMT ... expected

      "timestamp" : -- Wed, 22 Mar 2017 23:10:52.264 GMT ... with a value of 1042 so seemingly identical to the earlier point

... so it looks as if a datapoint has been added to the archive twice and when I ask for summaries starting before, and ending after this datapoint I get the -11122 error

I will try and manually delete that problem datapoint once I have understood the issues but does anyone have any thoughts about ways to handle this error

TIA

Steve

Outcomes