Last Modified: Dec 07, 2023
Affected Product(s):
BIG-IP AFM, AVR
Opened: Mar 10, 2022 Severity: 3-Major
When generating a 'DNS Profiles' report from a multi-bladed platform, monpd generates the following error. SELECT SQL_CALC_FOUND_ROWS name `name`, FACT.id `id`,sum(noerrors) `avg_noerrors`,sum(queries) `avg_queries`,sum(rejects) `avg_rejects` FROM AVR_TMP_MERGE_STEP2 FACT WHERE FACT.id <> -2 AND FACT.id <> -1 GROUP BY 2 HAVING ( NOT ISNULL (avg_noerrors) OR NOT ISNULL (avg_queries) OR NOT ISNULL (avg_rejects) ) ORDER BY avg_noerrors DESC LIMIT 10 Because : Unknown column 'noerrors' in 'field list' REPORTER|ERROR|Mar 01 18:54:59.932|5623|../src/reporter/handlers/ReportRunnerHandler.cpp:runReport:0409| Results for query came back as NULL REPORTER|ERROR|Mar 01 18:54:59.932|5623|../src/reporter/ReporterUtils.cpp:throwInternalException:0105| throwing exception to client error code is 1 error msg is Internal error
Errors under monpd.log file. Report for DNS-profile fails.
1. Generating AVR report for a DNS profile on a chassis 2. BIG-IP v14.X installed
None
None