Dear all,

I’m working on a few analyses that calculate monthly weighted average for concentrations based on laboratories analysis and accumulated monthly mass.

The formula for the third day, for example is:

MonthlyConcentrationDay3= ((ConcentrationDay1*MassDay1)+(ConcentrationDay2*MassDay2)+(ConcentrationDay3*MassDay3))/( MassDay1+ MassDay3+ MassDay3)

This can be simplified using the previous monthly values, which should already available. Therefore, the generic formula is:

MonthlyConcentration_{DayN}= ((MonthlyConcentration_{DayN-1}*AccumulatedMass_{DayN-1})+(Concentration_{DayN}*Mass_{DayN}))/(AccumulatedMass_{DayN}).

I’m using the generic version and it works fine when executed daily by the scheduling. However, when recalculated by backfill it fails if the previous day concentration is been calculated on the same backfill iteration leading to “Calc Failed” on the subsequent days.

Besides that, each backfill execution is able to calculate the first day that failed on the previous backfill, leading me to understand that the backfill is “too fast” and doesn’t give data archive enough time to write the calculated value and make it available for the calculation of the next day.

Is it possible to make the analysis wait for the data archive, if the problem is caused by the backfill speed?

The following print is a sample of the actual analysis translated to English. On the actual analysis the last variable is mapped to the attribute "Concentration - Monthly", which is used on the first variable.

Note: All the attributes are Pi Points and the daily and monthly mass attributes are calculated by previous analysis.

Thank you,

Gustavo

Hello Gustavo,

My understanding is that if an analysis uses a previous value of it's output as an input, it will retrieve the data from it's local data cache rather than make an RPC to the PI Data Archive. These types of inputs are referred to I/O (input/output) attributes. This is true for both real time and backfilling/recalculating operations.

I believe you may be running into the following known issue: https://techsupport.osisoft.com/Troubleshooting/Known-Issues/91541

Which version of Asset Analytics are you running?

Does preview results return the correct results?

Thanks,

Seb