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.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6

Fixed In:
14.0.0, 13.1.3.2

Opened: Jan 23, 2018

Severity: 3-Major

Symptoms

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

Impact

Expected AVR statistics may be missing.

Conditions

Using AVR statistics.

Workaround

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