Bug ID 948113: User-defined report scheduling fails

Last Modified: Feb 07, 2024

Affected Product(s):
BIG-IP ASM(all modules)

Known Affected Versions:
13.1.0,,,,,,,,, 13.1.1,,,,, 13.1.3,,,,,,, 13.1.4,, 14.0.0,,,,,, 14.0.1,, 14.1.0,,,,,, 14.1.2,,,,,,,,, 14.1.3,, 14.1.4,,,,, 15.0.0, 15.0.1,,,,, 15.1.0,,,,,, 15.1.1, 15.1.2,, 15.1.3,, 15.1.4, 16.0.0,, 16.0.1,,, 16.1.0, 16.1.1

Fixed In:
17.0.0, 16.1.2,,, 13.1.5

Opened: Sep 24, 2020

Severity: 4-Minor


A scheduled report fails to be sent. An error message with the following format may appear on /var/log/avr/monpd.log file (some parts of the error message were replaced with '.....' in here to leave only the common parts): DB|ERROR|....... Error (err-code 1054) executing SQL string : ..... ..... ..... Because : Unknown column ....... in 'order clause'


Internal error for AVR report for ASM pre-defined.


1. Using predefined-report in scheduled-report. 2. Predefined-report has more than one measure. 3. Sort-by value is different from the first measure on predefined-report


First, remount /usr to read-write: mount -o remount,rw /usr Next, open file /usr/share/perl5/vendor_perl/F5/AVReporter/Client.pm and change the following line: push(@measures,@{$base_request->{measures}}[0]); to this: push(@measures,@{$base_request->{sort_by}}[0]->{measure}); The above can be achieved with the following script-line (please first backup the Client.pm file and then verify it changed it correctly): sed -i 's/push(@measures,@{\$base_request->{measures}}\[0\])/push(@measures,@{$base_request->{sort_by}}[0]->{measure})/' /usr/share/perl5/vendor_perl/F5/AVReporter/Client.pm Lastly, remount /usr back to read-only: mount -o remount,ro /usr

Fix Information

Using 'sort-by' measure when building PDF (instead of the first value on measure-list)

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips