1 Reply Latest reply on Feb 16, 2016 1:44 PM by Dan Fishman

    PI Notifications not aware of Imported table update

    buse

      Helllo,

       

      Here is my scenario:

       

       

      I have an Imported table in AF that lives in a SQL Database. (Due to security settings, I am not able to Link the table)

      Inside an AF Element I have an attribute that looks up data on the table (Table Lookup data reference).

      This attribute is an input to a formula data reference that is used as trigger for a PI Notification (SQC Rule).

      Basically the table stores thresholds constants.

       

       

       

      Once the notification triggers, in some cases, I am updating the thresholds in the Imported table (in SQL).

      I then reimport the table and reset the notification. (I did this step both through PI System Explorer and AFSDK)

       

      The problem is that the notification is not aware of the table update and it is triggering a new instance eventhough the triggering rule is not being met.

      It is like the old data in the table is being cached somewhere.

      The only way I was able to force the notification to refresh was to restart the PI Analysis Service, but I was hoping I didn't have to do that...

       

      I am using PI Notifications 2012 version 1.2.1205.10 and PI System Explorer 2015 (32 bit) version 2.7.0.6937

      Has anyone seen this behavior? Is there a way to clear the cache programatically?