Skip to Main Content
AVEVA Product Feedback


Status Declined
Created by Guest
Created on Aug 19, 2022

Add support in AF Clients for changes to a single timestamped value in an external system brought into AF using a linked table

A table in an external system (SQL, Oracle, etc...) has a single entry that may change from time to time. When this entry changes, it should be picked up automatically by the PI Analysis Service without an extra "No Data" event. Currently there are some workarounds: 1. Use a PI Point instead of a linked table. 2. Use a static attribute instead of a linked table. 3. Add an extra event in the table at 1-Jan-1970 4. If another PI Point or static attribute updates at the same time as the data in the external system, remove the time context from the table lookup data reference and use this PI Point to trigger the analyses.
  • ADMIN RESPONSE
    Aug 19, 2022
    For this configuration, the external table is being used as "time series" data which comes with it some limitations. One of those limitations is that two values are required in order to interpolate. In the case of an external table such as this example which only has 1 row, it breaks the assumptions for time series data since the only way to get two values is to assume one value as NoData and the other value being the actual value (table row). As such, there is no plan to make any changes to accommodate this use case, which does not fit into the assumption of time series data. As noted, there are several workarounds that may be considered.
  • Attach files