I created a PI tag that references a table linked to AF. The AF table updates when the value changes on the Db but the PI tag does not. Any ideas on how to fix this?
Are you writing to the PI Tag using the PI Analysis Service? If you are, the analysis will need to be set to periodic rather than Event Triggered.
Hope this helps!
I'd like to add to Sebastien's answer that if not using an analysis, Indirect references only work if they reference PI Point attributes. More on that here: PI Server
If you're using an analysis, you may be running into KB01531 - Asset Analytics Analysis not Updating Properly with TableLookUp Data Reference Input Attribute
I've tried both event triggered and period. I've adjusted the interval for periodic multiple times as well. I tried Mathews suggestion for KB01531, the issue isn't the table updating it's with the analysis updating the PI tag.
First off, for a time-series call, tablelookup supports data pipes, so event trigger should work. Above, it was implied that periodic only works. I believe that is incorrect.
Just curious, have you change the table's cache interval from manual refresh to something more reasonable like 60 seconds? Is the table set to impersonate the client or is a password supplied? It could be the analytics service does not have permission to read the table. Within PI System Explorer can you preview the results? Any errors in the event log?
Retrieving data ...