YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Backfilling performance equations which failed to run... Options · View
MacaroniPI
#1 Posted : Wednesday, August 6, 2008 10:23:57 AM
Rank: Advanced Member
Groups: Member

Joined: 7/16/2008
Posts: 36
Location: UK
Wondering if anyone on here has ever come across the situation where your performance equations have stopped working for a while and you need to fill in all the missing values?

For example.... TagAC is an hourly calculation of TagA....one day it stopped working (lets say the PI server was upgraded ;) and now there is a big gap that looks like this

01/01/1999 01:00 345
01/01/1999 02:00 315
..................................
02/01/1999 15:00 307

Usually I would manually work out the averages and enter this in the archive in the case of a few missed entries, but I'm wondering if theres a smarter way of doing this?
Who ate all the PIs?
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
RJK Solutions
#2 Posted : Wednesday, August 6, 2008 10:40:58 AM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 618
Location: Cheshire, United Kingdom.
Hello....yes I get around this another way, well 2 ways actually.

I wrote a wrapper for performance equations that works on a schedule (excludes data updates to perform equation). All you do is set it is run time (which is set after each run) and it works forward to the current time - so if you have 1 hours gap, set the run time to 1 hour ago. It is actually a bit more complex than that but you get the idea. What you need to consider though is why the PE did not run, if it is because the PI server was down then you probably don't have data for your inputs of your PE.

For another client we actually wrote a frontend for PI-ACE, well ACE was used as the scheduler. All PE were actually written as calculations using VBScript syntax and exposed "some" functions of PI-SDK to end users. This is actually a very good tool, in fact I believe OSI are already coming up with something similar with next releases of AF etc.

Now if you are feeling daring, you could write something yourself to do this using SDK or PI-AF :-)
Principal Consultant
Real-Time Data Management @ Wipro Technologies
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.