I just uploaded a bunch of historic data into a PI system for lab analysis that have an associated SQC Alarm Point, how can I backfill the SQC status point?
I made some research and also looked at the documentation of PI Real-Time SQC and the legacy version of SQC is working with the PI Alarm subsystem. This subsystem works only with the PI Update Manager. So the only way to have it calculate SQC is to feed it with in-order data. This means you would need to delete all values in the archive for the time period you need and send the value in-order ( oldest to newest.). I would liked to have a better option for this ...
The other option I can propose you is to move to PI AF-based version SQC: PI Server - SQC Analyses
With this option you could easily backfill with the PI analysis service. But SQC results may be different from what you are actually using, so you'd need to see if this fits for you.
If you need help to proceed with the deletion and feed data in order, please let us know, our technical support team can help you with this task.
Hope this helps,
That was what I did, the SQC alarms were there and I fed the points in order from oldest to newest but the status point is not updated as the data is fed in....
Is it possible that you still had a recent value in the snapshot?
When a value arrives to the PI Data Archive, its timestamp is compared to the latest value ( snapshot), and if the new value is older than the latest value it goes to the archive directly, this is what we are calling "out of order events".
One way to verify if this is happening is to look at the Statistics. (In PI SMT: Operation>Snapshot and Archive Statistics).
If the server was not restarted, you should see the count of out of order events greater than 0.
If this is the case, this means that probably your snapshot was not reset when you started to backfill the data.
There are few ways to delete the snapshot events that are explained here:
3065OSI8 - How to delete archive and snapshot events
I invite you to contact our technical support engineers in case you need assistance or if you are uncertain of the procedure to follow.
Let us know how it goes,
Retrieving data ...