Last Modified: Apr 28, 2025
                                            Affected Product(s):
                                            BIG-IP ASM, AVR, LTM, PEM, SWG, vCMP
                                        
                                            Known Affected Versions:
                                            11.5.4, 11.5.4 HF1, 11.5.4 HF2, 11.5.4 HF3, 11.5.4 HF4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 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
                                
                                    
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
Time-range selection for aggregation is fixed and now statistics should be aggregated correctly to the next level.