Bug ID 948113: User-defined report scheduling fails

Last Modified: Oct 06, 2020

Bug Tracker

Affected Product:  See more info
BIG-IP ASM(all modules)

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

None

Behavior Change