I have a simple analysis that writes Table Lookup attribute values to other PI Point attributes. When I evaluate the analysis, it shows the same good value for the analysis variable that references the attribute. But when I backfill, even just from ~5m ago to present, it always writes "Calc Failed" to the output attributes.
I used the Preview Results feature and the variable referencing the table lookup has an error message: "Table [table name] was not available for attribute [attribute name] at query time.
Does anyone know why this message was returned and/or how to fix it?