4 Replies Latest reply on Apr 21, 2017 7:57 PM by Steve Boyko

    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"

    p2cl2

      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