Bug ID 703196: Reports for AVR are missing data

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP ASM, AVR, LTM, PEM, SWG, vCMP(all modules)

Known Affected Versions:
11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10, 12.1.2, 12.1.3,,,,,,,, 12.1.4,, 12.1.5,,,, 12.1.6

Fixed In:

Opened: Jan 23, 2018

Severity: 3-Major


Some data collected by AVR is missing on some aggregation levels and thus missing from the reports.


Expected AVR statistics may be missing.


Using AVR statistics.


Run the following shell command on BIG-IP: sed -i "s|\(\s\)*SET\ p_aggr_to_ts.*$|$1$(grep "SET p_aggr_to_ts" /var/avr/avr_srv_code.sql | sed 's/truncate(/CEILING/' | sed 's/,0)//')|" /var/avr/avr_srv_code.sql

Fix Information

Time-range selection for aggregation is fixed and now statistics should be aggregated correctly to the next level.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips