Bug ID 948113: User-defined report scheduling fails

Last Modified: May 29, 2024

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

Known Affected Versions:
13.1.0, 13.1.0.1, 13.1.0.2, 13.1.0.3, 13.1.0.4, 13.1.0.5, 13.1.0.6, 13.1.0.7, 13.1.0.8, 13.1.1, 13.1.1.2, 13.1.1.3, 13.1.1.4, 13.1.1.5, 13.1.3, 13.1.3.1, 13.1.3.2, 13.1.3.3, 13.1.3.4, 13.1.3.5, 13.1.3.6, 13.1.4, 13.1.4.1, 14.0.0, 14.0.0.1, 14.0.0.2, 14.0.0.3, 14.0.0.4, 14.0.0.5, 14.0.1, 14.0.1.1, 14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.5, 14.1.0.6, 14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3, 14.1.2.4, 14.1.2.5, 14.1.2.6, 14.1.2.7, 14.1.2.8, 14.1.3, 14.1.3.1, 14.1.4, 14.1.4.1, 14.1.4.2, 14.1.4.3, 14.1.4.4, 15.0.0, 15.0.1, 15.0.1.1, 15.0.1.2, 15.0.1.3, 15.0.1.4, 15.1.0, 15.1.0.1, 15.1.0.2, 15.1.0.3, 15.1.0.4, 15.1.0.5, 15.1.1, 15.1.2, 15.1.2.1, 15.1.3, 15.1.3.1, 15.1.4, 16.0.0, 16.0.0.1, 16.0.1, 16.0.1.1, 16.0.1.2, 16.1.0, 16.1.1

Fixed In:
17.0.0, 16.1.2, 15.1.4.1, 14.1.4.5, 13.1.5

Opened: Sep 24, 2020

Severity: 4-Minor

Symptoms

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'

Impact

Internal error for AVR report for ASM pre-defined.

Conditions

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

Workaround

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