Support Article
FIRST aggregate in bucketed window is broken
SA-71533
Summary
FIRST aggregates do not provide the correct results when used in Sliding Time window together with Average aggregate.
Error Messages
Not Applicable
Steps to Reproduce
- Create SlidingTimeWindow (2min) > AVG(A), FIRST(A)
- Insert {A=10,time=10:00}{A=11,time=10:01}{A=12,time=10:02}
Verify the output: {AVG=11.5, FIRST=1} expected: {AVG=11.5,FIRST=11}
Root Cause
A defect in Pegasystems’ code or rules.
Incorrect implementation of FirstAggregatorHolder.substractAggregate which used the propertyIndex to obtain the aggregate value.
Resolution
Update to Pega 8.1.3 patch release.
Published January 20, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.